Hi While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to some of my select statements. Since then have been seeing a lot of created_tmp_disk_tables e.g. below is what I see after restarting the system for less than an hour.
| Created_tmp_disk_tables | 515 | | Created_tmp_tables | 717 | | Created_tmp_files | 0 | I have my temp table variables set to quite high and are fairly certain that my queries are less than 64M (any way to tell?). set-variable = tmp_table_size=64M set-variable = max_tmp_tables=100 set-variable = max_heap_table_size=64M Anything I have done wrong or should look into? Anyway to see what temp tables are being created and what for? regards, Teck Lee --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php