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.
Thanks,
Mani
Subject
Views
Written By
Posted
Archive table frequently crashing
7045
October 18, 2010 01:43AM
3652
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.