Hi, all. I have a machine with lots of memory, and I'm trying to avoid the disk entirely for some of our larger reports. I was under the impression that CREATE TEMPORARY would create in-memory tables and only write to disk if tmp_table_size is reached, but that doesn't seem to be the case: I've set tmp_table_size to 1G and this particular run is only creating tables under 64M. Using TYPE = MEMORY does what I want it to and only creates .frm files in /tmp:
CREATE TEMPORARY TABLE revenue_data TYPE = MEMORY SELECT * FROM data ...but as we do have reports that might exceed 1G in size, and the MEMORY storage type never converts to on-disk tables, that's really not a good solution. How does MySQL determine whether a table is written to memory or to disk, and is there a way to force the former? ____________________________________________________________ Eamon Daly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
