Question : We are using two MYSQL servers in ring replication where master is also a slave of the other […]
Tag: percona-toolkit
pt-online-schema-change — can’t get it to stop quitting w/ “Threads_running=108 exceeds its critical threshold 100”
Question : 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 […]
pt-table-checksum and row-based replication
Question : The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to […]
Is it safe to use pt-online-schema-change in a multimaster environment?
Question : I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for […]
pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue
Question : 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` […]
Cleanup / Prune Unreferenced Data in Dimension Tables
Question : We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of […]
Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex
Question : My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C […]
Is it necessary to run apply-log immediately after innobackupexec has run?
Question : i have been trying to read other questions, but i did not find a answer to suit me. […]
Where is pt-table-checksum finding this hostname?
Question : The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range […]