Re: tmp_disk_tables vs. tmp_tables

2001-03-21 Thread Erik Stephens
> 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

Re: tmp_disk_tables vs. tmp_tables

2001-03-21 Thread Basil Hussain
Hi, > 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

tmp_disk_tables vs. tmp_tables

2001-03-20 Thread Erik Stephens
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