…. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with SQL rather than…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… care if you don’t want to break replication or corrupt your data. Scenario #2: One of the slaves is behind…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need … dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as we… the first available binary log, which is very likely to corrupt your data by reexecuting some queries. Here’s a trick…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… was saved then ibdata1 should be valid, maybe with some corruption. The tables structure you can get from the dictionary as…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… with a few bug fixes: pt-archiver –bulk-insert may corrupt data pt-heartbeat –utc –check always returns 0 pt-query…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… two conclusions can be make: The page structure is not corrupt You know how many records to expect This is what…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch…
