This worked. Thanks very much for your help! Charles
On 12/1/06, mos <[EMAIL PROTECTED]> wrote:
At 05:37 PM 11/30/2006, Charles Danko wrote: >Hi, > >I am trying to write a new table into main memory, but I am getting an out >of memory error. > >Each entry consists of 2 medium_int and 1 tiny_int variables, and the table >contains just over 100,000,000 rows. By my count, this makes just over >700MB of data. The machine I am using has 2GB, but I am still getting an >out of memory error. What am I doing wrong? > >Thanks! You will likely need to increase the "max_heap_table_size" if you are using MySQL 5.x. This link may be relevant: http://dev.mysql.com/doc/refman/5.0/en/full-table.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
