Re: MySQL Performance Tuning Help

[Lloyd Silver]

Thanks for the feedback. I have some additional Drupal-based sites to move over and would like to understand MySQL tuning a bit better before doing so. So I appreciate the assistance.

I'm trying to understand the table_cache value. Both tuning-primer.sh and mysqltuner.pl suggested increasing this value until I got to the 1600 number. I know those programs are inferior to actually understanding what these values mean which is why I'm asking. Right now, I have:

table_cache = 1600
1088 total tables
1137 open tables

open_files_limit = 3250
954 open files

I did decrease connections to 40 for the time being. I also increased the thread_cache_size to 8 based upon some other research.

You suggested decreasing the number down to 200 and I'm not quite understanding that. Intuitively it seems that I should have that number large enough to accommodate the total and/or open tables. So 200 isn't making sense to me based upon my lack of knowledge in this area.

Thanks.