# Polyglot Projects **URL:** https://forums.percona.com/c/polyglot-projects/26.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the Polyglot Projects category](https://forums.percona.com/t/about-the-polyglot-projects-category/31)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 0
For questions on Percona Toolkit, ProxySQL, & other tools/OS. --- ## [Pt-query-digest no truncate long params on history mode](https://forums.percona.com/t/pt-query-digest-no-truncate-long-params-on-history-mode/38001)
**Author:** [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Replies:** 1\ **Last updated:** [October 22, 2026, 7:34am UTC](https://forums.percona.com/t/pt-query-digest-no-truncate-long-params-on-history-mode/38001 "2026-10-22T07:34:22Z")
Hi all. When i collect report pt-query-digest to file - i see on long query trim for long parameters list (example) id in (2,3,4,5,6,6,7,8,8,9,124,324,25,24,524,6,264./\* … omited XXXX items … \*/ But when i run pt-quer… --- ## [Script pt-online-schema-change set new\_table\_name for all records in history table](https://forums.percona.com/t/script-pt-online-schema-change-set-new-table-name-for-all-records-in-history-table/39481)
**Author:** [@infis](https://forums.percona.com/u/infis)\ **Replies:** 1\ **Last updated:** [October 22, 2026, 7:28am UTC](https://forums.percona.com/t/script-pt-online-schema-change-set-new-table-name-for-all-records-in-history-table/39481 "2026-10-22T07:28:34Z")
I execute multiple jobs and found in history table pt\_osc\_history all records with one value in new\_table\_name field. In script I see: $ tail -n +9797 pt-online-schema-change | head -n 6 if ( $o-\>get('history') ) { … --- ## [Multi-tenant Orchestrator: managing multiple isolated MySQL/MariaDB environments from one deployment](https://forums.percona.com/t/multi-tenant-orchestrator-managing-multiple-isolated-mysql-mariadb-environments-from-one-deployment/41335)
**Author:** [@Maximo\_Martinez](https://forums.percona.com/u/Maximo_Martinez)\ **Replies:** 2\ **Last updated:** [October 16, 2026, 9:16am UTC](https://forums.percona.com/t/multi-tenant-orchestrator-managing-multiple-isolated-mysql-mariadb-environments-from-one-deployment/41335 "2026-10-16T09:16:37Z")
Hi everyone, I’ve been working on a multi-tenant implementation for Orchestrator and I’m looking for feedback from people managing multiple independent MySQL/MariaDB environments. The problem I wanted to solve is simpl… --- ## [Forged TCP RST (TTL 128) killing frontend sessions on ProxySQL 6033 — PXC 8.4.10 / ProxySQL 3.0.9](https://forums.percona.com/t/forged-tcp-rst-ttl-128-killing-frontend-sessions-on-proxysql-6033-pxc-8-4-10-proxysql-3-0-9/41292)
**Author:** [@smattana](https://forums.percona.com/u/smattana)\ **Replies:** 1\ **Last updated:** [October 9, 2026, 10:19am UTC](https://forums.percona.com/t/forged-tcp-rst-ttl-128-killing-frontend-sessions-on-proxysql-6033-pxc-8-4-10-proxysql-3-0-9/41292 "2026-10-09T10:19:50Z")
Environment ProxySQL 3.0.9, two nodes (keepalived VIP 10.160.9.72:6033) Percona XtraDB Cluster 8.4.10, 3 nodes, singlewrite (HG10 writer / 11 reader) Zabbix 7.0.19 frontend (PHP), Oracle Linux 9 Symptom Linking an MS… --- ## [Pt-osc / MariaDB 11.4 - triggers on new table where DEFINER was role1 - created with DEFINER as user (role1@%)](https://forums.percona.com/t/pt-osc-mariadb-11-4-triggers-on-new-table-where-definer-was-role1-created-with-definer-as-user-role1/41213)
**Author:** [@psumner](https://forums.percona.com/u/psumner)\ **Replies:** 2\ **Last updated:** [September 21, 2026, 5:03am UTC](https://forums.percona.com/t/pt-osc-mariadb-11-4-triggers-on-new-table-where-definer-was-role1-created-with-definer-as-user-role1/41213 "2026-09-21T05:03:33Z")
\@\:~$ pt-online-schema-change --version pt-online-schema-change 3.6.0 Recently ran pt-osc to add an index on a table which has after update/insert/delete triggers, all with DEFINER=role1 After successfully… --- ## [When will Percona Toolkit 3.7.2 be available?](https://forums.percona.com/t/when-will-percona-toolkit-3-7-2-be-available/40486)
**Author:** [@chris-card](https://forums.percona.com/u/chris-card)\ **Replies:** 10\ **Last updated:** [September 7, 2026, 1:54pm UTC](https://forums.percona.com/t/when-will-percona-toolkit-3-7-2-be-available/40486 "2026-09-07T13:54:42Z")
When will Percona Toolkit 3.7.2 be available? I want the fix for Jira --- ## [Pt-online schema change altering host IP; can't bypass replication checks](https://forums.percona.com/t/pt-online-schema-change-altering-host-ip-cant-bypass-replication-checks/40922)
**Author:** [@Alex\_Porter](https://forums.percona.com/u/Alex_Porter)\ **Replies:** 12\ **Last updated:** [June 26, 2026, 4:59pm UTC](https://forums.percona.com/t/pt-online-schema-change-altering-host-ip-cant-bypass-replication-checks/40922 "2026-06-26T16:59:19Z")
Hello, I’m trying to use pt-online-schema-change version 3.7.1 with MySQL 8.0.42 on AWS Aurora. I’m having the same issue described here, where it’s changing my host string to an IP address I can’t access. I’m tried s… --- ## [Pt-table-checksum 3.7.1: SHOW REPLICAS issued against MariaDB on builds with non-default version\_comment](https://forums.percona.com/t/pt-table-checksum-3-7-1-show-replicas-issued-against-mariadb-on-builds-with-non-default-version-comment/40774)
**Author:** [@samjvaughan](https://forums.percona.com/u/samjvaughan)\ **Replies:** 3\ **Last updated:** [May 14, 2026, 10:58pm UTC](https://forums.percona.com/t/pt-table-checksum-3-7-1-show-replicas-issued-against-mariadb-on-builds-with-non-default-version-comment/40774 "2026-05-14T22:58:52Z")
(apologies - tried to submit on Jira but I get persistent “you are not authorised” errors) pt-table-checksum 3.7.1: SHOW REPLICAS issued against MariaDB on builds with non-default version\_comment Summary pt-table-checks… --- ## [Package Conflicts with MariaDB 10.11 Community Repo and percona-toolkit on RHEL9](https://forums.percona.com/t/package-conflicts-with-mariadb-10-11-community-repo-and-percona-toolkit-on-rhel9/40020)
**Author:** [@fst](https://forums.percona.com/u/fst)\ **Replies:** 2\ **Last updated:** [January 12, 2026, 9:34am UTC](https://forums.percona.com/t/package-conflicts-with-mariadb-10-11-community-repo-and-percona-toolkit-on-rhel9/40020 "2026-01-12T09:34:35Z")
Hello everyone, I am having a problem installing the toolkit on RHEL9 and MariaDB 10.11 from the community repository. When I try to install it, there is always a package conflict between MariaDB-common (required by Ma… --- ## [MariaDB 11.8.5 error Argument "" isn't numeric in numeric comparison (\<=\>) at /usr/bin/pt-deadlock-logger line 5200](https://forums.percona.com/t/mariadb-11-8-5-error-argument-isnt-numeric-in-numeric-comparison-at-usr-bin-pt-deadlock-logger-line-5200/39875)
**Author:** [@poltpolt](https://forums.percona.com/u/poltpolt)\ **Replies:** 3\ **Last updated:** [January 2, 2026, 9:35am UTC](https://forums.percona.com/t/mariadb-11-8-5-error-argument-isnt-numeric-in-numeric-comparison-at-usr-bin-pt-deadlock-logger-line-5200/39875 "2026-01-02T09:35:42Z")
Hi on Ubuntu 24.04 i installed official deb pt-deadlock-logger 3.7.0 and mariadbd Ver 11.8.5-MariaDB-ubu2404-log I get the error from the topic, anybody has any ideeas and the line 5200 starts like this: foreach m… --- ## [My ProxySQL is getting unhealthy client connections and for that same query also get process\_all\_sessions() . How to fix this issue, Please help me with this ProxySQL issue](https://forums.percona.com/t/my-proxysql-is-getting-unhealthy-client-connections-and-for-that-same-query-also-get-process-all-sessions-how-to-fix-this-issue-please-help-me-with-this-proxysql-issue/39936)
**Author:** [@Shah\_Harshil\_Kiranku](https://forums.percona.com/u/Shah_Harshil_Kiranku)\ **Replies:** 0\ **Last updated:** [December 24, 2025, 11:10am UTC](https://forums.percona.com/t/my-proxysql-is-getting-unhealthy-client-connections-and-for-that-same-query-also-get-process-all-sessions-how-to-fix-this-issue-please-help-me-with-this-proxysql-issue/39936 "2025-12-24T11:10:40Z")
MySQL\_Thread.cpp:3899:ProcessAllSessions\_Healthy0(): \[WARNING\] Closing unhealthy client connection This is an issue with ProxySQL Multiplexing Please help me with this issue. Thank You. --- ## [Doubt Regarding Overriding Query Hostgroup](https://forums.percona.com/t/doubt-regarding-overriding-query-hostgroup/39732)
**Author:** [@Yash\_Daga](https://forums.percona.com/u/Yash_Daga)\ **Replies:** 0\ **Last updated:** [November 14, 2025, 7:37am UTC](https://forums.percona.com/t/doubt-regarding-overriding-query-hostgroup/39732 "2025-11-14T07:37:37Z")
I’m facing an issue with ProxySQL in Percona as I have some scripts which SET some user defined variables which disables multiplexing and locks connection to the writer hostgroup and later during the DQL statements I get… --- ## [Including ProxySQL3 in Percona-Repo for RHEL9](https://forums.percona.com/t/including-proxysql3-in-percona-repo-for-rhel9/39646)
**Author:** [@fst](https://forums.percona.com/u/fst)\ **Replies:** 1\ **Last updated:** [October 29, 2025, 11:21am UTC](https://forums.percona.com/t/including-proxysql3-in-percona-repo-for-rhel9/39646 "2025-10-29T11:21:53Z")
Hello, I wanted to ask whether there are plans to include the release of proxysql3 for RHEL9 in the repository. Currently, the latest managed version is 2.7.1-percona-1.2. Many thanks --- ## [Adverse effects of specifying --no-checkplan for pt-online-schema-change?](https://forums.percona.com/t/adverse-effects-of-specifying-no-checkplan-for-pt-online-schema-change/4557)
**Author:** [@dw\_rchau](https://forums.percona.com/u/dw_rchau)\ **Replies:** 2\ **Last updated:** [October 26, 2025, 3:12pm UTC](https://forums.percona.com/t/adverse-effects-of-specifying-no-checkplan-for-pt-online-schema-change/4557 "2025-10-26T15:12:56Z")
Hi there, I’ve recently run into a situation where I could not perform online alter table operations to modify the type of one column from tinyint(3) unsigned to int(10) unsigned using the pt-online-schema-change withou… --- ## [When is percona-toolkit coming to RHEL10?](https://forums.percona.com/t/when-is-percona-toolkit-coming-to-rhel10/39422)
**Author:** [@Seth\_Lohr](https://forums.percona.com/u/Seth_Lohr)\ **Replies:** 6\ **Last updated:** [October 1, 2025, 4:53pm UTC](https://forums.percona.com/t/when-is-percona-toolkit-coming-to-rhel10/39422 "2025-10-01T16:53:11Z")
For my own records, this is related to SOC-5151 It’s not listed as an option here: https://www.percona.com/percona-toolkit --- ## [Percona Toolkit 3.7 not showing for yum repo](https://forums.percona.com/t/percona-toolkit-3-7-not-showing-for-yum-repo/39448)
**Author:** [@jhbremer1](https://forums.percona.com/u/jhbremer1)\ **Replies:** 1\ **Last updated:** [September 25, 2025, 7:09am UTC](https://forums.percona.com/t/percona-toolkit-3-7-not-showing-for-yum-repo/39448 "2025-09-25T07:09:14Z")
Hello, I’m trying to update Percona Toolkit (specifically, the pt-table-checksum program) from 3.6→3.7. I’m running MySQL 8.4 instances, so that version of the toolkit is needed due to the keyword changes related to sla… --- ## [\--where clause incorrectly applied to child tables in pt-online-schema-change (causes “unknown column” error)](https://forums.percona.com/t/where-clause-incorrectly-applied-to-child-tables-in-pt-online-schema-change-causes-unknown-column-error/39442)
**Author:** [@rukbat](https://forums.percona.com/u/rukbat)\ **Replies:** 1\ **Last updated:** [September 24, 2025, 6:47pm UTC](https://forums.percona.com/t/where-clause-incorrectly-applied-to-child-tables-in-pt-online-schema-change-causes-unknown-column-error/39442 "2025-09-24T18:47:33Z")
Hello, when using pt-online-schema-change with the --where option on a table that has foreign-key child tables, the tool crashes during the row-estimate phase for each child. Steps to reproduce: Create two tables with… --- ## [Pt-archiver When archiving data, when encountering table data containing line breaks, an abnormal export occurs](https://forums.percona.com/t/pt-archiver-when-archiving-data-when-encountering-table-data-containing-line-breaks-an-abnormal-export-occurs/39285)
**Author:** [@baker](https://forums.percona.com/u/baker)\ **Replies:** 5\ **Last updated:** [September 16, 2025, 11:32am UTC](https://forums.percona.com/t/pt-archiver-when-archiving-data-when-encountering-table-data-containing-line-breaks-an-abnormal-export-occurs/39285 "2025-09-16T11:32:18Z")
I encountered a peculiar exception while archiving data using the pt-archiver tool. After investigation, I discovered that a varchar field in my source table contained a line break in its data. This altered the original … --- ## [When pt-archiver archives MySQL json fields, garbled characters appear](https://forums.percona.com/t/when-pt-archiver-archives-mysql-json-fields-garbled-characters-appear/39307)
**Author:** [@baker](https://forums.percona.com/u/baker)\ **Replies:** 2\ **Last updated:** [September 16, 2025, 4:50am UTC](https://forums.percona.com/t/when-pt-archiver-archives-mysql-json-fields-garbled-characters-appear/39307 "2025-09-16T04:50:23Z")
The scenario is as follows: This is the command executed: pt-archiver --limit 5000 --txn-size 5000 --progress 5000 --statistics --bulk-insert --charset=utf8mb4 --no-check-charset --no-check-columns Table character set… --- ## [Getting error "Plugin caching\_sha2\_password could not be loaded" on PT-QUERY-DIGEST](https://forums.percona.com/t/getting-error-plugin-caching-sha2-password-could-not-be-loaded-on-pt-query-digest/39308)
**Author:** [@FabricioPedrosoJorge](https://forums.percona.com/u/FabricioPedrosoJorge)\ **Replies:** 3\ **Last updated:** [September 11, 2025, 11:05am UTC](https://forums.percona.com/t/getting-error-plugin-caching-sha2-password-could-not-be-loaded-on-pt-query-digest/39308 "2025-09-11T11:05:43Z")
Hello dear Percona team, after modifying our users from “mysql\_native\_password“ to “caching\_sha2\_password“ authentication plugin, a script that calls “pt-query-digest“ started to fail with this error: DBI connect(';hos… --- ## [MySQL Server sees the ProxySQL IP and not the ClientsIP](https://forums.percona.com/t/mysql-server-sees-the-proxysql-ip-and-not-the-clientsip/39091)
**Author:** [@lbmdkap](https://forums.percona.com/u/lbmdkap)\ **Replies:** 2\ **Last updated:** [August 15, 2025, 9:21am UTC](https://forums.percona.com/t/mysql-server-sees-the-proxysql-ip-and-not-the-clientsip/39091 "2025-08-15T09:21:38Z")
As part of our POC we have ran into an “small” issue, where the MySQL (percona) server sees the IP of the ProxySQL node instead of the clientsIP, which then ofc result in access denied. We have an LB in front of the Pro… --- ## [Multiple independant clusters](https://forums.percona.com/t/multiple-independant-clusters/38969)
**Author:** [@lbmdkap](https://forums.percona.com/u/lbmdkap)\ **Replies:** 6\ **Last updated:** [August 7, 2025, 7:35am UTC](https://forums.percona.com/t/multiple-independant-clusters/38969 "2025-08-07T07:35:23Z")
Hi I’ve doing an POC on ProxySQL with PXC. So far so good, and for now doing very basic testing this works. We have multiple independant clusters (having the same kinda of data), lets call them DBC01,DBC02,DBC03 etc. I… --- ## [Pt-online-schema-change with master-master replication, how that work?](https://forums.percona.com/t/pt-online-schema-change-with-master-master-replication-how-that-work/38871)
**Author:** [@TAndreotti](https://forums.percona.com/u/TAndreotti)\ **Replies:** 4\ **Last updated:** [July 30, 2025, 6:10am UTC](https://forums.percona.com/t/pt-online-schema-change-with-master-master-replication-how-that-work/38871 "2025-07-30T06:10:17Z")
Hi, I have a master-master cluster (with an arbitrator to make the third node). My cluster contains 1000 databases with 170 tables. Our app connects through the cluster using an IP failover, so if the first server crash… --- ## [About ldap authentication](https://forums.percona.com/t/about-ldap-authentication/38806)
**Author:** [@helloyeops](https://forums.percona.com/u/helloyeops)\ **Replies:** 1\ **Last updated:** [July 24, 2025, 1:12pm UTC](https://forums.percona.com/t/about-ldap-authentication/38806 "2025-07-24T13:12:46Z")
According to this article, proxysql used to support ldap plugin only in enterprise mode: Is that still the case? --- ## [ProxySQL2 instllation guidance](https://forums.percona.com/t/proxysql2-instllation-guidance/38722)
**Author:** [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Replies:** 1\ **Last updated:** [July 18, 2025, 3:35pm UTC](https://forums.percona.com/t/proxysql2-instllation-guidance/38722 "2025-07-18T15:35:29Z")
Hi Folks, Can anyone provide a basic set of installation and configuration steps for ProxySQL, ive been going round and round in cicles with the product docs today trying to get it running. After installation I cannot … --- ## [HELP pt-query-digest for PROCESSLIST](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420)
**Author:** [@kpanacy\_olb](https://forums.percona.com/u/kpanacy_olb)\ **Replies:** 5\ **Last updated:** [July 3, 2025, 10:46am UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420 "2025-07-03T10:46:52Z")
Hello, I used Maatkit before it became Percona Toolkit and could regularly run this: mk-query-digest --processlist h=host,D=db,u=uname,p=pwd --print --interval 0.5 \> /tmp/process\_qry.log When I try to run pt-query-dige… --- ## [Pt-archiver --columns with alias](https://forums.percona.com/t/pt-archiver-columns-with-alias/38142)
**Author:** [@luisgasca](https://forums.percona.com/u/luisgasca)\ **Replies:** 1\ **Last updated:** [June 26, 2025, 7:23am UTC](https://forums.percona.com/t/pt-archiver-columns-with-alias/38142 "2025-06-26T07:23:52Z")
I need to export a given value which is extracted with a call to a function. Like so: SELECT getCountry(md) as geo FROM table It seems that --columns 'getCountry(md) as geo' does not work DBD::mysql::st execute failed… --- ## [Percona Toolkit in two repositories with different version](https://forums.percona.com/t/percona-toolkit-in-two-repositories-with-different-version/38439)
**Author:** [@AndreasM](https://forums.percona.com/u/AndreasM)\ **Replies:** 3\ **Last updated:** [June 25, 2025, 11:30am UTC](https://forums.percona.com/t/percona-toolkit-in-two-repositories-with-different-version/38439 "2025-06-25T11:30:06Z")
Hi all, just stumbled on a problem installing the newest version of percona-toolkit. I knew from your website that there is a new release 3.7.0-2 out there. I have percona-toolkit installed from your repositories and … --- ## [Problem with installing percona-toolkit 3.7.0](https://forums.percona.com/t/problem-with-installing-percona-toolkit-3-7-0/37371)
**Author:** [@Amir\_Kheirabadi](https://forums.percona.com/u/Amir_Kheirabadi)\ **Replies:** 1\ **Last updated:** [April 17, 2025, 11:26pm UTC](https://forums.percona.com/t/problem-with-installing-percona-toolkit-3-7-0/37371 "2025-04-17T23:26:03Z")
Hey, I’m having trouble installing percona-toolkit on Amazon Linux. The system currently has version 3.6.0 installed, but we need to upgrade to 3.7.0 to address some CVEs. However, it looks like version 3.7.0 isn’t avai… [Next page](https://forums.percona.com/c/polyglot-projects/26.md?page=1)