# Percona Toolkit **URL:** https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=3 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 4 --- ## [Percona Toolkit v3.5.5 Released](https://forums.percona.com/t/percona-toolkit-v3-5-5-released/25770)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 1\ **Last updated:** [December 11, 2023, 10:22am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-5-released/25770 "2023-12-11T10:22:30Z")
October 3, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Pt-online-schema-change Missing "Create Table" Retry Option](https://forums.percona.com/t/pt-online-schema-change-missing-create-table-retry-option/26696)
**Author:** [@brianestrada658](https://forums.percona.com/u/brianestrada658)\ **Replies:** 2\ **Last updated:** [November 21, 2023, 9:02pm UTC](https://forums.percona.com/t/pt-online-schema-change-missing-create-table-retry-option/26696 "2023-11-21T21:02:28Z")
When running pt-osc on version 3.5.1 on MySQL 8.0.28, I usually encounter a metadata lock like this: CREATE TABLE \`test\`.\`\_test\_new\` ( ... And I get an error like this: (in cleanup) DBD::mysql::db do failed: Lock wai… --- ## [Pt-heartbeat monitor](https://forums.percona.com/t/pt-heartbeat-monitor/3526)
**Author:** [@offline](https://forums.percona.com/u/offline)\ **Replies:** 1\ **Last updated:** [November 21, 2023, 10:31am UTC](https://forums.percona.com/t/pt-heartbeat-monitor/3526 "2023-11-21T10:31:42Z")
If I am wanting to see if the pt-heartbeat monitor is running what is the best way to find out? Should i do a mysql query or just look at the process list? I need to setup nagios to make sure it is activated on boot. T… --- ## [Why is there a negative number in the replication lag in Percona MySQL Shell? (Innodb Cluster)](https://forums.percona.com/t/why-is-there-a-negative-number-in-the-replication-lag-in-percona-mysql-shell-innodb-cluster/26421)
**Author:** [@DongyeongKim](https://forums.percona.com/u/DongyeongKim)\ **Replies:** 3\ **Last updated:** [November 9, 2023, 6:13am UTC](https://forums.percona.com/t/why-is-there-a-negative-number-in-the-replication-lag-in-percona-mysql-shell-innodb-cluster/26421 "2023-11-09T06:13:53Z")
MySQL localhost JS \> a.status() { "clusterName": "rockCluster", "defaultReplicaSet": { "name": "default", "primary": "node2:3306", "ssl": "REQUIRED", "status": "OK", "st… --- ## [Pt-slave-repair is a supplement to the original pt-slave-restart tool](https://forums.percona.com/t/pt-slave-repair-is-a-supplement-to-the-original-pt-slave-restart-tool/26335)
**Author:** [@hiller1231](https://forums.percona.com/u/hiller1231)\ **Replies:** 0\ **Last updated:** [November 3, 2023, 5:46am UTC](https://forums.percona.com/t/pt-slave-repair-is-a-supplement-to-the-original-pt-slave-restart-tool/26335 "2023-11-03T05:46:57Z")
pt-slave-repair is a supplement to the original pt-slave-restart tool, which provides automatic repair for MySQL master-slave synchronization replication errors and restores interrupted SQL thread replication threads. P… --- ## [Just only delete with query](https://forums.percona.com/t/just-only-delete-with-query/26232)
**Author:** [@seqwait](https://forums.percona.com/u/seqwait)\ **Replies:** 5\ **Last updated:** [October 31, 2023, 2:55pm UTC](https://forums.percona.com/t/just-only-delete-with-query/26232 "2023-10-31T14:55:45Z")
i just want delete table row by where without query example user\_login\_record i just want delete by login\_at “delete from user\_login\_record where login\_at \< ‘2022-10-10’” without query just delete by where what shoul… --- ## [Installing a specific version of a single tool (pt-archiver) from percona-toolkit](https://forums.percona.com/t/installing-a-specific-version-of-a-single-tool-pt-archiver-from-percona-toolkit/25623)
**Author:** [@Atharv\_Kirtikar](https://forums.percona.com/u/Atharv_Kirtikar)\ **Replies:** 2\ **Last updated:** [October 26, 2023, 6:50am UTC](https://forums.percona.com/t/installing-a-specific-version-of-a-single-tool-pt-archiver-from-percona-toolkit/25623 "2023-10-26T06:50:15Z")
Hi I want to install ONLY pt-archiver and no other tool from percona-toolkit (Docker container, want to save space) The docs say I can direcly install a single toolkit using wget: If you want to download a specific t… --- ## [Issue running pt-upgrade against MySQL 5.6 and MySQL 8.0](https://forums.percona.com/t/issue-running-pt-upgrade-against-mysql-5-6-and-mysql-8-0/18929)
**Author:** [@tcranford](https://forums.percona.com/u/tcranford)\ **Replies:** 4\ **Last updated:** [October 25, 2023, 3:35pm UTC](https://forums.percona.com/t/issue-running-pt-upgrade-against-mysql-5-6-and-mysql-8-0/18929 "2023-10-25T15:35:14Z")
Working with a Percona consultant to help with our migration from community versions of MySQL 5.6 to MySQL 8.0. We’re running on CentOS 7.9. One of our goals is to get some comparison metrics. To that end, here is wha… --- ## [Pt-mysql-summary does not propberly work, if MyDumper configuration is installed](https://forums.percona.com/t/pt-mysql-summary-does-not-propberly-work-if-mydumper-configuration-is-installed/25925)
**Author:** [@dsteiner](https://forums.percona.com/u/dsteiner)\ **Replies:** 1\ **Last updated:** [October 16, 2023, 2:38pm UTC](https://forums.percona.com/t/pt-mysql-summary-does-not-propberly-work-if-mydumper-configuration-is-installed/25925 "2023-10-16T14:38:28Z")
We are using mydumper for logical backups. Since a while, mydumper requires /etc/mydumper.cnf configuration file. pt-mysql-summary (percona-toolkit-3.5.5-1.el8.x86\_64) gives following error, when running: \[client-serve… --- ## [Pt-table-checksum connection errors after upgrade to 3.5.5](https://forums.percona.com/t/pt-table-checksum-connection-errors-after-upgrade-to-3-5-5/25729)
**Author:** [@steffen](https://forums.percona.com/u/steffen)\ **Replies:** 4\ **Last updated:** [October 11, 2023, 8:05am UTC](https://forums.percona.com/t/pt-table-checksum-connection-errors-after-upgrade-to-3-5-5/25729 "2023-10-11T08:05:04Z")
Hi, after upgrading to Percona Toolkit 3.5.5 I’m getting connection errors from pt-table-checksum that do not occur with versions 3.3.1 or 3.4.0. (MySQL 5.7.42 on Debian 10) Somehow between creating and checking the ch… --- ## [Pt-table-checksum can't start/](https://forums.percona.com/t/pt-table-checksum-cant-start/25765)
**Author:** [@yyu0378](https://forums.percona.com/u/yyu0378)\ **Replies:** 2\ **Last updated:** [October 10, 2023, 1:29am UTC](https://forums.percona.com/t/pt-table-checksum-cant-start/25765 "2023-10-10T01:29:02Z")
pt-tables-checksum: 3.5.5 mysql server: 5.7.25 command: pt-table-checksum --no-check-replication-filter --recursion-method=hosts --databases=xxxx S=/var/run/mysqld/mysqld.sock,u=root,p=xxxxx but just show like this W… --- ## [Pt-online-schema-change stops after 24 hours on AWS Aurora Serverless V1 MySQL 5.7](https://forums.percona.com/t/pt-online-schema-change-stops-after-24-hours-on-aws-aurora-serverless-v1-mysql-5-7/24399)
**Author:** [@itt\_sha\_lkt](https://forums.percona.com/u/itt_sha_lkt)\ **Replies:** 9\ **Last updated:** [September 15, 2023, 3:58pm UTC](https://forums.percona.com/t/pt-online-schema-change-stops-after-24-hours-on-aws-aurora-serverless-v1-mysql-5-7/24399 "2023-09-15T15:58:51Z")
Hello, We are using the pt-online-schema-change (version 3.5.4) to increase the size of a column in a very large table (320 million rows) hosted on AWS RDS Aurora Serverless V1 MySQL (version 5.7). A little after 24 ho… --- ## [How does pt-online-schema-change drop old table?](https://forums.percona.com/t/how-does-pt-online-schema-change-drop-old-table/24943)
**Author:** [@360324761](https://forums.percona.com/u/360324761)\ **Replies:** 2\ **Last updated:** [September 6, 2023, 8:32am UTC](https://forums.percona.com/t/how-does-pt-online-schema-change-drop-old-table/24943 "2023-09-06T08:32:57Z")
Hi: mysql5.7 percona\_tool 3.4 /bin/pt-online-schema-change --host=${host} --port=${port} --user=${user} --password=${passwd} --recursion-method=processlist --check-interval=1 --chunk-time=1 --max-lag=1 --no-version-ch… --- ## [PT-Query-Digest (Creation Database)](https://forums.percona.com/t/pt-query-digest-creation-database/24667)
**Author:** [@David\_Martinez](https://forums.percona.com/u/David_Martinez)\ **Replies:** 5\ **Last updated:** [August 31, 2023, 2:41pm UTC](https://forums.percona.com/t/pt-query-digest-creation-database/24667 "2023-08-31T14:41:00Z")
Good morning, I can see in the source code of pt-query digest the db always try to be created This shouldn’t be a problem but recently we have noticed this could drive to trigger the conflict resolution on mariadb - … --- ## [Pt-online-schema-change changes IP of my host](https://forums.percona.com/t/pt-online-schema-change-changes-ip-of-my-host/24499)
**Author:** [@Ken\_Shih](https://forums.percona.com/u/Ken_Shih)\ **Replies:** 4\ **Last updated:** [August 21, 2023, 2:31pm UTC](https://forums.percona.com/t/pt-online-schema-change-changes-ip-of-my-host/24499 "2023-08-21T14:31:02Z")
Hello! I am using pt-online-schema-change on an AWS Aurora 2.x mysql 5.7 database trying to rebuild a table. For my staging database it seems to work, but for some reason when I run the following command against my prod… --- ## [General log not analyzed for one particular user](https://forums.percona.com/t/general-log-not-analyzed-for-one-particular-user/16106)
**Author:** [@Ruben\_Cardenal](https://forums.percona.com/u/Ruben_Cardenal)\ **Replies:** 2\ **Last updated:** [July 6, 2023, 6:19am UTC](https://forums.percona.com/t/general-log-not-analyzed-for-one-particular-user/16106 "2023-07-06T06:19:01Z")
Hello, I’m trying to get some insights about the queries that a particular db user (“mas”) realizes in order to a redis cache layer to be created. I issue (as per the docs): pt-query-digest --type genlog --filter ‘($… --- ## [Percona Toolkit 3.5.4 Released](https://forums.percona.com/t/percona-toolkit-3-5-4-released/23301)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [July 3, 2023, 11:14am UTC](https://forums.percona.com/t/percona-toolkit-3-5-4-released/23301 "2023-07-03T11:14:38Z")
June 30, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [AWS Graviton3 ARM support ETA for Percona Toolkit?](https://forums.percona.com/t/aws-graviton3-arm-support-eta-for-percona-toolkit/22751)
**Author:** [@eyalso](https://forums.percona.com/u/eyalso)\ **Replies:** 1\ **Last updated:** [June 12, 2023, 6:59pm UTC](https://forums.percona.com/t/aws-graviton3-arm-support-eta-for-percona-toolkit/22751 "2023-06-12T18:59:57Z")
Hi, Any ETA for AWS Graviton3 ARM support ETA for Percona Toolkit ? Thanks, Eyal --- ## [Percona Toolkit 3.5.3 Released](https://forums.percona.com/t/percona-toolkit-3-5-3-released/22582)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 6, 2023, 8:51am UTC](https://forums.percona.com/t/percona-toolkit-3-5-3-released/22582 "2023-06-06T08:51:50Z")
June 5, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Percona Toolkit with Percona XtraDB Cluster on Kubernetes](https://forums.percona.com/t/percona-toolkit-with-percona-xtradb-cluster-on-kubernetes/22178)
**Author:** [@Philipp\_Malkmus](https://forums.percona.com/u/Philipp_Malkmus)\ **Replies:** 1\ **Last updated:** [May 19, 2023, 4:29pm UTC](https://forums.percona.com/t/percona-toolkit-with-percona-xtradb-cluster-on-kubernetes/22178 "2023-05-19T16:29:35Z")
I am running the Percona XtraDB Cluster with the Percona Operator For MySQL on Kubernetes. Since for altering tables I need to use pt-online-schema-change I need to use the toolkit. How do I use or install the toolkit … --- ## [Skip-check-slave-lag is not working for pt-online-schema-change](https://forums.percona.com/t/skip-check-slave-lag-is-not-working-for-pt-online-schema-change/22060)
**Author:** [@izavadinskiy](https://forums.percona.com/u/izavadinskiy)\ **Replies:** 2\ **Last updated:** [May 15, 2023, 11:08am UTC](https://forums.percona.com/t/skip-check-slave-lag-is-not-working-for-pt-online-schema-change/22060 "2023-05-15T11:08:46Z")
Hi. Guys, I am trying to use pt-online-schema-change for changing table structure to utf8mb4. Faced with the issue when pt-online-schema-change showing the exception about “Cannot connect to h=10.3.15.0,p=…,u=” (slave … --- ## [Pt-osc running on standby breaks replication](https://forums.percona.com/t/pt-osc-running-on-standby-breaks-replication/21665)
**Author:** [@Sukan\_M1](https://forums.percona.com/u/Sukan_M1)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 4:02am UTC](https://forums.percona.com/t/pt-osc-running-on-standby-breaks-replication/21665 "2023-04-27T04:02:37Z")
There is a dedicated standby where we are doing schema changes like index addition, defragmentation before switching that as a master. Q1 : When running pt-osc with replication, it fails with 1032 upon completion. If we… --- ## [How to translate SQL to pt-online-schema-change CLI format?](https://forums.percona.com/t/how-to-translate-sql-to-pt-online-schema-change-cli-format/21524)
**Author:** [@Victor\_Munoz](https://forums.percona.com/u/Victor_Munoz)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 8:38am UTC](https://forums.percona.com/t/how-to-translate-sql-to-pt-online-schema-change-cli-format/21524 "2023-04-27T08:38:31Z")
Hi all, I’m looking for an automate way to run pt-online-schema-change tool, and I don’t know if there is any tool, plugin, … that provides translation/conversion from SQL statements to pt-online-schema-change CLI forma… --- ## [Percona-tookit Supported distributions?](https://forums.percona.com/t/percona-tookit-supported-distributions/21539)
**Author:** [@dkang](https://forums.percona.com/u/dkang)\ **Replies:** 2\ **Last updated:** [April 21, 2023, 9:59pm UTC](https://forums.percona.com/t/percona-tookit-supported-distributions/21539 "2023-04-21T21:59:12Z")
Hi, which mysql distributions percona-toolkit support? I am specifically interested in if xtrabackup pt-online-schema-change pt-query supports oracle mysql percona myrocks facebook myrocks Is there a doc page for … --- ## [Running pt-table-checksum before pt-table-sync?](https://forums.percona.com/t/running-pt-table-checksum-before-pt-table-sync/21035)
**Author:** [@Ron](https://forums.percona.com/u/Ron)\ **Replies:** 1\ **Last updated:** [March 30, 2023, 11:13am UTC](https://forums.percona.com/t/running-pt-table-checksum-before-pt-table-sync/21035 "2023-03-30T11:13:08Z")
I’m sure there are many reasons to run pt-table-checksum before pt-table-sync but I don’t know all the reasons. If I know there are inconsistencies between two databases, is it good enough to just run pt-table-sync --pri… --- ## [Can pt-online-schema-change be run separately to just handle the table swap?](https://forums.percona.com/t/can-pt-online-schema-change-be-run-separately-to-just-handle-the-table-swap/20145)
**Author:** [@cthompson](https://forums.percona.com/u/cthompson)\ **Replies:** 2\ **Last updated:** [February 17, 2023, 1:48am UTC](https://forums.percona.com/t/can-pt-online-schema-change-be-run-separately-to-just-handle-the-table-swap/20145 "2023-02-17T01:48:25Z")
Hi All, Question: Would I be able to run pt-online-schema-change (or another percona tool) that does everything but the table creation and data sync? I’m a beginner with percona and pt-online-schema-change and just wan… --- ## [Running pt-osc on RDS instance to alter a table with 1.9 billion records](https://forums.percona.com/t/running-pt-osc-on-rds-instance-to-alter-a-table-with-1-9-billion-records/7317)
**Author:** [@ryan.griffith](https://forums.percona.com/u/ryan.griffith)\ **Replies:** 1\ **Last updated:** [February 6, 2023, 9:56am UTC](https://forums.percona.com/t/running-pt-osc-on-rds-instance-to-alter-a-table-with-1-9-billion-records/7317 "2023-02-06T09:56:04Z")
I have an RDS instance running MySQL 5.5.46 which has a table with a primary key of int that it is currently at 1.9 billion records and approaching the 2.1 billion limit and ~425GB in size. I’m attempting to use pt-onlin… --- ## [Percona Toolkit v3.5.1 Released](https://forums.percona.com/t/percona-toolkit-v3-5-1-released/19749)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [January 24, 2023, 8:56am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-1-released/19749 "2023-01-24T08:56:15Z")
January 23, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Pt-archiver does not archive tables with binary data columns and --bulk-insert \[PT-2127\]](https://forums.percona.com/t/pt-archiver-does-not-archive-tables-with-binary-data-columns-and-bulk-insert-pt-2127/18835)
**Author:** [@Tin\_Cvitkovic](https://forums.percona.com/u/Tin_Cvitkovic)\ **Replies:** 1\ **Last updated:** [November 30, 2022, 6:32pm UTC](https://forums.percona.com/t/pt-archiver-does-not-archive-tables-with-binary-data-columns-and-bulk-insert-pt-2127/18835 "2022-11-30T18:32:49Z")
https://jira.percona.com/browse/PT-2127 Archiving changes some values so that the checksum of the source and destination tables does not give the same values. By archiving without the --bulk-insert option, the data in … --- ## [Percona Toolkit v3.5.0 Released](https://forums.percona.com/t/percona-toolkit-v3-5-0-released/18829)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [November 30, 2022, 7:03am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-0-released/18829 "2022-11-30T07:03:40Z")
November 28, 2022 - Find release notes at Percona Toolkit — Percona Toolkit Documentation [Previous page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=2) [Next page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=4)