How to check integrity of partitions
Hello everybody,
I am considering implementing Partitions (on MySQL 5.1.20) to handle a table with GBs of XML data.
My only fear is that, in case of corruption, I would not be able to
1) Spot the corruption (as the main tools to check MySQL tables seems not to work with Partitions)
2) Fix the problems
3) Backup/restore (does mysqlhotcopy work with partitioning?)
Would you please share with me your thoughts and strategies to implement partitioning in the safest possible way?
Regards
Alessandro
Subject
Views
Written By
Posted
How to check integrity of partitions
7403
September 01, 2008 10:07AM
3401
September 04, 2008 12:10PM
3109
October 08, 2008 08:23AM
2940
February 09, 2009 07:40AM
4556
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.