Re: How to check integrity of partitions
Alessandro, your concerns are very well-founded.
We have been working with a 200GB partitioned table for most of the year, and we've finally decided to just use a MERGE table instead. This is primarily because the MERGE subtables can be handled individually by all the familiar MySQL utilities and standard SQL statements, while the partitions within a partitioned table can not. An incidence of data corruption in one of our partitions last week really drove this point home.
FWIW, you CAN actually use the "myisamchk -r" utility against an individual partition if you shut the database down first. At least, it worked for us last week. The documentation says that this is unsupported, though, so that doesn't engender a lot of confidence that some minor problem like this won't end up trashing your whole database. Even with a good backup, restoring that much data is a major undertaking, and not something I should have to worry about w/ a solid RDBMS.
Subject
Views
Written By
Posted
7150
September 01, 2008 10:07AM
Re: How to check integrity of partitions
3284
September 04, 2008 12:10PM
2956
October 08, 2008 08:23AM
2810
February 09, 2009 07:40AM
4375
February 10, 2009 02:25AM
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.