List:General Discussion« Previous MessageNext Message »
From:Charles Danko Date:December 5 2006 2:30pm
Subject:Re: Trying to create a new table in memory.
View as plain text  
This worked.  Thanks very much for your help!

Charles


On 12/1/06, mos <mos99@stripped> 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/mysql?unsub=1
>
>

Thread
Trying to create a new table in memory.Charles Danko1 Dec
  • Re: Trying to create a new table in memory.Jay Pipes1 Dec
  • Re: Trying to create a new table in memory.Nils Meyer1 Dec
    • Re: Trying to create a new table in memory.Charles Danko1 Dec
  • Re: Trying to create a new table in memory.mos2 Dec
    • Re: Trying to create a new table in memory.Charles Danko5 Dec