WordPress MU

Hi all,

i'm running a wpmu installation with 80k visits a day and 120k pv/day.

I've noticed my created_tmp_disk_tables value beeing very high.

The ratio Created_tmp_disk_tables / (Created_tmp_disk_tables + Created_tmp_tables) is near 50% what means i'm having the same tmp tables being created in disk and memory.

I think the ratio would be something like 1 (disk) to 5 (memory)

these are the values in my.cnf

tmp_table_size = 96M
max_heap_table_size = 96M

I would like to ask other wpmu'ers about your ratio and if this is something related to wordpress mu or i've to start searching problems in some plugins not having indexes.

thanks in advance!
Fernando

I'm having the same problem

I have no idea:

Current max_heap_table_size = 284 M
Current tmp_table_size = 284 M
Of 26755 temp tables, 34% 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

I did find, using the log-queries-not-using-indexes option that there are a couple of tables that seem to be missing indexes. Oh and I found a potential glitch in the wpmufeed.php plugin where it was being forced not to use an index by the inclusion of an empty string check against post_status.