Questions tagged [percona-tools]

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

Filter by
Sorted by
Tagged with
2
votes
2answers
2k views

any documentation on tpcc-mysql benchmark tool

Where can I find tpcc-mysql documentation? I google it but I can't find any documentation about it.
2
votes
0answers
521 views

innobackupex: What causes Slave_open_temp_tables did not become zero after waiting 15 minutes?

As you might know, in order to assure a consistent replication state, the slave should be backup only when there are no open temporary tables: http://dev.mysql.com/doc/refman/5.5/en/replication-...
2
votes
1answer
1k views

Running pt-table-checksum on a table in different databases

I'm using filters for replication: replicate-wild-do-table = test_slave.% replicate-rewrite-db = test->test_slave Is there an option to specify different DB name on slave for "pt-table-checksum" ...
3
votes
1answer
634 views

pt-table-sync error: Called not_in_left in state 0

I have setup a Mysql replication between 2 servers, using Percona Xtrabackup: Master is a MySQL 5.0.91 Community Edition (CentOS 4.8) Slave is a MySQL 5.1.68 Community Edition (CentOS 6.4) When ...
5
votes
2answers
6k views

Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…? [closed]

I manage a PHP/MySQL website : max 500 simultaneous users / average of 4000 per hour in update/read 1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM) InnoDB Storage engine on 100 tables for 1.4 Go ...
1
vote
0answers
122 views

pt-table-checksum generates no output

I've been using pt-table-checksum on our staging server successfully, but when I run ./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod It just sits there. No ...
2
votes
1answer
790 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
165 views

Why does pt-table-checksum gives exit status 0 if slave is unreachable?

I'm using pt-table-checksum version 2.1.4 for checking my master-slave set up. In the case when I forget to set up the right privileges on the slave, it writes an error to stderr like this: # pt-...
2
votes
1answer
1k views

Do I have to filter the percona.checksums table in replication for use with pt-table-checksum?

I've set up MySQL replication, one master and one slave. Now I just starting to check the data for integrity on both sides by using Percona's pt-table-checksum. Wonderful tool to detect any changes or ...
2
votes
2answers
2k views

Does pt-table-checksum point out rows that are different between Master and Slave?

Trying to verify replication integrity of my replica. And I found that pt-table-checksum is one of the best ways of doing it. I have a simple Master->Slave set up. Have created a sample table with 10 ...
6
votes
3answers
1k views

Finding differences between a master and slave when pt-table-sync fails

I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that. Certain tables in the mix have composite ...
3
votes
3answers
1k views

Is it possible to pass parameters to pt-table-checksum using an options file?

We're using Percona's pt-table-checksum for MySQL replication integrity check. Is it possible to pass some or all of the options using some sort of configuration file? For instance, can we write the ...
4
votes
2answers
5k 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 ...
3
votes
1answer
3k 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 "...
1
vote
1answer
403 views

pt-table-checksum from remote server

I am using pt-table-checksum for the first time and have some questions that I can't seem to resolve by reading the documentation on Percona's website. Per the documentation, pt-table-checksum ...
4
votes
2answers
3k views

pt-table-checksum with slaves using non-standard ports

Trying to run pt-table-checksum to detect slave drift in MySQL replication. My slaves are not using the standard TCP listening port however, and so when I run the tool I get an error: Cannot connect ...
3
votes
1answer
7k 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 --empty-...