Comments on: Deep dive into MySQL’s innochecksum tool https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/ Fri, 16 Feb 2024 22:28:48 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Martin https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comment-10965837 Fri, 29 Jan 2016 20:25:48 +0000 https://www.percona.com/blog/?p=28813#comment-10965837 Muhammad,

thank you for this information.

We have a similar issue with MySQL 5.5.29 and percona xtrabackup 2.2.5-5027.

[01] xtrabackup: Database page corruption detected at page 206334, retrying…
[01] xtrabackup: Error: failed to read page after 10 retries. File /var/lib/mysql/idbdata/idbdata01 seems to be corrupted.

We have parameter innodb_file_per_table set, so idbdata01 should not contain any userdata. Your approach to check which tables are affected by corruption does not seem to work with idbdata01. (show tables is empty)

Can you point me to the right direction?

Best regards,
Martin

]]> By: aftab https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comment-10965598 Tue, 24 Nov 2015 10:33:34 +0000 https://www.percona.com/blog/?p=28813#comment-10965598 @Debjit, agree it’s not a good idea to take full backup of 1/2 TB database daily, so you should take incremental backup:
https://www.percona.com/doc/percona-xtrabackup/2.3/innobackupex/incremental_backups_innobackupex.html

@vaibhav, since you have detected innnodb curruption, have you followed steps mentioned in this blog,

“In order to fix this issue, the first thing you should try is to mysqldump the corrupted table and If mysqldump succeeded then problem exists in secondary indexes for that tablespace. This is because the mysqldump utility doesn’t touch indexes as indexes are created after all rows are inserted…”

]]> By: vaibhav https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comment-10965594 Tue, 24 Nov 2015 04:45:06 +0000 https://www.percona.com/blog/?p=28813#comment-10965594 How can we exclude backup of this corrupted table using xtrabackup even if we use the exclude option still backups fails as xtrabackup is trying to read status all tables.

]]> By: Debjit Saha https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comment-10669194 Mon, 23 Mar 2015 21:36:57 +0000 https://www.percona.com/blog/?p=28813#comment-10669194 How to use this tool for a very large db server ~550GB+ data. Not a good thing to take backup everytime we want to run this tool. Please help.

]]> By: aftab https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comment-10660965 Sat, 21 Mar 2015 10:40:06 +0000 https://www.percona.com/blog/?p=28813#comment-10660965 I think you should have talked about using ” percona data recovery tool ” for recovering currupted data from innodb tables. This is very handy when innodb standard recovery cannot be used.

]]>