Questions tagged [percona-toolkit]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
23 views

Where is pt-table-checksum finding this hostname?

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8. Somehow the slave got out of sync and I'm getting this error when I do SHOW ...
0
votes
1answer
69 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 ...
1
vote
1answer
205 views

pt-query-digest --type binlog (percona-toolkit) gives empty output with MariaDB/Galera 10.1

My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD Percona Toolkit for MySQL https://www.percona.com/software/...
2
votes
1answer
436 views

Using Pt-online schema change on multi master MYSQL

We are using two MYSQL servers in ring replication where master is also a slave of the other master. Both have slaves connected to each other. We want to run pt-online-schema-change to add couple of ...
0
votes
1answer
269 views

percona-online-schema-change is taking a lot of time

We have a table with 600M+ records and using AWS Aurora with master-slave replication. Requirement: We need to add two columns with index in customer table. Aurora Instance Specs: Ram: 30.5 GB ...
3
votes
2answers
6k views

Alter large table without downtime

I have a very large table, lets call it example, and I try to execute a little alter command on that table: ALTER TABLE `example` ADD `example_column` TINYINT(1) NOT NULL DEFAULT 0; Checking the ...
0
votes
1answer
335 views

Delete _new table from pt-online-schema-change

I used pt-online-schema-change but the process died in the middle. The script makes a copy of the original table with the name followed by "_new". Since the process died in the middle, the table "...
0
votes
1answer
23 views

pt-query-digest slowlog output format looses query cache hit information?

I'm using pt-query-digest (v2.2.20) slowlog output format to filter out queries based on their timestamp, to run further digests on the filtered slowlog : ptqd 11-21.slow.log --output slowlog --no-...
1
vote
2answers
77 views

Cleanup / Prune Unreferenced Data in Dimension Tables

We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of data in our fact tables using partitions by month. We have a number of dynamic dimension tables that are ...
3
votes
2answers
325 views

Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex

My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 ...
0
votes
1answer
939 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
1answer
142 views

pt-table-sync fails “Turning off AutoCommit”

While trying to use pt-table-sync with the following options for a list of slaves: pt-table-sync --print --replicate schema.checksum_table --sync-to-master slave-001 I receive the following error ...
1
vote
0answers
252 views

pt-table-sync - Resync non existing table

I created my little lab where I can try different setup/scenarios. I have four machines debootsraped/chroot and this is my current layout: | Master A | < ---- > | Master B | | | Slave C | ...
0
votes
0answers
197 views

pt-online-schema-change deleted our data

We used pt-online-schema-change tool on number of our tables. We ran up into a problem of data inconsistency. We lost some of our data. The way we implemented was on slave and replication was also ...
1
vote
3answers
1k views

Convert MyISAM to InnoDB

What are the considerations needed when converting myisam to innodb. I have a table around 80 GB with engine myisam. I would like to convert into innodb. What are the considerations needed to ...
1
vote
0answers
249 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 ...
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
1k views

What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?

We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do ...
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
567 views

pt-table-checksum - Verify MySQL replication integrity

export/import: $ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql Enter password: $ echo $? 0 $ mysql clee2 < 6dhdbm01-clee2.users.sql $ echo $? 0 $ pt-table-checksum: $ pt-...
2
votes
2answers
2k views

Is it necessary to run apply-log immediately after innobackupexec has run?

i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked. I'm trying to organize my self and backup all my mysql ...
2
votes
1answer
7k views

pt-heartbeat showing “Host is blocked because of many connection errors”…but connections are well under limit

I'm running MySQL in a master-slave configuration. pt-heartbeat is showing "Host is blocked because of many connection errors"...but connections are well under limit (limit is 600 connections, MySQL ...
1
vote
1answer
579 views

pt-online-schema-change MySQL Error: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

I've attempted to alter table using pt-online-schema-change in our master-master replication environment (Percona used as a cluster). It seems, that an operation completed successfully, but inspecting ...
1
vote
0answers
498 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
4
votes
1answer
3k views

pt-table-checksum and row-based replication

The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to use "MIXED" replication (statement and row-based) because we use an application that requires it, and it ...