List:General Discussion« Previous MessageNext Message »
From:John P Date:December 22 2002 12:33am
Subject:Temporary Table Size / Big Queries
View as plain text  
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

Thread
Temporary Table Size / Big QueriesJohn P22 Dec