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
7263
September 01, 2008 10:07AM
3331
September 04, 2008 12:10PM
3026
October 08, 2008 08:23AM
2863
February 09, 2009 07:40AM
4470
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.