MySQL Forums
Forum List  »  Archive Storage Engine

Archive table frequently crashing
Posted by: Mani C
Date: October 18, 2010 01:43AM

Hi All,

We are running Mysqsl 5.1.34-log community server (on linux) and we have a ARCHIVE table which has around 122280263 records now. There will be more inserts to this table on daily basis.

For reporting also, we use the same table. Data on this table is split across 370 partitions. One partition or the other frequently gets corrupted and we are restoring data as and when they get corrupted.

Server has 2 CPUs and 3G RAM.

Which parameters in my.cnf are corresponds to archive table performance? We would like to tune them and see if we get a solution for this problem.


Options: ReplyQuote

Written By
Archive table frequently crashing
October 18, 2010 01:43AM
November 23, 2010 01:56AM

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.