MySQL Forums
Forum List  »  Performance

Re: Developers on Crack?
Posted by: Aftab Khan
Date: July 20, 2012 02:35AM

What's the size of max_heap_table_size? The actual limit is determined as the minimum of tmp_table_size and max_heap_table_size.


When the server creates an internal temporary table (either in memory or on disk), it increments the Created_tmp_tables status variable. If the server creates the table on disk (either initially or by converting an in-memory table) it increments the Created_tmp_disk_tables status variable

So you can check how many tables are created in memory and on disk:
SHOW GLOBAL STATUS LIKE 'Cr%';


Some useful readings:
http://dev.mysql.com/doc/refman/5.1/en/internal-temporary-tables.html

Options: ReplyQuote


Subject
Views
Written By
Posted
1453
July 19, 2012 06:47PM
Re: Developers on Crack?
864
July 20, 2012 02:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.