# Polyglot Projects **URL:** https://forums.percona.com/c/polyglot-projects/26.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.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 --- ## [Percona operator for ProxySQL without XtraDB](https://forums.percona.com/t/percona-operator-for-proxysql-without-xtradb/30059)
**Author:** [@qonalex](https://forums.percona.com/u/qonalex)\ **Replies:** 2\ **Last updated:** [May 6, 2024, 3:46am UTC](https://forums.percona.com/t/percona-operator-for-proxysql-without-xtradb/30059 "2024-05-06T03:46:32Z")
Hello! We are going to use ProxySQL with our current MySQL server. Is this possible to use Percona Operator for MySQL for ProxySQL deployment purposes only? So we need to have Percona operator-managed ProxySQL cluster … --- ## [ProxySQL crash - Can't analyze it due to incomplete core dump](https://forums.percona.com/t/proxysql-crash-cant-analyze-it-due-to-incomplete-core-dump/29928)
**Author:** [@mmbih5ro](https://forums.percona.com/u/mmbih5ro)\ **Replies:** 4\ **Last updated:** [May 1, 2024, 1:46pm UTC](https://forums.percona.com/t/proxysql-crash-cant-analyze-it-due-to-incomplete-core-dump/29928 "2024-05-01T13:46:56Z")
Hey, I have a ProxySQL-Cluster that seems to crash around once every 1-2 days. The only information I get in the logs is: 2024-04-29 06:02:31 main.cpp:2435:main(): \[ERROR\] Watchdog: 4 threads missed a heartbeat 2024-0… --- ## [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… --- ## [Read/write split vs. weight in Proxysql](https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571)
**Author:** [@Lars\_Erik\_Dangvard\_J](https://forums.percona.com/u/Lars_Erik_Dangvard_J)\ **Replies:** 1\ **Last updated:** [April 7, 2024, 2:54am UTC](https://forums.percona.com/t/read-write-split-vs-weight-in-proxysql/29571 "2024-04-07T02:54:35Z")
Is setting the same weight for readers the same as making rules for reads to go to nodes configured as readers in Proxysql? Right now I have one PXC node that gets all writes and reads because of higher weight as both w… --- ## [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… --- ## [Proxysql Cluster and query logging](https://forums.percona.com/t/proxysql-cluster-and-query-logging/29365)
**Author:** [@Slawek](https://forums.percona.com/u/Slawek)\ **Replies:** 3\ **Last updated:** [March 27, 2024, 3:04pm UTC](https://forums.percona.com/t/proxysql-cluster-and-query-logging/29365 "2024-03-27T15:04:27Z")
Hello folks! I’m looking for a solution to store queries that go thry my proxysql cluster. Background: I have a cluster of three proxysql instances. Right now the traffic goes thru the only one of them at the time. Bu… --- ## [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… --- ## [Proxysql-admin utility](https://forums.percona.com/t/proxysql-admin-utility/28891)
**Author:** [@stofa.kenida](https://forums.percona.com/u/stofa.kenida)\ **Replies:** 1\ **Last updated:** [March 25, 2024, 6:20am UTC](https://forums.percona.com/t/proxysql-admin-utility/28891 "2024-03-25T06:20:43Z")
Hi, I think the documentation about proxysql-admin utility configuration file is very confusing and not clear at all. proxysql.user : Is it the user used to connect to proxysql instance from proxysql-admin ? clust… --- ## [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… --- ## [Proxysql failover](https://forums.percona.com/t/proxysql-failover/29271)
**Author:** [@ArtemGob](https://forums.percona.com/u/ArtemGob)\ **Replies:** 2\ **Last updated:** [March 21, 2024, 1:44pm UTC](https://forums.percona.com/t/proxysql-failover/29271 "2024-03-21T13:44:55Z")
Hi. I am using Proxy SQL version 2.5.5-percona-1.2. OS Debian 11 operating system. The question, the answer to which I could not find in the official proxy sql documentation. The scheme is as follows. 1)There is one p… --- ## [Percona docker image of ProxySQL 2.6?](https://forums.percona.com/t/percona-docker-image-of-proxysql-2-6/29170)
**Author:** [@Lars\_Erik\_Dangvard\_J](https://forums.percona.com/u/Lars_Erik_Dangvard_J)\ **Replies:** 2\ **Last updated:** [March 17, 2024, 9:31am UTC](https://forums.percona.com/t/percona-docker-image-of-proxysql-2-6/29170 "2024-03-17T09:31:33Z")
https://hub.docker.com/r/percona/proxysql2/tags 2.6 supports caching\_sha2\_password :slight\_smile: Is a 2.6 tag coming soon? --- ## [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… --- ## [Help understanding the doc and the process! pt-table-checksum/pt-table-sync, etc](https://forums.percona.com/t/help-understanding-the-doc-and-the-process-pt-table-checksum-pt-table-sync-etc/28494)
**Author:** [@joshlawrence](https://forums.percona.com/u/joshlawrence)\ **Replies:** 7\ **Last updated:** [February 16, 2024, 6:26pm UTC](https://forums.percona.com/t/help-understanding-the-doc-and-the-process-pt-table-checksum-pt-table-sync-etc/28494 "2024-02-16T18:26:57Z")
Hello everyone, For some time I have wanted to learn to use the pt-toolkit to help repair replication issues, but I’ve always had a terrible time understanding the documents. For example, do I run the tool on the sourc… --- ## [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… --- ## [Newbie ProxySQL user - Aborted connection errors on backend](https://forums.percona.com/t/newbie-proxysql-user-aborted-connection-errors-on-backend/15392)
**Author:** [@Deniska80](https://forums.percona.com/u/Deniska80)\ **Replies:** 5\ **Last updated:** [February 15, 2024, 9:11am UTC](https://forums.percona.com/t/newbie-proxysql-user-aborted-connection-errors-on-backend/15392 "2024-02-15T09:11:54Z")
Hello, testing proxysql on dev stage, there is only 1 backend server, proxysql running on the same machine. All looks great, sysbench test works throught proxysql without errors. But when i try to switch my web-app db c… --- ## [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… [Previous page](https://forums.percona.com/c/polyglot-projects/26.md?page=2) [Next page](https://forums.percona.com/c/polyglot-projects/26.md?page=4)