# Percona Toolkit **URL:** https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [Percona Toolkit on Amazon Linux](https://forums.percona.com/t/percona-toolkit-on-amazon-linux/31263)
**Author:** [@pkouleri](https://forums.percona.com/u/pkouleri)\ **Replies:** 1\ **Last updated:** [June 27, 2024, 3:37pm UTC](https://forums.percona.com/t/percona-toolkit-on-amazon-linux/31263 "2024-06-27T15:37:46Z")
Hello there! I am trying to install percona-toolkit on an Amazon Linux EC2 instance following the instructions here: Installing Percona Toolkit — Percona Toolkit Documentation (setup the percona repositories etc), but t… --- ## [Pt-deadlock-logger ignoring deadlock](https://forums.percona.com/t/pt-deadlock-logger-ignoring-deadlock/31271)
**Author:** [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Replies:** 2\ **Last updated:** [June 27, 2024, 2:47pm UTC](https://forums.percona.com/t/pt-deadlock-logger-ignoring-deadlock/31271 "2024-06-27T14:47:07Z")
Testing pt-deadlock-logger 3.6.0 with mariadb 11.3.2 , 10.6.16: Run pt-deadlock-logger: pt-deadlock-logger --log /var/log/dead.log --interval=5s --daemonize After try to create deadlock 1st transaction MariaDB \[tes… --- ## [PT-Online-schema errors](https://forums.percona.com/t/pt-online-schema-errors/30735)
**Author:** [@meyerder](https://forums.percona.com/u/meyerder)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 5:58pm UTC](https://forums.percona.com/t/pt-online-schema-errors/30735 "2024-05-31T17:58:27Z")
FYI the link to report a bug is broken… I was going to attempt to file a bug report with online schema change… pt-online-schema-change 3.5.7 The area around that trigger is -- Replace single quotes in the email… --- ## [Pt-online-schema-change Running simultaneously for multiple databases](https://forums.percona.com/t/pt-online-schema-change-running-simultaneously-for-multiple-databases/30589)
**Author:** [@Federico\_Bau](https://forums.percona.com/u/Federico_Bau)\ **Replies:** 4\ **Last updated:** [May 28, 2024, 8:59am UTC](https://forums.percona.com/t/pt-online-schema-change-running-simultaneously-for-multiple-databases/30589 "2024-05-28T08:59:04Z")
Imagine this scenario: Need to do an ALTER to add in index i.e: ADD INDEX index\_name (column\_name) Within a host, there are 30 databases with same schema Need to run pt-online-schema-change for each database I created … --- ## [Pt-online-schema-change --execute Hangs forever](https://forums.percona.com/t/pt-online-schema-change-execute-hangs-forever/30542)
**Author:** [@Federico\_Bau](https://forums.percona.com/u/Federico_Bau)\ **Replies:** 3\ **Last updated:** [May 27, 2024, 11:03am UTC](https://forums.percona.com/t/pt-online-schema-change-execute-hangs-forever/30542 "2024-05-27T11:03:59Z")
OS: Ubuntu 18.4 (On WSL – Windows 11) MySQL Version: 5.7.42 pt-online-schema-change: pt-online-schema-change 3.5.5 Tool: pt-online-schema-change Action: --alter "ADD ALTER entries\_\_expire (expire)" Hi, I’m testing pt… --- ## [Pt-table-sync sync the json filed type will change the content with wrong encode type](https://forums.percona.com/t/pt-table-sync-sync-the-json-filed-type-will-change-the-content-with-wrong-encode-type/30200)
**Author:** [@hetao](https://forums.percona.com/u/hetao)\ **Replies:** 1\ **Last updated:** [May 13, 2024, 3:24am UTC](https://forums.percona.com/t/pt-table-sync-sync-the-json-filed-type-will-change-the-content-with-wrong-encode-type/30200 "2024-05-13T03:24:54Z")
I can see the jira https://perconadev.atlassian.net/browse/PT-1875, but it not fixed at now. The json filed type content with wrong encode type： The table define: CREATE TABLE \`t\_article\` ( \`pk\_article\` bigint NOT N… --- ## [Percona Toolkit v3.5.7 Released](https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 1\ **Last updated:** [May 9, 2024, 8:53am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394 "2024-05-09T08:53:48Z")
December 23, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Pt-table-sync - second idle connection being timed out](https://forums.percona.com/t/pt-table-sync-second-idle-connection-being-timed-out/29801)
**Author:** [@psumner](https://forums.percona.com/u/psumner)\ **Replies:** 2\ **Last updated:** [April 23, 2024, 1:16pm UTC](https://forums.percona.com/t/pt-table-sync-second-idle-connection-being-timed-out/29801 "2024-04-23T13:16:50Z")
The company has been using pt-table-sync for a long time to sync tables from source → target - simple as can be no replicas involved no complications just: pt-table sync \[a few switches\] sourceDSN destDSN Source is a… --- ## [Pt-duplicate-key-checker](https://forums.percona.com/t/pt-duplicate-key-checker/29380)
**Author:** [@Edward\_Hibbert](https://forums.percona.com/u/Edward_Hibbert)\ **Replies:** 2\ **Last updated:** [April 7, 2024, 10:32am UTC](https://forums.percona.com/t/pt-duplicate-key-checker/29380 "2024-04-07T10:32:31Z")
Suppose I have an index X on column A which is used as a constraint in a relation. And I have an index Y on columns A,B. Then pt-duplicate-key-checker shows up index X as a redundant index. But I don’t think it is, is… --- ## [Waiting for the --replicate table to replicate - nothing else happens](https://forums.percona.com/t/waiting-for-the-replicate-table-to-replicate-nothing-else-happens/4476)
**Author:** [@bluethundr](https://forums.percona.com/u/bluethundr)\ **Replies:** 5\ **Last updated:** [April 1, 2024, 8:58am UTC](https://forums.percona.com/t/waiting-for-the-replicate-table-to-replicate-nothing-else-happens/4476 "2024-04-01T08:58:11Z")
Hello, I’m really new to using the percona tools, and I’m trying to learn how to use them correctly. I’m having a problem with replication drift in my 4 node mysql setup. I’m running a wiki on this setup. And when I cr… --- ## [Pt-archiver is truncating a TEXT column when "--bulk-insert" is used](https://forums.percona.com/t/pt-archiver-is-truncating-a-text-column-when-bulk-insert-is-used/29411)
**Author:** [@fpj](https://forums.percona.com/u/fpj)\ **Replies:** 1\ **Last updated:** [March 28, 2024, 10:19am UTC](https://forums.percona.com/t/pt-archiver-is-truncating-a-text-column-when-bulk-insert-is-used/29411 "2024-03-28T10:19:15Z")
Hello everyone, while running the “pt-archiver” tool to archive some data, we are experiencing some truncation on a TEXT column on target table, when we add the flag “–bulk-insert”. This is resulting in wrong data bein… --- ## [Pt-table-checksum causing error 4164](https://forums.percona.com/t/pt-table-checksum-causing-error-4164/29276)
**Author:** [@Jason\_Stratford](https://forums.percona.com/u/Jason_Stratford)\ **Replies:** 1\ **Last updated:** [March 25, 2024, 8:34am UTC](https://forums.percona.com/t/pt-table-checksum-causing-error-4164/29276 "2024-03-25T08:34:21Z")
Hi all, I’m running into some sort of strange issue when running pt-table-checksum. For all checksum queries it is spitting out an error as below… 03-21T14:08:48 Error checksumming table InstantService.High: Error exec… --- ## [Intermittent pt-table-checksum Issuing rollback() due to DESTROY without explicit disconnect()](https://forums.percona.com/t/intermittent-pt-table-checksum-issuing-rollback-due-to-destroy-without-explicit-disconnect/22467)
**Author:** [@Reio\_Remma](https://forums.percona.com/u/Reio_Remma)\ **Replies:** 2\ **Last updated:** [March 22, 2024, 8:35am UTC](https://forums.percona.com/t/intermittent-pt-table-checksum-issuing-rollback-due-to-destroy-without-explicit-disconnect/22467 "2024-03-22T08:35:53Z")
A few months ago I started getting intermittent errors from pt-table-checksum. pt-table-checksum --nocheck-binlog-format --quiet Starting checksum ... Issuing rollback() due to DESTROY without explicit disconnect() of… --- ## [Pt-online-schema failure due to duplicated constraint names and from multiple foreign keys](https://forums.percona.com/t/pt-online-schema-failure-due-to-duplicated-constraint-names-and-from-multiple-foreign-keys/28323)
**Author:** [@Ty\_Lewis](https://forums.percona.com/u/Ty_Lewis)\ **Replies:** 2\ **Last updated:** [March 15, 2024, 12:00pm UTC](https://forums.percona.com/t/pt-online-schema-failure-due-to-duplicated-constraint-names-and-from-multiple-foreign-keys/28323 "2024-03-15T12:00:15Z")
(I can’t seem to log this as a possible bug on perconadev.atlassian.net because it requires login, and login seems to be down or unavailable to me. If there’s a way to report without login, please let me know and sorry i… --- ## [Pt-table-checksum row](https://forums.percona.com/t/pt-table-checksum-row/29064)
**Author:** [@sslll](https://forums.percona.com/u/sslll)\ **Replies:** 2\ **Last updated:** [March 11, 2024, 2:16pm UTC](https://forums.percona.com/t/pt-table-checksum-row/29064 "2024-03-11T14:16:30Z")
Tried running the pt-table-checksum with the --no-check-binlog-format, thought that using this flag would by-pass the need to set it as STATEMENT binlog format? pt-table-checksum --recursion-method=dsn=t=percona.DSN\_Tab… --- ## [How to use Percona Toolkit in a Docker container?](https://forums.percona.com/t/how-to-use-percona-toolkit-in-a-docker-container/7883)
**Author:** [@kevinhoangvn](https://forums.percona.com/u/kevinhoangvn)\ **Replies:** 4\ **Last updated:** [March 10, 2024, 4:27am UTC](https://forums.percona.com/t/how-to-use-percona-toolkit-in-a-docker-container/7883 "2024-03-10T04:27:47Z")
Hi, I’m using Windows 10 and running MySQL 5.7.26 on this machine. I download the docker image perconalab/percona-toolkit 3.2.0 from https://hub.docker.com/r/perconalab/percona-toolkit . I try to run the container with t… --- ## [Looks like pt-deadlock-logger is erroring out?](https://forums.percona.com/t/looks-like-pt-deadlock-logger-is-erroring-out/28328)
**Author:** [@Jeff\_Smelser](https://forums.percona.com/u/Jeff_Smelser)\ **Replies:** 4\ **Last updated:** [February 29, 2024, 8:55pm UTC](https://forums.percona.com/t/looks-like-pt-deadlock-logger-is-erroring-out/28328 "2024-02-29T20:55:42Z")
We have been running deadlock logger for a long time but after upgrading a database to 8, we have noticed that it fails out on one of our databases. Logs below \-ptdeadlocklogger-5d79f987dc-qdg6f \-pt-deadlocklogg… --- ## [the error about pt-query-digest + tcpdump](https://forums.percona.com/t/the-error-about-pt-query-digest-tcpdump/7472)
**Author:** [@bock.tang](https://forums.percona.com/u/bock.tang)\ **Replies:** 2\ **Last updated:** [February 23, 2024, 8:42pm UTC](https://forums.percona.com/t/the-error-about-pt-query-digest-tcpdump/7472 "2024-02-23T20:42:39Z")
Dear all; I am use the tools of pt-query-digest + tcpdump according to the manual of \[URL\]https://www.percona.com/doc/percona-toolkit/3.0/pt-query-digest.html\[/URL\] tcpdump -s 65535 -x -nn -q -tttt -i any -c 1000 port … --- ## [pt-query-digest: MySQLProtocolParser caused an error](https://forums.percona.com/t/pt-query-digest-mysqlprotocolparser-caused-an-error/7367)
**Author:** [@tvlooy](https://forums.percona.com/u/tvlooy)\ **Replies:** 22\ **Last updated:** [February 23, 2024, 8:08pm UTC](https://forums.percona.com/t/pt-query-digest-mysqlprotocolparser-caused-an-error/7367 "2024-02-23T20:08:39Z")
I used to run this command: tcpdump -i lo port 3306 -s 65535 -x -n -q -tttt \> pt.log; pt-query-digest --type=tcpdump pt.log But it stopped working for me. I cannot put my finger on the problem because I experience it o… --- ## [Alter data type of parent primary key with pt-online-schema-change?](https://forums.percona.com/t/alter-data-type-of-parent-primary-key-with-pt-online-schema-change/28298)
**Author:** [@SapientZero](https://forums.percona.com/u/SapientZero)\ **Replies:** 3\ **Last updated:** [February 21, 2024, 4:08pm UTC](https://forums.percona.com/t/alter-data-type-of-parent-primary-key-with-pt-online-schema-change/28298 "2024-02-21T16:08:26Z")
I need to alter my auto-increment PK data type from int signed to bigint unsigned since we are approaching the max range. This key is the parent for other foreign keys. Would the following pt-online-schema-change option… --- ## [Atomic table rename with pt-online-schema-change and Aurora replica](https://forums.percona.com/t/atomic-table-rename-with-pt-online-schema-change-and-aurora-replica/28449)
**Author:** [@Brian\_Hill](https://forums.percona.com/u/Brian_Hill)\ **Replies:** 3\ **Last updated:** [February 16, 2024, 4:23pm UTC](https://forums.percona.com/t/atomic-table-rename-with-pt-online-schema-change-and-aurora-replica/28449 "2024-02-16T16:23:09Z")
Hi, I have hopefully a quick question: I used pt-online-schema-change to rename a table like this: pt-online-schema-change --execute --alter "MODIFY value VARCHAR(4096)" \\ --ask-pass --host \[hostname\] --user \[usernam… --- ## [Sql\_log\_bin not supported in M-M-S replication on new pt-online-schema-change?](https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361)
**Author:** [@asavanidba](https://forums.percona.com/u/asavanidba)\ **Replies:** 1\ **Last updated:** [February 9, 2024, 3:37pm UTC](https://forums.percona.com/t/sql-log-bin-not-supported-in-m-m-s-replication-on-new-pt-online-schema-change/28361 "2024-02-09T15:37:38Z")
Hi Team, We are facing some issue with updated version of pt-online-schema-change. Issue : set sql\_log\_bin=OFF variable is not working with MMS (Master-Master-Slave) topology. Below are details: percona-toolkit-3.0.… --- ## [Pt-table-sync for PostgreSQL](https://forums.percona.com/t/pt-table-sync-for-postgresql/28239)
**Author:** [@ocgltd](https://forums.percona.com/u/ocgltd)\ **Replies:** 2\ **Last updated:** [February 6, 2024, 2:52pm UTC](https://forums.percona.com/t/pt-table-sync-for-postgresql/28239 "2024-02-06T14:52:38Z")
I see references to supporting PostgreSQL in the Percona toolkit, but in particular I’m looking to use pt-table-sync with PostgreSQL. Is this possible? --- ## [Pt-table-sync MySQL server has gone away](https://forums.percona.com/t/pt-table-sync-mysql-server-has-gone-away/27823)
**Author:** [@Ron](https://forums.percona.com/u/Ron)\ **Replies:** 4\ **Last updated:** [January 25, 2024, 7:31pm UTC](https://forums.percona.com/t/pt-table-sync-mysql-server-has-gone-away/27823 "2024-01-25T19:31:07Z")
Using pt-table-sync I keep getting MySQL server has gone away \[for Statement “SET NAMES ‘utf8mb4’”\] at line 10755 while doing dbname.large\_table\_name on hostname. Any ideas appreciated. Thanks! I am using percona-toolk… --- ## [Is this a BUG or an intended behavior, pt-archiver misses rows when archiving with a secondary index and option --no-delete](https://forums.percona.com/t/is-this-a-bug-or-an-intended-behavior-pt-archiver-misses-rows-when-archiving-with-a-secondary-index-and-option-no-delete/27742)
**Author:** [@Luke03011](https://forums.percona.com/u/Luke03011)\ **Replies:** 2\ **Last updated:** [January 15, 2024, 2:09am UTC](https://forums.percona.com/t/is-this-a-bug-or-an-intended-behavior-pt-archiver-misses-rows-when-archiving-with-a-secondary-index-and-option-no-delete/27742 "2024-01-15T02:09:17Z")
pt-archiver version is 3.5.4 and OS is Centos 7.9 When given a non-primary index to pt-archiver, it archives the wrong data set. Steps to repeat: create test tables create table t(id int not null primary key,c1 in… --- ## [Pt-query-digest table filtering](https://forums.percona.com/t/pt-query-digest-table-filtering/27730)
**Author:** [@spihiker](https://forums.percona.com/u/spihiker)\ **Replies:** 4\ **Last updated:** [January 15, 2024, 12:32am UTC](https://forums.percona.com/t/pt-query-digest-table-filtering/27730 "2024-01-15T00:32:31Z")
Hi. I use pt-query-digest to analyze mysql slow query log.When the following parameters are added: –filter ‘($event-\>{table} || “”) =~ m/^tab\_a$/i’ ，can’t work well. How to filter table? Thanks. --- ## [Could pt-archiver use a non-unique key as chunk index?](https://forums.percona.com/t/could-pt-archiver-use-a-non-unique-key-as-chunk-index/18620)
**Author:** [@Luke03011](https://forums.percona.com/u/Luke03011)\ **Replies:** 2\ **Last updated:** [January 12, 2024, 2:58am UTC](https://forums.percona.com/t/could-pt-archiver-use-a-non-unique-key-as-chunk-index/18620 "2024-01-12T02:58:20Z")
Assume I have a table defined as follows: create table t(id int primary key, c1 int,c2 int, idx\_c2(c2))engine=innodb I want to archive data satisfying the following condition: c2\>=value When I use --dry-run to run pt… --- ## [Pt-osc to use different storage for temporary table](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729)
**Author:** [@vdamyanov](https://forums.percona.com/u/vdamyanov)\ **Replies:** 2\ **Last updated:** [January 11, 2024, 11:51pm UTC](https://forums.percona.com/t/pt-osc-to-use-different-storage-for-temporary-table/27729 "2024-01-11T23:51:02Z")
While using pt-osc , is there an option or process to use for creating temporary table to different storage than current data folder of original table. Asking this in cases when we do not have enough space on current dat… --- ## [Trouble using pt-online schema change to add primary key (on a table that never had one)](https://forums.percona.com/t/trouble-using-pt-online-schema-change-to-add-primary-key-on-a-table-that-never-had-one/27666)
**Author:** [@jushean](https://forums.percona.com/u/jushean)\ **Replies:** 1\ **Last updated:** [January 9, 2024, 10:49pm UTC](https://forums.percona.com/t/trouble-using-pt-online-schema-change-to-add-primary-key-on-a-table-that-never-had-one/27666 "2024-01-09T22:49:00Z")
I have a huge table with no primary key (I know!) trying pt-online-schema-change with: –no-check-alter –no-check-unique-key-change –alter “ADD COLUMN id INT unsigned NOT NULL AUTO\_INCREMENT primary key FIRST” Error … --- ## [Percona Toolkit v3.5.6 Released](https://forums.percona.com/t/percona-toolkit-v3-5-6-released/27336)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [December 22, 2023, 7:45pm UTC](https://forums.percona.com/t/percona-toolkit-v3-5-6-released/27336 "2023-12-22T19:45:46Z")
December 21, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation [Previous page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=1) [Next page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=3)