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, ho
> 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 tem
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 number
