Questions tagged [percona-toolkit]

The tag has no usage guidance.

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

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

The version, mysql is InnoDB 5.6.10-log, pt-online-schema-change 3.1.0. table info is `email` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(255) COLLATE utf8mb4_unicode_ci ...
0 votes
0 answers
72 views

pt-table-sync perfomance/load on a production MySQL RDS instance

Hi Percona User group, I’m trying to access the performance implication of using pt-table-sync tool to replicate a collection of tables from a schema on production server (on load) to a replica schema ...
-1 votes
1 answer
338 views

InnoDB: Assertion failure on executing select Query - MySQL 5.7.31

I am using pt-archiver for daily archiving of tables, but while selecting data from one tables I am getting following error and it restart mysql instance 2021-07-07 13:21:17 0x7fe0dffdc700 InnoDB: ...
0 votes
1 answer
180 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 ...
1 vote
1 answer
286 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 ...
  • 111
1 vote
1 answer
669 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,228
2 votes
1 answer
809 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
1 answer
611 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 ...
10 votes
2 answers
16k 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 ...
1 vote
1 answer
637 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 "...
  • 573
0 votes
1 answer
48 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-...
  • 517
2 votes
2 answers
176 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 ...
  • 31
3 votes
2 answers
512 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 ...
  • 585
0 votes
1 answer
2k 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....
  • 203
2 votes
1 answer
259 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 ...
  • 83
1 vote
0 answers
322 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 | ...
  • 11
0 votes
0 answers
290 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
3 answers
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
0 answers
272 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 ...
3 votes
2 answers
2k 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 ...
  • 766
2 votes
1 answer
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 ...
6 votes
1 answer
6k 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
1 answer
708 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-...
  • 585
2 votes
2 answers
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
1 answer
8k 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 ...
  • 281
1 vote
1 answer
721 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
0 answers
653 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 ...
5 votes
2 answers
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 ...
  • 281