Make sure you don't have dynamic-width rows. Use char instead of varchar. On 2/17/06, Eamon Daly <[EMAIL PROTECTED]> wrote: > 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] > >
-- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
