Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [percona-tools]

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

3
votes
2answers
585 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 ...
0
votes
1answer
327 views

how to setup percona pmm monitoring of percona 5.7 in docker container

I want to monitor percona running in docker with the percona monitoring and management client. I have percona monitoring and management installed, running and monitoring other percona instances (...
0
votes
1answer
869 views

pt-online-schema-change — can't get it to stop quitting w/ “Threads_running=108 exceeds its critical threshold 100”

I've got an InnoDB table over 50GB with indexes. The query I'm running looks like this: pt-online-schema-change h=localhost,D=db,t=table --critical-load="Threads_running=100" --check-slave-lag "h=XX....
0
votes
0answers
22 views

pt-table-checksum infinte loop

pt-table-checksum 3.0.12 mysqld Ver 5.6.41-84.1 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release 84.1, Revision b308619) Command to run: pt-table-checksum --no-check-binlog-format --...
0
votes
0answers
18 views

How to use the Percona Toolkit to connect to Azure Database for MySQL when SSL is enabled

I am attempting to use the pt-show-grants to connected to a MySQL instance with SSL enabled. $ pt-show-grants --version pt-show-grants 3.0.9 If I attempt to connect to my database without any ...
0
votes
1answer
143 views

Percona Xtrabackup fails to backup InnoDB table with fulltext index

I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12). I have innodb_file_per_table set. To create the backup, I'm running: innobackupex --...
0
votes
1answer
60 views

pt-table-sync: syncing slave from master that has different credentials?

I have a MySQL slave under my full control and a master server where I have only read-only login. Also, logins are different. At some point replication have stopped due to some kind of problem. I ...
0
votes
1answer
137 views

innobackupex and creating slave

There's master mysql running 5.6.30. Engine InnoDB. innodb_file_per_table is used. Slave server is running 5.5.55 Doing next steps: - (on master) innobackupex --no-timestamp /path/to/backup - (on ...
1
vote
1answer
152 views

PT-Kill not logging to file

Run command for pt-kill /usr/bin/pt-kill --ignore-state User lock --rds --match-command Query --victims all --match-user phppoint --daemonize --busy-time 10 --kill --print --log /var/log/pt-kill.log ...
0
votes
0answers
17 views

Learning Percona Monitoring - CPU Usage

I've just started using the Percona Monitoring. I am not necessarily a db admin but I ended up with the task. I am enjoying it but truth be told I am not sure what I am looking at. There is an ...
0
votes
1answer
43 views

Is it safe to use pt-online-schema-change in a multimaster environment?

I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup). If I understand it correctly pt-osc creates ...
0
votes
1answer
119 views

MariaDB defragmenting with new option innodb-defragment=1

I try to defragment table using innodb-defragment=1 https://mariadb.com/kb/en/library/defragmenting-innodb-tablespaces/ But it was a bad experience : - locks on table - no a good defragmentation ...
2
votes
3answers
1k 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 ...
6
votes
2answers
598 views

COMMIT on top of the pt-query-digest output

I've been optimizing my MySQL server and after tweaking a few queries, I ended up with the COMMIT item on top of the pt-query-digest output, as shown in the extract below: # 322s user time, 770ms ...
2
votes
3answers
170 views

Why pt-duplicate-key-checker suggests removing a composite index?

Here's a snippet from the output of the Percona Tool pt-duplicate-key-checker which searches for redundant indexes: # Key myidx ends with a prefix of the clustered index # Key definitions: # KEY `...
2
votes
1answer
822 views

Is there a non-blocking operation to back up MyISAM tables using Percona XtraBackup?

I've been reading through the website of Percona XtraBackup and it claims that: Percona XtraBackup can back up the following storage engines by briefly pausing writes at the end of the backup: ...
2
votes
1answer
612 views

pt-table-checksum and mysql 5.7 with binlog_format=ROW

How to use pt-table-checksum in mysql 5.7 where binlog_format=ROW is default I also need binlog_format=ROW to be set this way in relation to other parameters in the mysql configuration # pt-table-...
1
vote
1answer
400 views

xb_stream_read_chunk(): wrong chunk magic at offset 0x0

I have taken a backup of mysql instance like this innobackupex \ --user=$MYUSER \ --password=$MYPASS \ --no-timestamp \ --parallel=$DUMP_THREADS \ --stream=xbstream \ --slave-info \ ...
2
votes
1answer
784 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 ...
0
votes
0answers
263 views

pt-table-sync usage

There're Master (10.0.0.1, mysql 5.5.43) and only one Slave (10.0.0.2, mysql 5.5.55). Replication is set up, running and show all OK. But pt-table-checksum found data differences in some tables ...
1
vote
1answer
602 views

Problem with aborted PT-online-schema change command

I aborted a pt-online-schema change command to change a table definition. Now, when I run pt-online-schema change again, I get this error: The table <db name>.<table name> has triggers. ...
0
votes
1answer
79 views

Help preparing for MySQL Master Slave Replication

I am not in the best situation. I inherited an Ubuntu 14.04 8 GB RAM, 8 CPU MySQL 5.5 database server with almost 400 GB of business-critical data (stored on external SSD) contained within several ...
0
votes
1answer
337 views

