MySQL Forums
Forum List  »  Memory Storage Engine

Re: tmp tables always write to disk
Posted by: Ed Sorrell
Date: July 18, 2007 10:17AM

Additional note:

Before:
Created_tmp_disk_tables 434444
Created_tmp_tables 434444

mysql -u#### -p#### -hhgnmkc02 -e "create temporary table edtest ( f1 int, f2 char(5)) type=heap" test

After:
Created_tmp_disk_tables 434444
Created_tmp_tables 434444

Should Created_tmp_tables have incremented?

The plot thickens, added SQL_SMALL_RESULT to query.
Now

Created_tmp_disk_tables 1400359
Created_tmp_tables 1400290

How can Created_tmp_disk_tables be greater than Created_tmp_tables?



Edited 1 time(s). Last edit at 07/20/2007 08:11AM by Ed Sorrell.

Options: ReplyQuote


Subject
Views
Written By
Posted
9886
July 18, 2007 09:48AM
Re: tmp tables always write to disk
5767
July 18, 2007 10:17AM


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.