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]
