I use mysql a lot. It is the underpinning of these blogs, my online photo albums, my new drupal sites – a lot.
I found this collection of great scripts to help even the seasoned mysql admin tweak some more.
I especially liked the tuning script:
Current long_query_time = 10 sec.
You have 9 out of 8370223 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.
Current table_cache value = 64 tables
You have a total of 288 tables
You have 64 open tables.
Current table_cache hit rate is 0%, while 100% of your table cache is in use
You should probably increase your table_cache
Very nice work. I’ll be working on squeezing that extra 1% out of mysql tomorrow.