Percona Tools : Software Designed for Advanced MySQL/PerconaServer Tasks, Maintenance, and Monitoring

learn more… | top users | synonyms

3
votes
1answer
4k views

Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working

I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands: $ pt-table-checksum h=master,u=user,p=password ...
2
votes
1answer
296 views

Maatkit shows the MySQL replication error in one table, but won't fix it

We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on the master and perform consistency checks on the replica. mk-table-checksum ...
1
vote
1answer
110 views

Native checksum table says there's a difference, pt-table-checksum does not

I was setting up a slave and doing some table checksums to check things were ok before getting them live. I did a native mysql checksum tables on the slaves after syncing slaving to a stopped point ...
3
votes
1answer
658 views

MySQL Handler_read_rnd_next == tablescans without indexes?

I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance. In the MySQL Handlers Plot, i have been noticing alot of ...
3
votes
2answers
3k views

pt-table-checksum help required

I am trying to figure out pt-table-checksum, as I am using it for the first time. It look likes the documentation is complex and not easy to understand stuff. I have a complex replication topology ...