Re: tmp tables always write to disk
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.
Subject
Views
Written By
Posted
9838
July 18, 2007 09:48AM
Re: tmp tables always write to disk
5747
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.