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

learn more… | top users | synonyms

3
votes
3answers
355 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 ...
1
vote
1answer
37 views

pt-query-digest results are empty

I have a slow log generated by MySQL 5.1.71-log, that I've copied onto another machine. It appears I'm not getting any results from pt-query-digest. $> pt-query-digest slow.log # 2.1s user time, ...
0
votes
1answer
26 views

Myloader command: Table doesn't exist

I took the backup of mysql database using mydumper command: mydumper -B mydb -o /backup/oct3 -s 500000 -c -m -S /tmp/mysql.sock -u root -p password@123 -v 3 Now, I am restoring mysql database ...
0
votes
1answer
376 views

Strange Locking issues while playing back logs via percona playback

Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...
1
vote
0answers
31 views

pt-online-schema-change with circular replication

So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
1
vote
0answers
169 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: ...
1
vote
0answers
75 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 ...
0
votes
0answers
105 views

How to decrease load time by chunking large file using Percona pt-fifo-split?

I'm loading data into a fresh instance which takes ~48s to load a single file (1G; 2.5m rows). To decrease load time, I tried chunking it into 100k rows using Percona's pt-fifo-split. Unfortunately, ...
0
votes
0answers
50 views

How to efficiently synchronize MySQL slave with secondary mater?

I have a database setup with chained replication: +-----------+ +-----------------+ +----------+ | A: master | <-- | B: slave/master | <-- | C: slave | +-----------+ ...