SHOW STATUS (after 24 hrs uptime): created_tmp_disk_tables = 597 created_tmp_tables = 8893. SHOW VARIABLES: tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB? How can I find these rogue queries and optimise them? I could increase the tmp_table_size (over 1GB RAM) but I am concerned that tables this big are being created! Can this be logged somehow? Thanks, John --------------------------------------------------------------------- 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
