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