Questions tagged [percona-tools]

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

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 ...
0
votes
1answer
45 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
146 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
329 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
80 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
140 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 ...
0
votes
1answer
34 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 ...
0
votes
1answer
877 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....
2
votes
0answers
517 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
vote
0answers
181 views

why pt-table-checksum lock my whole table?

mysql> desc user_donate_request; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------...
1
vote
0answers
245 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 ...
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
0answers
121 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
19 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
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
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
0answers
268 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 ...
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
0answers
181 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 ...