# \#mysql **URL:** https://forums.percona.com/tag/mysql/9.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [How should GCache size be determined for PXC?](https://forums.percona.com/t/how-should-gcache-size-be-determined-for-pxc/41230)
**Author:** [@Sekhri](https://forums.percona.com/u/Sekhri)\ **Replies:** 3\ **Last updated:** [September 7, 2026, 7:46am UTC](https://forums.percona.com/t/how-should-gcache-size-be-determined-for-pxc/41230 "2026-09-07T07:46:27Z")
I am running a 3-node Percona XtraDB Cluster on Kubernetes, where the PV size is selected dynamically by the user on the dashboard (minimum 50GB). What is the recommended approach for determining gcache.size? Is there … --- ## [Guidance needed for pt-table-checksum on MySQL master-master / source-source replication](https://forums.percona.com/t/guidance-needed-for-pt-table-checksum-on-mysql-master-master-source-source-replication/41142)
**Author:** [@degokul](https://forums.percona.com/u/degokul)\ **Replies:** 5\ **Last updated:** [September 6, 2026, 2:04am UTC](https://forums.percona.com/t/guidance-needed-for-pt-table-checksum-on-mysql-master-master-source-source-replication/41142 "2026-09-06T02:04:48Z")
Hi Percona community, I’m looking for guidance on the safest operational pattern for using \`pt-table-checksum\` in a MySQL master-master / source-source replication setup. Environment summary: Database: MySQL Enterpri… --- ## [XtraDB Cluster Nodes Vertical Scaling](https://forums.percona.com/t/xtradb-cluster-nodes-vertical-scaling/41209)
**Author:** [@Sekhri](https://forums.percona.com/u/Sekhri)\ **Replies:** 2\ **Last updated:** [August 27, 2026, 6:16pm UTC](https://forums.percona.com/t/xtradb-cluster-nodes-vertical-scaling/41209 "2026-08-27T18:16:18Z")
I have a 3-node Rancher Kubernetes cluster running Percona XtraDB Cluster (PXC). Each Kubernetes worker node currently has 4 vCPU and 16 GB RAM, and I would like to vertically scale each node to 8 vCPU and 32 GB RAM. Th… --- ## [PXC 8.4.6: LOCK\_ticket\_store\_ops mutex instances grow with cumulative connections](https://forums.percona.com/t/pxc-8-4-6-lock-ticket-store-ops-mutex-instances-grow-with-cumulative-connections/41203)
**Author:** [@Wu\_Nan\_Lin](https://forums.percona.com/u/Wu_Nan_Lin)\ **Replies:** 4\ **Last updated:** [August 25, 2026, 2:11pm UTC](https://forums.percona.com/t/pxc-8-4-6-lock-ticket-store-ops-mutex-instances-grow-with-cumulative-connections/41203 "2026-08-25T14:11:31Z")
Hello Percona team, We are seeing continuous growth of this Performance Schema mutex instance on a three-node staging PXC cluster: wait/synch/mutex/sql/MDL\_ticket\_store::LOCK\_ticket\_store\_ops Environment PXC: 8.4.6-6.… --- ## [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… --- ## [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… --- ## [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… --- ## [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 … --- ## [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… --- ## [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… --- ## [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\_… --- ## [MySQL table data count mismatch post DB restoration via xtrabackup 8.4](https://forums.percona.com/t/mysql-table-data-count-mismatch-post-db-restoration-via-xtrabackup-8-4/40646)
**Author:** [@Rahul93](https://forums.percona.com/u/Rahul93)\ **Replies:** 4\ **Last updated:** [April 20, 2026, 1:39pm UTC](https://forums.percona.com/t/mysql-table-data-count-mismatch-post-db-restoration-via-xtrabackup-8-4/40646 "2026-04-20T13:39:19Z")
Hi Everyone, We performed a backup and restoration of a MySQL 8.4 database using XtraBackup 8.4. During the backup process, the application was stopped, meaning no changes were made to the database. After the restorati… --- ## [Sst-idle-timeout killing sst after the donor has transferred all the data](https://forums.percona.com/t/sst-idle-timeout-killing-sst-after-the-donor-has-transferred-all-the-data/40634)
**Author:** [@Yash\_Daga](https://forums.percona.com/u/Yash_Daga)\ **Replies:** 2\ **Last updated:** [April 15, 2026, 8:46am UTC](https://forums.percona.com/t/sst-idle-timeout-killing-sst-after-the-donor-has-transferred-all-the-data/40634 "2026-04-15T08:46:56Z")
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 triggering sst transfer after deleting pvc’s for one of the node, but th… --- ## [Issue with audit\_log\_filter component on Replica Nodes in 3-Node MySQL InnoDB Cluster (Percona MySQL 8.4.7)](https://forums.percona.com/t/issue-with-audit-log-filter-component-on-replica-nodes-in-3-node-mysql-innodb-cluster-percona-mysql-8-4-7/40412)
**Author:** [@Dhivya\_Arumugam](https://forums.percona.com/u/Dhivya_Arumugam)\ **Replies:** 3\ **Last updated:** [March 30, 2026, 12:48pm UTC](https://forums.percona.com/t/issue-with-audit-log-filter-component-on-replica-nodes-in-3-node-mysql-innodb-cluster-percona-mysql-8-4-7/40412 "2026-03-30T12:48:16Z")
Hi Percona Support Team, I am testing the audit\_log\_filter component of Percona MySQL 8.4.7 on a 3-node MySQL InnoDB Cluster (Group Replication) setup and have observed inconsistent behavior between the primary and repl… --- ## [PXC Operator wsrep\_notify\_cmd handler hangs indefinitely on joiner state, curl to PITR has no timeout, blocks SST/IST](https://forums.percona.com/t/pxc-operator-wsrep-notify-cmd-handler-hangs-indefinitely-on-joiner-state-curl-to-pitr-has-no-timeout-blocks-sst-ist/40398)
**Author:** [@Yash\_Daga](https://forums.percona.com/u/Yash_Daga)\ **Replies:** 2\ **Last updated:** [March 25, 2026, 6:16pm UTC](https://forums.percona.com/t/pxc-operator-wsrep-notify-cmd-handler-hangs-indefinitely-on-joiner-state-curl-to-pitr-has-no-timeout-blocks-sst-ist/40398 "2026-03-25T18:16:07Z")
Hello, I’m was facing an issue in PXC Operator v1.19.0 where a missing curl timeout in the Galera notify handler permanently blocks nodes from rejoining the cluster. The Problem: When a PXC node enters joiner state, t… --- ## [Percona alternative solutions to MySQL 8.0 InnoDB ClusterSet](https://forums.percona.com/t/percona-alternative-solutions-to-mysql-8-0-innodb-clusterset/40361)
**Author:** [@y840530](https://forums.percona.com/u/y840530)\ **Replies:** 1\ **Last updated:** [March 15, 2026, 8:50am UTC](https://forums.percona.com/t/percona-alternative-solutions-to-mysql-8-0-innodb-clusterset/40361 "2026-03-15T08:50:53Z")
I would like to ask about alternative solutions to MySQL InnoDB ClusterSet. For Group Replication + Asynchronous Replication topology, could elaborate on how this architecture is composed? Regarding the MySQL Innod… --- ## [Full crash Percona after OOM](https://forums.percona.com/t/full-crash-percona-after-oom/40148)
**Author:** [@reddy\_nishanth](https://forums.percona.com/u/reddy_nishanth)\ **Replies:** 27\ **Last updated:** [March 10, 2026, 11:41am UTC](https://forums.percona.com/t/full-crash-percona-after-oom/40148 "2026-03-10T11:41:56Z")
Description: Why did my cluster crash and become non-recoverable after OOM? Steps to Reproduce: PXC cluster pods did OOM, and there were many restarts polaris@RKLAB-RVMHM255S006481:~$ k get all -n percona-operator NAME… --- ## [Issue with Trigger Causing Update Errors in Busy Node on Galera Cluster](https://forums.percona.com/t/issue-with-trigger-causing-update-errors-in-busy-node-on-galera-cluster/40337)
**Author:** [@Nazmul](https://forums.percona.com/u/Nazmul)\ **Replies:** 5\ **Last updated:** [March 10, 2026, 1:57am UTC](https://forums.percona.com/t/issue-with-trigger-causing-update-errors-in-busy-node-on-galera-cluster/40337 "2026-03-10T01:57:12Z")
We are experiencing an issue with a trigger in our MySQL Galera Cluster. We have a table, referred to as financial, defined as follows: CREATE TABLE \`financial\` ( \`TransactionId\` int unsigned NOT NULL AUTO\_INCREMENT, … --- ## [PXC connection timeout in multidc environment](https://forums.percona.com/t/pxc-connection-timeout-in-multidc-environment/40279)
**Author:** [@shirisha](https://forums.percona.com/u/shirisha)\ **Replies:** 6\ **Last updated:** [March 6, 2026, 5:19am UTC](https://forums.percona.com/t/pxc-connection-timeout-in-multidc-environment/40279 "2026-03-06T05:19:34Z")
Hi I have 5 node PXC cluster, 2 nodes in DC1, 3 nodes in DC2. I use GTM to manage active-passive cluster setup. Issue: Initially app was pointed to Node1 in DC1, which got timed out as seen from other node. But Node1 s… --- ## [PXC Operator Data at Rest encryption Vault alternatives like Openbao](https://forums.percona.com/t/pxc-operator-data-at-rest-encryption-vault-alternatives-like-openbao/40267)
**Author:** [@reddy\_nishanth](https://forums.percona.com/u/reddy_nishanth)\ **Replies:** 1\ **Last updated:** [February 23, 2026, 3:42pm UTC](https://forums.percona.com/t/pxc-operator-data-at-rest-encryption-vault-alternatives-like-openbao/40267 "2026-02-23T15:42:53Z")
Hi Team, Wanted to check if OpenBao can be used instead of Vault in the PXC operator, I was checking this About data at rest encryption - Percona Operator for MySQL to understand the reason why only vault is support? I… --- ## [Mysqlrouter "Application got fatal signal: 11" after upgrade to percona mysql 8.0.43-34-1.bullseye](https://forums.percona.com/t/mysqlrouter-application-got-fatal-signal-11-after-upgrade-to-percona-mysql-8-0-43-34-1-bullseye/39242)
**Author:** [@Salvatore\_Rotella](https://forums.percona.com/u/Salvatore_Rotella)\ **Replies:** 2\ **Last updated:** [February 20, 2026, 10:29pm UTC](https://forums.percona.com/t/mysqlrouter-application-got-fatal-signal-11-after-upgrade-to-percona-mysql-8-0-43-34-1-bullseye/39242 "2026-02-20T22:29:50Z")
Hi I just upgraded percona from version (8.0.42-33-1.bullseye) to (8.0.43-34-1.bullseye) and the percona-mysql-router is dumping: /usr/bin/mysqlrouter -c mysqlrouter.conf Application got fatal signal: 11 stack\_bottom… --- ## [XtraBackup 2.4 Full Backup Taking \>24 Hours on 10TB MySQL 5.7 Galera Cluster over NFS (HDD Storage)](https://forums.percona.com/t/xtrabackup-2-4-full-backup-taking-24-hours-on-10tb-mysql-5-7-galera-cluster-over-nfs-hdd-storage/40227)
**Author:** [@aycelen](https://forums.percona.com/u/aycelen)\ **Replies:** 2\ **Last updated:** [February 20, 2026, 4:09pm UTC](https://forums.percona.com/t/xtrabackup-2-4-full-backup-taking-24-hours-on-10tb-mysql-5-7-galera-cluster-over-nfs-hdd-storage/40227 "2026-02-20T16:09:21Z")
Hello, I am running a production MySQL 5.7 (Galera Cluster, 3 nodes) environment and facing extremely long backup times with XtraBackup (innobackupex 2.4.29). I would like to validate whether this behavior is expected g… --- ## [Libdbd-mysql-perl 1:5.013-1.noble breaks DBD::mysql after apt upgrade on Ubuntu 24.04](https://forums.percona.com/t/libdbd-mysql-perl-1-5-013-1-noble-breaks-dbd-mysql-after-apt-upgrade-on-ubuntu-24-04/40080)
**Author:** [@Milan](https://forums.percona.com/u/Milan)\ **Replies:** 6\ **Last updated:** [February 19, 2026, 11:23pm UTC](https://forums.percona.com/t/libdbd-mysql-perl-1-5-013-1-noble-breaks-dbd-mysql-after-apt-upgrade-on-ubuntu-24-04/40080 "2026-02-19T23:23:29Z")
We use Perl to query a Percona Server database via DBD::mysql. This stopped working yesterday after normal apt upgrade and broke our production system. It shows the package libdbd-mysql-perl 1:5.013-1.noble from Percon… --- ## [Support the Future of MySQL: Sign the Open Letter for a Neutral Foundation 📢](https://forums.percona.com/t/support-the-future-of-mysql-sign-the-open-letter-for-a-neutral-foundation/40231)
**Author:** [@Edith-Puclla](https://forums.percona.com/u/Edith-Puclla)\ **Replies:** 0\ **Last updated:** [February 17, 2026, 7:17pm UTC](https://forums.percona.com/t/support-the-future-of-mysql-sign-the-open-letter-for-a-neutral-foundation/40231 "2026-02-17T19:17:20Z")
Hi Community, The MySQL ecosystem is at a pivotal moment where broader collaboration is needed to bridge technical gaps and restore community trust. We are calling on Oracle to establish a vendor-neutral Foundation to m… --- ## [Is it possible to extract the user connection details and DDL statements into a MySQL table in Percona MySQL 8.4.7?](https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097)
**Author:** [@Ramasamy](https://forums.percona.com/u/Ramasamy)\ **Replies:** 1\ **Last updated:** [February 16, 2026, 6:04am UTC](https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097 "2026-02-16T06:04:40Z")
With the new audit filter plugin introduced in Percona MySQL Server 8.4.x, is it possible to extract the user connection details and DDL statements into a MySQL table in Percona MySQL 8.4.7 for our Security reports (dail… --- ## [Error Encountered "Malformed packet" when Executing GRANT Statements in MySQL Galera Cluster](https://forums.percona.com/t/error-encountered-malformed-packet-when-executing-grant-statements-in-mysql-galera-cluster/40168)
**Author:** [@Nazmul](https://forums.percona.com/u/Nazmul)\ **Replies:** 2\ **Last updated:** [February 12, 2026, 8:03am UTC](https://forums.percona.com/t/error-encountered-malformed-packet-when-executing-grant-statements-in-mysql-galera-cluster/40168 "2026-02-12T08:03:03Z")
Hi everyone, I am facing a challenge in my MySQL Galera Cluster setup while trying to generate and execute GRANT statements for a user with a bash script. Here’s a brief overview of my setup and the script I’m using: #… --- ## [Confusing state of Percona Software Repositories (apt)](https://forums.percona.com/t/confusing-state-of-percona-software-repositories-apt/40092)
**Author:** [@rwunderer](https://forums.percona.com/u/rwunderer)\ **Replies:** 6\ **Last updated:** [January 25, 2026, 8:01am UTC](https://forums.percona.com/t/confusing-state-of-percona-software-repositories-apt/40092 "2026-01-25T08:01:24Z")
Honestly, I find the current state of Percona Software repositories for apt tremendously confusing (not sure if the state of rpm repositories is the same): The documentation ( MySQL software repositories - Percona Soft… --- ## [How can we prevent PMM queries from appearing in the RDS MySQL slow query log?](https://forums.percona.com/t/how-can-we-prevent-pmm-queries-from-appearing-in-the-rds-mysql-slow-query-log/40079)
**Author:** [@srinivasms](https://forums.percona.com/u/srinivasms)\ **Replies:** 2\ **Last updated:** [January 24, 2026, 10:32pm UTC](https://forums.percona.com/t/how-can-we-prevent-pmm-queries-from-appearing-in-the-rds-mysql-slow-query-log/40079 "2026-01-24T22:32:36Z")
Description: we have around 2000 rds mysql instance being monitored by the PMM we have set the long\_query\_time set to 1 sec some times the pmm queries also get logged in the slow query log , which we dont want. how we c… [Next page](https://forums.percona.com/tag/mysql/9.md?match_all_tags=true&page=1&tags%5B%5D=mysql)