# Polyglot Projects **URL:** https://forums.percona.com/c/polyglot-projects/26.md?page=4 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 5 --- ## [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 --- ## [SSRS (Snowflake): Select/Filter column by string with a comma in it](https://forums.percona.com/t/ssrs-snowflake-select-filter-column-by-string-with-a-comma-in-it/27144)
**Author:** [@MOKSHAGNYA\_A](https://forums.percona.com/u/MOKSHAGNYA_A)\ **Replies:** 1\ **Last updated:** [December 14, 2023, 3:33pm UTC](https://forums.percona.com/t/ssrs-snowflake-select-filter-column-by-string-with-a-comma-in-it/27144 "2023-12-14T15:33:47Z")
A column in a Table I am querying has values ‘183160,WELD’, ‘87491,WELD’, ‘874910,WELD’, ‘87491N,WELD’. In Snowflake, I started with this Case Statement: When ProcedureCode In('183160,WELD', '87491,WELD', '874910,WELD'… --- ## [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 --- ## [SSL enabled Proxysql - How to configure proxysql to allow only encrypted front-end connections?](https://forums.percona.com/t/ssl-enabled-proxysql-how-to-configure-proxysql-to-allow-only-encrypted-front-end-connections/26805)
**Author:** [@preethi\_subbu](https://forums.percona.com/u/preethi_subbu)\ **Replies:** 3\ **Last updated:** [November 30, 2023, 2:09pm UTC](https://forums.percona.com/t/ssl-enabled-proxysql-how-to-configure-proxysql-to-allow-only-encrypted-front-end-connections/26805 "2023-11-30T14:09:37Z")
Hi, I have enabled SSL for front-end connections in proxysql-2.5.5. select \* from global\_variables where variable\_name LIKE 'mysql-have\_ssl'; +----------------+----------------+ | variable\_name | variable\_value | +---… --- ## [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… --- ## [Proxysql-admin --config-file=\<.cnf file\> --syncuser error](https://forums.percona.com/t/proxysql-admin-config-file-cnf-file-syncuser-error/25370)
**Author:** [@flaviog](https://forums.percona.com/u/flaviog)\ **Replies:** 4\ **Last updated:** [September 23, 2023, 7:41am UTC](https://forums.percona.com/t/proxysql-admin-config-file-cnf-file-syncuser-error/25370 "2023-09-23T07:41:30Z")
Hello , I’m approaching to manage for the first time a 3 nodes mysql cluster managed with proxysql. Into mysql database i created a new user. At mysql level the user is correctly replicated among nodes. Also In mysql a… --- ## [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… --- ## [ProxySQL Crashing - Signal 11](https://forums.percona.com/t/proxysql-crashing-signal-11/24465)
**Author:** [@daa](https://forums.percona.com/u/daa)\ **Replies:** 2\ **Last updated:** [August 18, 2023, 3:10pm UTC](https://forums.percona.com/t/proxysql-crashing-signal-11/24465 "2023-08-18T15:10:55Z")
We have two instances of ProxySQL - one on version 2.4.8 and the other on 2.0.17. They are running different workloads, but they are both configured to work with the same cluster, running PXC 5.7.34-57. Over the past f… --- ## [ProxySQL 2.5.4 and ProxySQL Admin Tools Released](https://forums.percona.com/t/proxysql-2-5-4-and-proxysql-admin-tools-released/23849)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [July 24, 2023, 9:40am UTC](https://forums.percona.com/t/proxysql-2-5-4-and-proxysql-admin-tools-released/23849 "2023-07-24T09:40:40Z")
July 24, 2023 - Find release notes at ProxySQL 2.5.4 and ProxySQL admin tools (2023-07-24) - Percona ProxySQL admin tools --- ## [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 --- ## [ProxySQL 2.5.2 and ProxySQL Admin Tools Released](https://forums.percona.com/t/proxysql-2-5-2-and-proxysql-admin-tools-released/23130)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 26, 2023, 6:07pm UTC](https://forums.percona.com/t/proxysql-2-5-2-and-proxysql-admin-tools-released/23130 "2023-06-26T18:07:26Z")
June 26, 2023 - Find release notes at ProxySQL 2.5.2 and ProxySQL admin tools (2023-06-26) - Percona ProxySQL admin tools --- ## [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 [Previous page](https://forums.percona.com/c/polyglot-projects/26.md?page=3) [Next page](https://forums.percona.com/c/polyglot-projects/26.md?page=5)