Re: MEMORY table size or index size limits
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.
Subject
Views
Written By
Posted
25697
December 09, 2005 12:31PM
12189
December 09, 2005 12:35PM
12037
December 12, 2005 05:25AM
Re: MEMORY table size or index size limits
9859
December 12, 2005 09:16AM
11475
January 03, 2007 07:07AM
8954
January 03, 2007 10:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.