Temp Tables in my .cnf
I've been tweaking a my.cnf file for the last couple weeks, using the tuning primer sh script as a guide. You know the routine, I make my change, restart mysqld, then run the script in a day or two to check improvements.
I'm understanding all of it except for Temp Tables. I always get something like this.
Of 20971 temp tables, 60% were created on disk
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Understanding enormous numbers in SQL status report
Can one of you experts out there help me with this?
In a brand-new, <10 node Drupal 5.1 site running with MySQL 4.1.21 and PHP 5.0.5, on Appache at www.siteground.com
When looking at admin->logs->status->MySQL (4.1.21)
I'm getting some HUGE numbers, where zeros are expected. Can someone provide some guidance or words of wisdom?
Some of the report is listed below. PS--I can't figure out where to get help, no one answers posts at Drupal.org or at siteground.com, and I feel like there's no one out here!!
Read more