Data drift on Row-Based-Replication

i've realized that one of my mysql slaves has missing rows. select count on specific table on master: 9605010 on slave: 9593831 slave is completely sync, no seconds_behind_master, no errors, no slow ...
0
votes
0answers
306 views

MySQL 5.7 Replication failover in Master-Master configuration in RHEL

Asynchronous Replication Scenario ( Binary Logging Method) : Primary Node <-----> Secondary Node Write is enabled on Primary node and Read is enabled on both ...
0
votes
1answer
1k views

Pt-query-digest date ranges do not work as expected

Analyse Queries with Pt-query-digest I am using pt-query-digest to analyse queries and would like to analyse a specific time range only, in order to measure the effect of adding new indices and ...
0
votes
1answer
33 views

pt-online-schema-change's triggers fail with “DELETE command denied” on insert

We recently tried pt-online-schema-change to add a column to a table. It worked mostly as expected but one thing puzzles me: in case the account we use to do the migration doesn't have the DELETE ...
1
vote
2answers
55 views

MYSQL DATABASE BACKUP

Currently my backup strategy invloves :- 1)I have one master server and two slaves (Data approximately 700 GBs and tables are of mixed innodb and myisam). 2)I take weekly and monthly backup from ...
3
votes
1answer
298 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, ...
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 ...
1
vote
0answers
180 views

why pt-table-checksum lock my whole table?

mysql> desc user_donate_request; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------...
2
votes
2answers
180 views

pt-table-checksum not finding differences

I have a very simple setup: 1 master with 2 slaves. I stopped replication on one of the slaves (with the slave mysqld still running) and changed a row on the master. I have also kept all slaves and ...
4
votes
1answer
3k views

Percona: Backup preparation doesn't work (“cannot open ./xtrabackup_logfile”)

I've created a MySQL backup with PerconaXtrabackup tool via (thanks to this guide): innobackupex --user=backupmysqluser --password=xyz --compress --stream=xbstream ./ > /var/backups/db/firstBackup....
2
votes
1answer
76 views

Alter a large mysql table 700 gb

The production table I want to alter is around 700 Gb. I want to remove a FK from that table. Mysql version is 5.1.61-log. I found following options: pt-online-schema-change: alters a table’s ...
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" ...
1
vote
2answers
120 views

Running pt-table-checksum with replicate-do-db option on

I've read the documentation on percona page, but still a bit confused, especially about the --replicate option. My setting is that the slave is only replicating certain databases from master, say db1 ...
1
vote
1answer
939 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
119 views

Changing Default Values of Percona Audit Log

Have I missed Something here? I am installing the Percona Audit Log Plugin (MySQL 5.5). I can install it fine using: INSTALL PLUGIN audit_log SONAME 'audit_log.so'; I can then see all the default ...
1
vote
1answer
956 views

Innobackupex: How to extract individual files from xbstream compressed backups

We are scripting a mix of full and incremental backup setup for our prodcut backend with sunday triggering full backup and incremental backup on all the remaining days. In this process, we should be ...
4
votes
2answers
782 views

Is it possible to backup stored routines and functions with Innobackupex?

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ? I am only ...
2
votes
3answers
656 views

“No database selected” or “Table 'DB.table' doesn't exist” failures in pt-upgrade run where queries from multiple DBs were collected with tcpdump

I collected queries on our Master using the following tcpdump command: tcpdump -i any -s 65535 -x -n -nn -q -tttt 'port 3306' > tcpdump.tcp The queries are executed amongst several databases. I ...
1
vote
0answers
244 views

pt-online-schema-change with statement based replication in MYSQL

Is it possible/safe to use pt-online-schema-change in a Master slave environment where as the way replication is setup is statement based(SBR). What is the better way of doing it as currently I have ...
0
votes
0answers
179 views

Percona Toolkit pt-archiver doesn't work with --bulk-insert option

I'm running pt-archiver like this: pt-archiver --source ... --dest .. --where "last_updated BETWEEN '2015-01-26 00:00:00' AND '2015-02-01 23:59:59'" --ignore --no-check-columns --no-ascend --limit=...
0
votes
0answers
128 views

Percona Master-Master lag issues

I have 2 servers with master-master replication using Percona MySQL 5.6 and I am having replication lag in the second server: db-02, however db-01 never had a lag situation. What could be causing ...
2
votes
2answers
1k views

How pt-online-schema-change ensures consistency during data copy

I have read pt-online-schema-change documentation and understood that it works by creating triggers and copying data in chunks with in chunk-time seconds(0.5 seconds in default) Let us consider this ...
2
votes
1answer
3k views

How much space is needed to reclaim space from a table in INNODB

I inherited a MySQL InnoDB table that has approximately 200 GB worth of data, as well as several unneeded indices that amount to approximately 500 GB. I've archived approximately 75 percent of the ...
1
vote
1answer
829 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 ...
1
vote
1answer
318 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. ...
1
vote
0answers
117 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
1answer
404 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 ...
2
votes
1answer
2k 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 ...