This worked. Thanks very much for your help!
On 12/1/06, mos <mos99@stripped> wrote:
> At 05:37 PM 11/30/2006, Charles Danko wrote:
> >I am trying to write a new table into main memory, but I am getting an
> >of memory error.
> >Each entry consists of 2 medium_int and 1 tiny_int variables, and the
> >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?
> You will likely need to increase the "max_heap_table_size" if you are
> MySQL 5.x.
> This link may be relevant:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1