MySQL Forums
Forum List  »  Partitioning

Re: How to check integrity of partitions
Posted by: Robert Freeland
Date: September 04, 2008 12:10PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to check integrity of partitions
3284
September 04, 2008 12:10PM


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.