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?
Need some more information from you. a) Which storage engine are you using? b) What settings for that storage engine exist in your config file? For instance, if InnoDB, then what is the value of innodb_buffer_pool_size? c) What operating system are you using? Cheers, Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
