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
25825
December 09, 2005 12:31PM
12260
December 09, 2005 12:35PM
12100
December 12, 2005 05:25AM
Re: MEMORY table size or index size limits
9923
December 12, 2005 09:16AM
11519
January 03, 2007 07:07AM
9019
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.