There's only one variable that will affect this situation, which is
tmp_table_size. I have mine currently set to 16Mb also. However, your
usage may be the key here. Are your queries optimised and using
indexes in the proper places? Not having queries use indexes is bound
to result in temp
Since you feel that you should never have more than 15 simultaneous
connections at a given time, I don't think modifying max_connections
will help. I would first verify that the PHP code is closing the
connection. If it isn't, then the connection will stay open until it
times out. If you do,
Hello,
We're are a little worried about the ratio of tmp_disk_tables to
tmp_tables. We are assuming the created_tmp_tables from `mysqladmin
extended-status` represents the total number of temporary tables created
and created_tmp_disk_tables from `mysqladmin extended-status` represents
the