# Percona Toolkit **URL:** https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=1 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 2 --- ## [Pt-table-sync "unitialized value in concatenation" error](https://forums.percona.com/t/pt-table-sync-unitialized-value-in-concatenation-error/36710)
**Author:** [@nstretch](https://forums.percona.com/u/nstretch)\ **Replies:** 5\ **Last updated:** [February 15, 2025, 4:00pm UTC](https://forums.percona.com/t/pt-table-sync-unitialized-value-in-concatenation-error/36710 "2025-02-15T16:00:27Z")
I’ve been using pt-table-sync for a number of years to recover from database sync issues in MySQL and more recently MariaDB. It has been working without issue on our current servers for some time. No when I try to use it… --- ## [How to change character set/collation on one column in a very large table](https://forums.percona.com/t/how-to-change-character-set-collation-on-one-column-in-a-very-large-table/36632)
**Author:** [@eric.peterson](https://forums.percona.com/u/eric.peterson)\ **Replies:** 2\ **Last updated:** [February 11, 2025, 1:47pm UTC](https://forums.percona.com/t/how-to-change-character-set-collation-on-one-column-in-a-very-large-table/36632 "2025-02-11T13:47:02Z")
I do not want to run the following in production. Take forever while locking the table. ALTER TABLE \<2.5B row table\> MODIFY COLUMN TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4\_0900\_ai\_ci; SELECT @@aurora\_version a, VE… --- ## [Wide character in print at /usr/bin/pt-archiver line 6700.](https://forums.percona.com/t/wide-character-in-print-at-usr-bin-pt-archiver-line-6700/6502)
**Author:** [@le\_den](https://forums.percona.com/u/le_den)\ **Replies:** 27\ **Last updated:** [February 6, 2025, 6:06am UTC](https://forums.percona.com/t/wide-character-in-print-at-usr-bin-pt-archiver-line-6700/6502 "2025-02-06T06:06:17Z")
Hi all, I’m trying to archive some parts of our production DB but pt-archiver don’t want to run properly, it fails with “Wide character in print at /usr/bin/pt-archiver line 6700.” Our DB has some data encoded in diffe… --- ## [Install Percona Tools on Desktop Version of Ubuntu 24](https://forums.percona.com/t/install-percona-tools-on-desktop-version-of-ubuntu-24/36344)
**Author:** [@asawyer13](https://forums.percona.com/u/asawyer13)\ **Replies:** 2\ **Last updated:** [January 27, 2025, 9:03am UTC](https://forums.percona.com/t/install-percona-tools-on-desktop-version-of-ubuntu-24/36344 "2025-01-27T09:03:54Z")
Can Percona Tools be installed on a VM running Desktop Version of Ubuntu 24. Or is it better to use an existing VM that’s already have Percona Tools and Ubuntu 24 installed? --- ## [Pt-archiver archiving data line feed error（include \\n）](https://forums.percona.com/t/pt-archiver-archiving-data-line-feed-error-include-n/35996)
**Author:** [@huichao\_chen](https://forums.percona.com/u/huichao_chen)\ **Replies:** 1\ **Last updated:** [January 7, 2025, 3:16pm UTC](https://forums.percona.com/t/pt-archiver-archiving-data-line-feed-error-include-n/35996 "2025-01-07T15:16:55Z")
The data line contains \\n text, causing pt-archiver to mistake it for a newline character when archiving, and the target data is incorrect，Is there a good solution ################################################# #I d… --- ## [Sanitizing pt-query-digest output](https://forums.percona.com/t/sanitizing-pt-query-digest-output/35800)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 3\ **Last updated:** [December 27, 2024, 4:53pm UTC](https://forums.percona.com/t/sanitizing-pt-query-digest-output/35800 "2024-12-27T16:53:03Z")
I’m using the pt-query-digest tool to understand and explore our MySQL server. The problem is that I want to share the results but I have been told that I need to sanitize the report results before sharing it with collea… --- ## [Why I see so many "ROLLBACK" in slow log](https://forums.percona.com/t/why-i-see-so-many-rollback-in-slow-log/35613)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 3\ **Last updated:** [December 11, 2024, 6:18pm UTC](https://forums.percona.com/t/why-i-see-so-many-rollback-in-slow-log/35613 "2024-12-11T18:18:38Z")
Why do I see so many ROCLBACK commands in the Pt-query-digest output? I don’t understand how does it make sense. --- ## [Pt-online-schema-change: MySQL Warning 1062](https://forums.percona.com/t/pt-online-schema-change-mysql-warning-1062/35586)
**Author:** [@brianestrada658](https://forums.percona.com/u/brianestrada658)\ **Replies:** 2\ **Last updated:** [December 11, 2024, 1:43am UTC](https://forums.percona.com/t/pt-online-schema-change-mysql-warning-1062/35586 "2024-12-11T01:43:19Z")
I am using pt-online-schema-change 3.6.0 and I ran it like this: pt-online-schema-change –user=root –password=x –alter “MODIFY COLUMN c decimal(12,2) signed NOT NULL” –alter-foreign-keys-method=drop\_swap –max… --- ## [Percona Toolkit 3.6.0 Usage Issue with MySQL Client 9.0 on Mac OS Sonoma](https://forums.percona.com/t/percona-toolkit-3-6-0-usage-issue-with-mysql-client-9-0-on-mac-os-sonoma/35524)
**Author:** [@brianestrada658](https://forums.percona.com/u/brianestrada658)\ **Replies:** 1\ **Last updated:** [December 7, 2024, 1:12am UTC](https://forums.percona.com/t/percona-toolkit-3-6-0-usage-issue-with-mysql-client-9-0-on-mac-os-sonoma/35524 "2024-12-07T01:12:48Z")
I installed the Percona toolkit 3.6.0 via Brew and it installed fine. But when I tried to use it, eg. pt-online-schema-change, it does not work because it depends on MySQL client 9.0. The error is this: Cannot connect t… --- ## [Pt-archiver plugin error](https://forums.percona.com/t/pt-archiver-plugin-error/35356)
**Author:** [@brianestrada658](https://forums.percona.com/u/brianestrada658)\ **Replies:** 3\ **Last updated:** [November 30, 2024, 4:10am UTC](https://forums.percona.com/t/pt-archiver-plugin-error/35356 "2024-11-30T04:10:42Z")
I want to create a plugin for pt-archiver and I can’t seem to get it working. These are the relevant versions: $ pt-archiver --version pt-archiver 3.6.0 $ perl --version This is perl 5, version 38, subversion 2 (… --- ## [Using pt-osc(online schema change) in Multi-Master(Active/Passive) environment](https://forums.percona.com/t/using-pt-osc-online-schema-change-in-multi-master-active-passive-environment/35067)
**Author:** [@MahendraB](https://forums.percona.com/u/MahendraB)\ **Replies:** 4\ **Last updated:** [November 27, 2024, 4:17pm UTC](https://forums.percona.com/t/using-pt-osc-online-schema-change-in-multi-master-active-passive-environment/35067 "2024-11-27T16:17:12Z")
MySQL version : Percona Server for MySQL 5.7.40-43-log We have Master-Master(Active-Passive) Replication setup in our cluster. Only one Master(Active) is receiving the requests for writes while other one is Passive. Each… --- ## [How are PT users managing multiple users/password?](https://forums.percona.com/t/how-are-pt-users-managing-multiple-users-password/35010)
**Author:** [@swfd](https://forums.percona.com/u/swfd)\ **Replies:** 2\ **Last updated:** [November 13, 2024, 9:25pm UTC](https://forums.percona.com/t/how-are-pt-users-managing-multiple-users-password/35010 "2024-11-13T21:25:32Z")
I work in an environment with dozens of MySQL instances, where local MySQL logins are in use, and each instance has a different username/password combination (unfortunately this is out of my control at the moment). How a… --- ## [I don't understand how does --recursion-method=none and --check-slave-lag work together in pt-osc](https://forums.percona.com/t/i-dont-understand-how-does-recursion-method-none-and-check-slave-lag-work-together-in-pt-osc/34952)
**Author:** [@cookie](https://forums.percona.com/u/cookie)\ **Replies:** 1\ **Last updated:** [November 11, 2024, 10:06pm UTC](https://forums.percona.com/t/i-dont-understand-how-does-recursion-method-none-and-check-slave-lag-work-together-in-pt-osc/34952 "2024-11-11T22:06:05Z")
Hi there! I have following situation, I have a master, a slave, and two maxscale servers. When I try to perform the following: perl /bin/pt-online-schema-change \\ --check-slave-lag=h=slave.host,P=3306 \\ --recursion-me… --- ## [Pt-query-digest databases / tenants](https://forums.percona.com/t/pt-query-digest-databases-tenants/34369)
**Author:** [@kaihendry](https://forums.percona.com/u/kaihendry)\ **Replies:** 0\ **Last updated:** [October 14, 2024, 11:34am UTC](https://forums.percona.com/t/pt-query-digest-databases-tenants/34369 "2024-10-14T11:34:10Z")
I’m running pt-query-digest over slow logs of many several databases and I get output like so: # Databases foo\_d... (42/44%), bar\_doc... (26/27%)... 8 more How do I expand that list? And what does 42/44% or 26/27% e… --- ## [Docker pt-toolkit](https://forums.percona.com/t/docker-pt-toolkit/34039)
**Author:** [@Jyoti\_Rajai](https://forums.percona.com/u/Jyoti_Rajai)\ **Replies:** 4\ **Last updated:** [October 11, 2024, 3:04am UTC](https://forums.percona.com/t/docker-pt-toolkit/34039 "2024-10-11T03:04:16Z")
Hello here, I have 2 individual servers, Both have docker service on it & MySQL instance are hosted on that servers. On one server A on it’s docker server MySQL primary is hosted, On server B on it’s docker server MySQL… --- ## [Pt-online-schema-change not handling rename column properly](https://forums.percona.com/t/pt-online-schema-change-not-handling-rename-column-properly/33317)
**Author:** [@gilg](https://forums.percona.com/u/gilg)\ **Replies:** 6\ **Last updated:** [September 26, 2024, 5:18pm UTC](https://forums.percona.com/t/pt-online-schema-change-not-handling-rename-column-properly/33317 "2024-09-26T17:18:15Z")
Hey I have a table with columns x and x\_new i’m running pt-online-schema-change with the following alter DROP COLUMN x, RENAME COLUMN x\_new TO x the tool finishes successfully, now table has only column x, but the v… --- ## [Installing the last version of percona-toolkit](https://forums.percona.com/t/installing-the-last-version-of-percona-toolkit/33120)
**Author:** [@Amir\_Kheirabadi](https://forums.percona.com/u/Amir_Kheirabadi)\ **Replies:** 1\ **Last updated:** [September 13, 2024, 4:25pm UTC](https://forums.percona.com/t/installing-the-last-version-of-percona-toolkit/33120 "2024-09-13T16:25:19Z")
Hello, I’m working on addressing CVE-2023-45288 on a service that uses Percona. I noticed that this issue was resolved in the latest version (v3.6.0), but after reviewing the Dockerfile for our service, I found that ins… --- ## [Usage of Percona Toolkit in Production Environment](https://forums.percona.com/t/usage-of-percona-toolkit-in-production-environment/33004)
**Author:** [@Omer\_Faruk\_Icen](https://forums.percona.com/u/Omer_Faruk_Icen)\ **Replies:** 1\ **Last updated:** [September 9, 2024, 10:13am UTC](https://forums.percona.com/t/usage-of-percona-toolkit-in-production-environment/33004 "2024-09-09T10:13:23Z")
Dear Percona Team, I manage a Percona Cluster (Multi-Master Nodes) running MySQL version 5.7.40. We are experiencing significant slowdowns when adding indexes, in addition to table locking. I’ve been researching Percona… --- ## [Using pt-archiver with –no-delete option](https://forums.percona.com/t/using-pt-archiver-with-no-delete-option/31336)
**Author:** [@alessio](https://forums.percona.com/u/alessio)\ **Replies:** 3\ **Last updated:** [September 6, 2024, 1:18pm UTC](https://forums.percona.com/t/using-pt-archiver-with-no-delete-option/31336 "2024-09-06T13:18:08Z")
Hi there, I was wondering if it is possible to use pt-archiver with –no-delete option but reaching out a mysql replica Slave as a Source DB instead of Master DB , just with the aim of not bothering the master DB. I’m a… --- ## [Exhausted retries while deleting; rolling back 0 rows](https://forums.percona.com/t/exhausted-retries-while-deleting-rolling-back-0-rows/32867)
**Author:** [@SumitKumar](https://forums.percona.com/u/SumitKumar)\ **Replies:** 2\ **Last updated:** [September 3, 2024, 4:36pm UTC](https://forums.percona.com/t/exhausted-retries-while-deleting-rolling-back-0-rows/32867 "2024-09-03T16:36:44Z")
Hi, Please help foo below error during archival of table Error :- at /bin/pt-archiver line 5094. Exhausted retries while deleting; rolling back 0 rows. \[root@DELGEMSPVDBPROD01 archival\_job\_logs\]# screen -ls Percon… --- ## [Can pt-query-digest work if I log slow queries to table?](https://forums.percona.com/t/can-pt-query-digest-work-if-i-log-slow-queries-to-table/32839)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 1\ **Last updated:** [September 1, 2024, 10:40pm UTC](https://forums.percona.com/t/can-pt-query-digest-work-if-i-log-slow-queries-to-table/32839 "2024-09-01T22:40:22Z")
Can pt-query-digest work if I set log\_output to=‘TABLE’? Meaning it won’t use a log file but a table to store the slow queries data? --- ## [Understanding --limit in percona toolkit pt-query-digest](https://forums.percona.com/t/understanding-limit-in-percona-toolkit-pt-query-digest/32647)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 1\ **Last updated:** [August 28, 2024, 7:59am UTC](https://forums.percona.com/t/understanding-limit-in-percona-toolkit-pt-query-digest/32647 "2024-08-28T07:59:02Z")
I read all the docs and didn’t totally understand how --limit works. Why would I want to use the percentage option and not analyze all? Also, if I group by user, Will it give me a different result? because the limit ru… --- ## [Analyze MySQL load with Percona toolkit pt-query-digest](https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 2\ **Last updated:** [August 26, 2024, 2:49pm UTC](https://forums.percona.com/t/analyze-mysql-load-with-percona-toolkit-pt-query-digest/32571 "2024-08-26T14:49:23Z")
We have a problem when sometimes we have a lot of load on the MySQL but the cause is a lot of small queries and not slow ones. I had an idea to use the slow log and log all queries \> 0 (Meaning all) for several minutes … --- ## [Percona toolkit find where load is coming from](https://forums.percona.com/t/percona-toolkit-find-where-load-is-coming-from/32468)
**Author:** [@Idan\_Ahal](https://forums.percona.com/u/Idan_Ahal)\ **Replies:** 6\ **Last updated:** [August 26, 2024, 11:51am UTC](https://forums.percona.com/t/percona-toolkit-find-where-load-is-coming-from/32468 "2024-08-26T11:51:51Z")
I know the Percona toolkit has the option to analyze slow queries but can I use it to analyze and find what currently creates load on the MySQL? Sometimes we get into a situation where MySQL is on 100% CPU but we can’t … --- ## [Pt-archiver prevent binlogs](https://forums.percona.com/t/pt-archiver-prevent-binlogs/32416)
**Author:** [@Jost](https://forums.percona.com/u/Jost)\ **Replies:** 3\ **Last updated:** [August 24, 2024, 12:27am UTC](https://forums.percona.com/t/pt-archiver-prevent-binlogs/32416 "2024-08-24T00:27:13Z")
Hi everyone, I’m currently using an environment with an older Percona 5.7 cluster, and I’m facing the challenge of needing to drop a very large table—approximately 3.5 TB. To minimize impact, I’m planning to use pt-arch… --- ## [The output of slow.log is parsed by pt-query-digest tool into json format, and the Chinese code in sql statement is garbled](https://forums.percona.com/t/the-output-of-slow-log-is-parsed-by-pt-query-digest-tool-into-json-format-and-the-chinese-code-in-sql-statement-is-garbled/32489)
**Author:** [@jackpercona](https://forums.percona.com/u/jackpercona)\ **Replies:** 1\ **Last updated:** [August 21, 2024, 3:39pm UTC](https://forums.percona.com/t/the-output-of-slow-log-is-parsed-by-pt-query-digest-tool-into-json-format-and-the-chinese-code-in-sql-statement-is-garbled/32489 "2024-08-21T15:39:48Z")
The output of slow.log is json format when parsed by pt-query-digest tool, the Chinese code in sql statement appears garbled, mysql character encoding is utf8, is it an official bug? pt-query-digest --charset=utf8 slow.… --- ## [Pt-online-schema-change not working as expected](https://forums.percona.com/t/pt-online-schema-change-not-working-as-expected/13444)
**Author:** [@seebhoopi](https://forums.percona.com/u/seebhoopi)\ **Replies:** 13\ **Last updated:** [August 15, 2024, 7:22pm UTC](https://forums.percona.com/t/pt-online-schema-change-not-working-as-expected/13444 "2024-08-15T19:22:43Z")
I dont have foriegn key in my table, but still getting the below warning and error message. Please let me know the changes to make it work? bhoopathi@it:~$ pt-online-schema-change --alter-foreign-keys-method=none --dry-… --- ## [Pt-archiver --stop and --unstop options for idempotence](https://forums.percona.com/t/pt-archiver-stop-and-unstop-options-for-idempotence/31905)
**Author:** [@ghinoads](https://forums.percona.com/u/ghinoads)\ **Replies:** 0\ **Last updated:** [July 30, 2024, 1:20pm UTC](https://forums.percona.com/t/pt-archiver-stop-and-unstop-options-for-idempotence/31905 "2024-07-30T13:20:50Z")
Hello, I was wondering if there is a way to stop and restart a pt-archiver command with a specific WHERE clause, ensuring that the tool restarts exactly from the point where it was stopped, guaranteeing idempotence and … --- ## [Issue with 999999 ID limit in pt-archiver](https://forums.percona.com/t/issue-with-999999-id-limit-in-pt-archiver/3733)
**Author:** [@jimmy0x52](https://forums.percona.com/u/jimmy0x52)\ **Replies:** 7\ **Last updated:** [July 24, 2024, 5:54pm UTC](https://forums.percona.com/t/issue-with-999999-id-limit-in-pt-archiver/3733 "2024-07-24T17:54:26Z")
I posted this in the SO DBA forum and it was recommended I try here: \[url\]http://dba.stackexchange.com/questions/76256/percona-toolkit-pt-archiver-how-to-get-rid-of-999999-id-limit\[/url\] Basically, I have a 1.9 billion… --- ## [Can pt-kill Log User and Host Details in Log File?](https://forums.percona.com/t/can-pt-kill-log-user-and-host-details-in-log-file/31675)
**Author:** [@Asuwini\_P](https://forums.percona.com/u/Asuwini_P)\ **Replies:** 2\ **Last updated:** [July 18, 2024, 8:09am UTC](https://forums.percona.com/t/can-pt-kill-log-user-and-host-details-in-log-file/31675 "2024-07-18T08:09:45Z")
Is it possible to include the user and host details of killed queries in the pt-kill log file? Currently, I can see the following details: Timestamp Thread ID Query Time Query Are there any options to log the user and… [Previous page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md) [Next page](https://forums.percona.com/c/polyglot-projects/percona-toolkit/13.md?page=2)