Re: MEMORY table size or index size limits

[Adrian Biscoveanu]

Since then I changed the engine to MyISam and we're waiting for more RAM. We figured out that the LINUX kernel uses 1GB of RAM, which leaves us with 3G in the current configuration, to be used for all of the other processes we have running. It's obviously not enough to use with the MEMORY engine given the size of our data and the most likely cause for the failure of INSERT. Mea culpa, I did not look at what's returned from mysql_query() when the INSERT stops working but will do and post back (it'll take a while to rebuild the table though).
I appreciate your time and insight,

Adrian.