Re: to merge or not to merge
We have a monitoring system that uses a MyISAM table to store its results. After 7 months the table got 400Mb long (30M lines) and it was not pretty when I had to repair it after a crash.
What I did after is to create a per month table. Moved the data from the original table to the new ones and then myisampack.
Now I have tables of around 30Mb. Historic tables are read-only which makes it faster (no locking) for querying and for recovering (can't get corrupted).
The rw table is for the current month only, so it is not bigger than 4M lines.
Subject
Views
Written By
Posted
5949
April 04, 2005 04:20AM
Re: to merge or not to merge
4039
May 03, 2005 12:28PM
4007
May 06, 2005 03:03AM
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.