# MySQL & MariaDB **URL:** https://forums.percona.com/c/mysql-mariadb/36.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 --- ## [Tool repo nuked, percona-release setup broken for pxc80](https://forums.percona.com/t/tool-repo-nuked-percona-release-setup-broken-for-pxc80/40107)
**Author:** [@bvitnik](https://forums.percona.com/u/bvitnik)\ **Replies:** 8\ **Last updated:** [July 21, 2026, 2:17pm UTC](https://forums.percona.com/t/tool-repo-nuked-percona-release-setup-broken-for-pxc80/40107 "2026-07-21T14:17:18Z")
Hi all. I’ve just noticed that tools repo has been removed, i.e. it does not show in directory listing at: which is referenced by percona-release script. Technically it is still there: http :// repo . percona . com… --- ## [Wrong result with SUBSTRING\_INDEX(GROUP\_CONCAT(...)) when group\_concat\_max\_len is 2^28, 2^29 or 3\*2^28 in Percona Server 8.4.8-8](https://forums.percona.com/t/wrong-result-with-substring-index-group-concat-when-group-concat-max-len-is-2-28-2-29-or-3-2-28-in-percona-server-8-4-8-8/40959)
**Author:** [@thomas.liebold\_c24](https://forums.percona.com/u/thomas.liebold_c24)\ **Replies:** 1\ **Last updated:** [July 15, 2026, 1:19pm UTC](https://forums.percona.com/t/wrong-result-with-substring-index-group-concat-when-group-concat-max-len-is-2-28-2-29-or-3-2-28-in-percona-server-8-4-8-8/40959 "2026-07-15T13:19:14Z")
Project / Component Product: Percona Server for MySQL Version: 8.4.8-8 Component: SQL / Optimizer / GROUP\_CONCAT / Derived table materialization Severity: Major or Critical Type: Bug Description We observe a wrong query… --- ## [PXC 8.4.6-6.1: recurring MY-013183 assertions (btr0cur.cc:298, btr0pcur.cc:383)](https://forums.percona.com/t/pxc-8-4-6-6-1-recurring-my-013183-assertions-btr0cur-cc-298-btr0pcur-cc-383/40825)
**Author:** [@abhi\_sati](https://forums.percona.com/u/abhi_sati)\ **Replies:** 3\ **Last updated:** [July 10, 2026, 7:43am UTC](https://forums.percona.com/t/pxc-8-4-6-6-1-recurring-my-013183-assertions-btr0cur-cc-298-btr0pcur-cc-383/40825 "2026-07-10T07:43:12Z")
Hi all, We’re seeing a sustained pattern of InnoDB B-tree and page-invariant assertion failures across two independent 3-node Percona XtraDB Cluster deployments running the same build, and would appreciate any insight —… --- ## [Galera/PXC Cluster Permanent Stall: Failed DDL Voting Storm + Pending TOI Deadlock](https://forums.percona.com/t/galera-pxc-cluster-permanent-stall-failed-ddl-voting-storm-pending-toi-deadlock/40709)
**Author:** [@reddy\_nishanth](https://forums.percona.com/u/reddy_nishanth)\ **Replies:** 5\ **Last updated:** [July 7, 2026, 6:07am UTC](https://forums.percona.com/t/galera-pxc-cluster-permanent-stall-failed-ddl-voting-storm-pending-toi-deadlock/40709 "2026-07-07T06:07:24Z")
Description: A burst of ~50 failed ALTER TABLE … DROP PARTITION statements (Error 1507 - “Error in list of partitions to DROP”) issued sequentially across ~50 databases by a single application thread caused all three no… --- ## [Connecting to database through HAproxy](https://forums.percona.com/t/connecting-to-database-through-haproxy/40920)
**Author:** [@MarcH](https://forums.percona.com/u/MarcH)\ **Replies:** 19\ **Last updated:** [June 24, 2026, 6:30am UTC](https://forums.percona.com/t/connecting-to-database-through-haproxy/40920 "2026-06-24T06:30:19Z")
Following a directive to configure the proxy/percona setup to correctly identify client operations by source address, I reconfigured percona backends with send-proxy. I now have: source-host - proxy-node - percona node… --- ## [Conflict MariaDB when dnf from Percona repository](https://forums.percona.com/t/conflict-mariadb-when-dnf-from-percona-repository/40882)
**Author:** [@abh](https://forums.percona.com/u/abh)\ **Replies:** 5\ **Last updated:** [June 21, 2026, 11:05am UTC](https://forums.percona.com/t/conflict-mariadb-when-dnf-from-percona-repository/40882 "2026-06-21T11:05:27Z")
I usually install Percona and this is very weir when i see Marina as dependencies and of course it will conflict with Percona OS: Rocky Linux 10.x yum install https://repo.percona.com/yum/percona-release-latest.noarch.… --- ## [Percona xtradb cluster Settings](https://forums.percona.com/t/percona-xtradb-cluster-settings/40841)
**Author:** [@pkm2112](https://forums.percona.com/u/pkm2112)\ **Replies:** 4\ **Last updated:** [June 18, 2026, 6:48am UTC](https://forums.percona.com/t/percona-xtradb-cluster-settings/40841 "2026-06-18T06:48:35Z")
Dear members Request suggestion. Default value of pc.wait\_prim\_timeout is 30S. In a 3 node cluster, if I set it to 180S, will it help in a situation where bootstrap node starts after other 2 cluster members within 3min… --- ## [XtraDB & Kubernetes compatibility matrix](https://forums.percona.com/t/xtradb-kubernetes-compatibility-matrix/13577)
**Author:** [@katajistok](https://forums.percona.com/u/katajistok)\ **Replies:** 5\ **Last updated:** [June 16, 2026, 5:50pm UTC](https://forums.percona.com/t/xtradb-kubernetes-compatibility-matrix/13577 "2026-06-16T17:50:10Z")
Hello, Is there a compatibility matrix somewhere regarding to XtraDB (MySQL) and Kubernetes versioning? --- ## [Percona MySQL 8.4.8 - Crash Looping randomly](https://forums.percona.com/t/percona-mysql-8-4-8-crash-looping-randomly/40905)
**Author:** [@madhurbhaiya](https://forums.percona.com/u/madhurbhaiya)\ **Replies:** 12\ **Last updated:** [June 11, 2026, 1:49pm UTC](https://forums.percona.com/t/percona-mysql-8-4-8-crash-looping-randomly/40905 "2026-06-11T13:49:51Z")
Percona MySQL Version 8.4.8.8 All my tables are InnoDB. All have ROW\_FORMAT = COMPRESSED KEY\_BLOCK\_SIZE = 8 Since my upgrade to 8.4.8.8 across my fleet, I am getting random assertion errors in error.log causing crash … --- ## [What is the recommended way to rotate vault token for mysql?](https://forums.percona.com/t/what-is-the-recommended-way-to-rotate-vault-token-for-mysql/40864)
**Author:** [@Yash\_Daga](https://forums.percona.com/u/Yash_Daga)\ **Replies:** 3\ **Last updated:** [June 4, 2026, 5:31pm UTC](https://forums.percona.com/t/what-is-the-recommended-way-to-rotate-vault-token-for-mysql/40864 "2026-06-04T17:31:24Z")
I want to rotate the vault token inside the keyring.conf file, but I was concerned that if mysql only reads the token at startup and stores it in memory, how would it know when to read a fresh token from the keyring.conf… --- ## [ 45/5000 When using xtrabackup 8.0.33-27 to back up MySQL 8.0.1, I encountered a long backup time.](https://forums.percona.com/t/45-5000-when-using-xtrabackup-8-0-33-27-to-back-up-mysql-8-0-1-i-encountered-a-long-backup-time/40853)
**Author:** [@cheng](https://forums.percona.com/u/cheng)\ **Replies:** 1\ **Last updated:** [June 2, 2026, 4:35am UTC](https://forums.percona.com/t/45-5000-when-using-xtrabackup-8-0-33-27-to-back-up-mysql-8-0-1-i-encountered-a-long-backup-time/40853 "2026-06-02T04:35:18Z")
The backup process has not been completed for a long time. I checked and found that there is a slow SQL query. How can we adjust it? # User@Host: webuser\[webuser\] @ localhost \[\] Id: 352018 Query\_time: 70501.609143 Lo… --- ## [\[fixed\] Debconf \`percona-server-server/existing\_config\_file\` not taken into account when upgrade](https://forums.percona.com/t/fixed-debconf-percona-server-server-existing-config-file-not-taken-into-account-when-upgrade/40840)
**Author:** [@tchernomax](https://forums.percona.com/u/tchernomax)\ **Replies:** 3\ **Last updated:** [June 1, 2026, 2:46pm UTC](https://forums.percona.com/t/fixed-debconf-percona-server-server-existing-config-file-not-taken-into-account-when-upgrade/40840 "2026-06-01T14:46:48Z")
On debian /var/lib/dpkg/info/percona-server-server.postinst: case "$1" in configure) if \[ -z "$2" \]; then … else # If the existing config file is a proper… --- ## [Pt-online-schema-change failed at 23% on 501M row table — Is it possible to resume from where it left off?](https://forums.percona.com/t/pt-online-schema-change-failed-at-23-on-501m-row-table-is-it-possible-to-resume-from-where-it-left-off/40830)
**Author:** [@Srikanth\_Lingala](https://forums.percona.com/u/Srikanth_Lingala)\ **Replies:** 2\ **Last updated:** [May 28, 2026, 4:18pm UTC](https://forums.percona.com/t/pt-online-schema-change-failed-at-23-on-501m-row-table-is-it-possible-to-resume-from-where-it-left-off/40830 "2026-05-28T16:18:23Z")
Hello everyone Environment Percona XtraDB Cluster 5.7.44-48 (wsrep 31.65) 4-node Galera cluster pt-online-schema-change (latest on RHEL) Table: Attachments (~501 million rows) What I Was Doing Running a charset con… --- ## [Forced reboot a node and doesn't start automatically](https://forums.percona.com/t/forced-reboot-a-node-and-doesnt-start-automatically/40217)
**Author:** [@chernandez\_a3sec](https://forums.percona.com/u/chernandez_a3sec)\ **Replies:** 7\ **Last updated:** [May 16, 2026, 1:19am UTC](https://forums.percona.com/t/forced-reboot-a-node-and-doesnt-start-automatically/40217 "2026-05-16T01:19:57Z")
Hi I’m testing a 3-node percona cluster and when a node is forced rebooted, mysql doesn’t start automatically. systemctl status mysql gives me: mysql-systemd\[618\]: WARNING: Node has been rebooted, /var/lib/mysql/gra… --- ## [Percona Postgresql-17 pg\_tde configuration abd setup](https://forums.percona.com/t/percona-postgresql-17-pg-tde-configuration-abd-setup/40006)
**Author:** [@Johnathan](https://forums.percona.com/u/Johnathan)\ **Replies:** 4\ **Last updated:** [May 15, 2026, 5:44am UTC](https://forums.percona.com/t/percona-postgresql-17-pg-tde-configuration-abd-setup/40006 "2026-05-15T05:44:18Z")
I want to taste pg\_tde and need help configuring the global and masterkeys. I will later immplement a proper key management later --- ## [Xtrabackup --prepare fails: xtrabackup\_info file missing in streaming backup directory](https://forums.percona.com/t/xtrabackup-prepare-fails-xtrabackup-info-file-missing-in-streaming-backup-directory/40790)
**Author:** [@Justin\_Swanhart](https://forums.percona.com/u/Justin_Swanhart)\ **Replies:** 1\ **Last updated:** [May 13, 2026, 5:12am UTC](https://forums.percona.com/t/xtrabackup-prepare-fails-xtrabackup-info-file-missing-in-streaming-backup-directory/40790 "2026-05-13T05:12:12Z")
I’ve tested this twice now. i am using xtrabackup to stream a backup over netcat to another host: $ xtrabackup --backup --stream=xbstream | pigz | nc REDACTED 9999 and $ nc -l -p 9999 | gzip -d | xbstream -x -C /var/… --- ## [A crash about Semaphore wait](https://forums.percona.com/t/a-crash-about-semaphore-wait/40766)
**Author:** [@ocean](https://forums.percona.com/u/ocean)\ **Replies:** 3\ **Last updated:** [May 11, 2026, 3:47pm UTC](https://forums.percona.com/t/a-crash-about-semaphore-wait/40766 "2026-05-11T15:47:38Z")
My operating system version is Ubuntu 18.04, and the database is running on Percona Server for MySQL 5.7.34. The MySQL service crashed unexpectedly twice, on April 21 and May 6 respectively. Before the service outage, th… --- ## [MyRocks File Hints](https://forums.percona.com/t/myrocks-file-hints/40762)
**Author:** [@Jay\_Rafati](https://forums.percona.com/u/Jay_Rafati)\ **Replies:** 1\ **Last updated:** [May 11, 2026, 3:43pm UTC](https://forums.percona.com/t/myrocks-file-hints/40762 "2026-05-11T15:43:54Z")
Hi, does MyRocks sends file hints during compaction automatically or we have to configure that? I am running Sysbench/Percona MySQL/MyRocks with io\_uring. Want to make sure MyRocks Hints are getting passed to io\_uring a… --- ## [Pitr container not exiting after hitting failure](https://forums.percona.com/t/pitr-container-not-exiting-after-hitting-failure/40671)
**Author:** [@Yash\_Daga](https://forums.percona.com/u/Yash_Daga)\ **Replies:** 6\ **Last updated:** [May 6, 2026, 2:35pm UTC](https://forums.percona.com/t/pitr-container-not-exiting-after-hitting-failure/40671 "2026-05-06T14:35:58Z")
Setup: 3 node percona pxc cluster with the following percona images Operator: 1.19.0 Cluster: 8.0.42-33.1 Xtrabackup: 8.0.35-34.1 I was trying PITR, during which the restore job succeeded, but the pitr job failed be… --- ## [Does percona pam mondule for mysql support AD groups](https://forums.percona.com/t/does-percona-pam-mondule-for-mysql-support-ad-groups/4987)
**Author:** [@tharun](https://forums.percona.com/u/tharun)\ **Replies:** 1\ **Last updated:** [May 5, 2026, 5:16am UTC](https://forums.percona.com/t/does-percona-pam-mondule-for-mysql-support-ad-groups/4987 "2026-05-05T05:16:58Z")
Have anyone tried using percona pam module to get to work with Microsoft AD to map groups ? I was able to do the authentication but the group / proxy mapping seems to not work. --- ## [Is Percona PAM Authentication plugin compatible with MySQL 5.7?](https://forums.percona.com/t/is-percona-pam-authentication-plugin-compatible-with-mysql-5-7/4882)
**Author:** [@vitaly\_il](https://forums.percona.com/u/vitaly_il)\ **Replies:** 1\ **Last updated:** [May 5, 2026, 3:07am UTC](https://forums.percona.com/t/is-percona-pam-authentication-plugin-compatible-with-mysql-5-7/4882 "2026-05-05T03:07:37Z")
Is Percona PAM Authentication plugin compatible with MySQL 5.7? TIA, Vitaly --- ## [Getting a lot of Wsrep\_rollback\_local logs and failed transactions](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415)
**Author:** [@karl123](https://forums.percona.com/u/karl123)\ **Replies:** 5\ **Last updated:** [May 1, 2026, 10:01am UTC](https://forums.percona.com/t/getting-a-lot-of-wsrep-rollback-local-logs-and-failed-transactions/40415 "2026-05-01T10:01:31Z")
Hi, I have finally migrated my DB from 5.7 to 8.4. Everything nominally works… But I am frequently getting Wsrep\_rollback\_local log entries (1 per min) on each of my 3 nodes. I did not have this problem on 5.7… It is ca… --- ## [Feature Request: CR field to set sizeLimit on the PXC operator-managed tmp emptyDir volume](https://forums.percona.com/t/feature-request-cr-field-to-set-sizelimit-on-the-pxc-operator-managed-tmp-emptydir-volume/40729)
**Author:** [@Julio\_Guevara](https://forums.percona.com/u/Julio_Guevara)\ **Replies:** 1\ **Last updated:** [April 30, 2026, 6:59am UTC](https://forums.percona.com/t/feature-request-cr-field-to-set-sizelimit-on-the-pxc-operator-managed-tmp-emptydir-volume/40729 "2026-04-30T06:59:26Z")
The PXC Operator mounts a hardcoded emptyDir: {} volume at tmp (MySQL’s tmpdir) on every PXC pod. This volume has no sizeLimit, and there is no Custom Resource field to set one. The only lever available today is pxc.reso… --- ## [Audit\_log\_filter not working with new version of MySQL](https://forums.percona.com/t/audit-log-filter-not-working-with-new-version-of-mysql/40706)
**Author:** [@IGGt](https://forums.percona.com/u/IGGt)\ **Replies:** 1\ **Last updated:** [April 27, 2026, 2:55am UTC](https://forums.percona.com/t/audit-log-filter-not-working-with-new-version-of-mysql/40706 "2026-04-27T02:55:22Z")
Having finally managed to get the audit\_log\_filter component to work with MySQL 8.4, I downloaded the new version of MySQL 8.4.9, and now it doesn’t work again. In fact it just causes the database to crash. I appreciate… --- ## [MySQL/MyRocks Tuning](https://forums.percona.com/t/mysql-myrocks-tuning/40704)
**Author:** [@Jay\_Rafati](https://forums.percona.com/u/Jay_Rafati)\ **Replies:** 1\ **Last updated:** [April 24, 2026, 1:07pm UTC](https://forums.percona.com/t/mysql-myrocks-tuning/40704 "2026-04-24T13:07:02Z")
How to tune MyRocks to use NVMe SSD drive having very large FDP Reclaim Unit size of 16G? --- ## [\--safe-slave-backup causing replication stop on HSB and rebuild failures in MySQL 8.0 Clusters](https://forums.percona.com/t/safe-slave-backup-causing-replication-stop-on-hsb-and-rebuild-failures-in-mysql-8-0-clusters/40703)
**Author:** [@pravata\_dash](https://forums.percona.com/u/pravata_dash)\ **Replies:** 1\ **Last updated:** [April 23, 2026, 4:50pm UTC](https://forums.percona.com/t/safe-slave-backup-causing-replication-stop-on-hsb-and-rebuild-failures-in-mysql-8-0-clusters/40703 "2026-04-23T16:50:16Z")
Hello Team, We are running Percona XtraBackup against MySQL 8 in a replication / HA setup. We use our HSB(Hot Standby) to rebuild read replicas (restore + CHANGE REPLICATION SOURCE / CHANGE MASTER from xtrabackup\_slave\_… --- ## [Percona MySQL 8.4.8 Loop Crashing (Audit related?)](https://forums.percona.com/t/percona-mysql-8-4-8-loop-crashing-audit-related/40699)
**Author:** [@rafaelpastre](https://forums.percona.com/u/rafaelpastre)\ **Replies:** 2\ **Last updated:** [April 23, 2026, 7:08am UTC](https://forums.percona.com/t/percona-mysql-8-4-8-loop-crashing-audit-related/40699 "2026-04-23T07:08:25Z")
My Percona for MySQL 8.4.8 started loop crashing after going Live, and just came back online after removing audit related parameters from my.cnf. Any idea guys? After hashing out the follwing variables, the instance ca… --- ## [“Galera Cluster: Same server\_id on all nodes and different gtid\_domain\_id — is this safe?”](https://forums.percona.com/t/galera-cluster-same-server-id-on-all-nodes-and-different-gtid-domain-id-is-this-safe/40392)
**Author:** [@Sergey\_DSV](https://forums.percona.com/u/Sergey_DSV)\ **Replies:** 6\ **Last updated:** [April 22, 2026, 8:15pm UTC](https://forums.percona.com/t/galera-cluster-same-server-id-on-all-nodes-and-different-gtid-domain-id-is-this-safe/40392 "2026-04-22T20:15:19Z")
I have a MariaDB (Galera) cluster that has been running in production for about 5 years without any noticeable issues. The cluster consists of 5 nodes. However, I recently noticed an unusual configuration: All nodes … --- ## [Amazon Linux2023安装XtraBackup2.4](https://forums.percona.com/t/amazon-linux2023-xtrabackup2-4/40650)
**Author:** [@ddf](https://forums.percona.com/u/ddf)\ **Replies:** 13\ **Last updated:** [April 22, 2026, 7:29pm UTC](https://forums.percona.com/t/amazon-linux2023-xtrabackup2-4/40650 "2026-04-22T19:29:43Z")
Amazon Linux2023安装XtraBackup2.4失败， 安装之后显示： \[root@ip-172-31-37-135 bin\]# sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm Last metadata expiration check: 2:00:08 ago on Fri Apr 17 06:02:… --- ## [Percona toolkit pt-show-grants 3.7.1 broken on Debian 13](https://forums.percona.com/t/percona-toolkit-pt-show-grants-3-7-1-broken-on-debian-13/40009)
**Author:** [@thomariobros](https://forums.percona.com/u/thomariobros)\ **Replies:** 18\ **Last updated:** [April 22, 2026, 9:21am UTC](https://forums.percona.com/t/percona-toolkit-pt-show-grants-3-7-1-broken-on-debian-13/40009 "2026-04-22T09:21:41Z")
Hello, Installed percona-server 8.4.7 and percona-toolkit on Debian 13 using Percona apt repository. percona-server-server package version is 8.4.7-7-1.trixie percona-toolkit package (containing pt-show-grants) versio… [Previous page](https://forums.percona.com/c/mysql-mariadb/36.md) [Next page](https://forums.percona.com/c/mysql-mariadb/36.md?page=2)