Questions tagged [percona-tools]
A collection of software designed for advanced MySQL/PerconaServer tasks, maintenance, and monitoring.
79 questions
1
vote
1
answer
488
views
Using pt-table-checksum to compare a slave's DB to another slave
I understand that pt-table-checksum can do checksum compares between a master's DB and a slave's DB easily.
However, let's say your master has two slaves replicating from it for the same DB, i.e. ...
- 281
1
vote
1
answer
2k
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 ...
- 111
1
vote
0
answers
146
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 ...
- 11
1
vote
1
answer
1k
views
Is there a difference between an xtrabackup taken with and without --safe-slave-backup?
Currently I'm studying Percona's xtrabackup. In the manual in the paragraph "Taking Backups in Replication Environments" it says that using the --safe-slave-backup
option is always recommended and I ...
- 35
2
votes
1
answer
3k
views
Percona's xtrabackup --apply-log fails with "all log files must be created at the same time"
I'm trying to figure out why applying logs on my xtrabackup files isn't working.
I created a VM running MySQL 5.5.24. Then I created the sakila test database and backed it up with the following ...
- 35
4
votes
1
answer
602
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, ...
- 347
1
vote
1
answer
1k
views
pt-table-sync for 3 master servers
We had a mysql multi master with 3 nodes and unfortunately the replication broke. We have some set of tables which has to be in sync with other database servers, so i was looking into Percona-Toolkit ...
- 247
3
votes
2
answers
958
views
Is it possible to remove useless GRANTS in MySQL
I'm using pt-show-grants to create all my GRANTS on a new server but there's lots of old GRANTS that refer to tables that doesn't exist anymore so I get errors when I try to apply the SQL file on the ...
- 215
1
vote
1
answer
2k
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 ...
- 5,263
2
votes
3
answers
2k
views
xtrabackup prepare - after dump or before restore?
i have doubts about xtrabackup --apply-log.
is there any difference when use it? should it be done right after dump or before restore (even few months later)? seems stupid, but maybe i missing ...
- 23
2
votes
1
answer
905
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)
I ...
- 300
2
votes
1
answer
3k
views
pt-table-checksum - Diffs cannot be detected because no slaves were found (1)
I'm new to Percona tools. I am trying to use pt-table-checksum as follows:
pt-table-checksum h=localhost -u root -p xyz--replicate=percona.checksums --create-replicate-table --databases=mysql
But ...
- 21
2
votes
2
answers
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.
- 663
2
votes
0
answers
603
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-...
- 1,016
2
votes
1
answer
2k
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"
...
- 459
3
votes
1
answer
981
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 ...
- 2,458
5
votes
2
answers
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 ...
- 51
1
vote
0
answers
129
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 ...
- 111
2
votes
1
answer
985
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 ...
- 197
1
vote
1
answer
184
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-...
- 227
2
votes
1
answer
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 ...
- 227
2
votes
2
answers
3k
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 ...
- 183
6
votes
3
answers
2k
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 ...
- 5,263
3
votes
3
answers
2k
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 ...
- 619
4
votes
2
answers
6k
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 ...
- 41
3
votes
1
answer
4k
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 "...
- 300
1
vote
1
answer
516
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
2
answers
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 ...
- 143
3
votes
1
answer
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-...
- 474