# MySQL & MariaDB **URL:** https://forums.percona.com/c/mysql-mariadb/36.md?page=7 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 8 --- ## [ProxySQL Admin Tool should handle parallel calls more robust](https://forums.percona.com/t/proxysql-admin-tool-should-handle-parallel-calls-more-robust/39335)
**Author:** [@kiskele](https://forums.percona.com/u/kiskele)\ **Replies:** 2\ **Last updated:** [September 25, 2025, 5:45am UTC](https://forums.percona.com/t/proxysql-admin-tool-should-handle-parallel-calls-more-robust/39335 "2025-09-25T05:45:09Z")
Percona XtraDB Operator calls proxysql-admin –syncusers –add-query-rules every 5 seconds. proxysql-admin begins with calling proxysql\_exec "$LINENO" "SAVE MYSQL SERVERS FROM RUNTIME" proxysql\_exec "$LINENO" "SAVE MYSQL… --- ## [Slow logs getting written to beginning of two files simultaneously](https://forums.percona.com/t/slow-logs-getting-written-to-beginning-of-two-files-simultaneously/39387)
**Author:** [@resuni](https://forums.percona.com/u/resuni)\ **Replies:** 6\ **Last updated:** [September 23, 2025, 5:19pm UTC](https://forums.percona.com/t/slow-logs-getting-written-to-beginning-of-two-files-simultaneously/39387 "2025-09-23T17:19:06Z")
I first want to clarify that this is NOT the common logrotate problem where logrotate moves the file and MySQL continues writing to the old descriptor. We have our logrotate set up properly to flush logs after rotating. … --- ## [Questions regarding node starts & table locks](https://forums.percona.com/t/questions-regarding-node-starts-table-locks/31920)
**Author:** [@david.lesicnik](https://forums.percona.com/u/david.lesicnik)\ **Replies:** 7\ **Last updated:** [September 22, 2025, 9:32pm UTC](https://forums.percona.com/t/questions-regarding-node-starts-table-locks/31920 "2025-09-22T21:32:31Z")
Hi everyone, We’re in the process of transitioning from a standard MySQL setup to Percona XtraDB Cluster (PXC). Our testing has been mostly successful, but we’ve encountered a few issues that we could use some help with… --- ## [Audit log file json format](https://forums.percona.com/t/audit-log-file-json-format/39306)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 2\ **Last updated:** [September 22, 2025, 2:15pm UTC](https://forums.percona.com/t/audit-log-file-json-format/39306 "2025-09-22T14:15:54Z")
Is there a way for the audit filter log file to log the same way as the old audit plugin? I used the json format for the old audit plugin and am using the json format for the audit filter log but they look completely di… --- ## [Percona helm 1.17.0 pxc-db mysql 5.7 pxc-db-proxysql is experiencing restarts. What are the causes, and how can this be resolved and optimized?](https://forums.percona.com/t/percona-helm-1-17-0-pxc-db-mysql-5-7-pxc-db-proxysql-is-experiencing-restarts-what-are-the-causes-and-how-can-this-be-resolved-and-optimized/39058)
**Author:** [@yl.w](https://forums.percona.com/u/yl.w)\ **Replies:** 1\ **Last updated:** [September 22, 2025, 1:57pm UTC](https://forums.percona.com/t/percona-helm-1-17-0-pxc-db-mysql-5-7-pxc-db-proxysql-is-experiencing-restarts-what-are-the-causes-and-how-can-this-be-resolved-and-optimized/39058 "2025-09-22T13:57:17Z")
Hello， ProxySQL is experiencing restarts，what are the causes, and how can this be resolved and optimized? #1 $ kubectl get pod -n percona-operator-mysql NAME READY STATUS RESTARTS… --- ## [Restore of Xtrabackup from standalone database to PXC on Kubernetes fails](https://forums.percona.com/t/restore-of-xtrabackup-from-standalone-database-to-pxc-on-kubernetes-fails/39190)
**Author:** [@letsmakesense](https://forums.percona.com/u/letsmakesense)\ **Replies:** 6\ **Last updated:** [September 22, 2025, 1:47pm UTC](https://forums.percona.com/t/restore-of-xtrabackup-from-standalone-database-to-pxc-on-kubernetes-fails/39190 "2025-09-22T13:47:10Z")
Description: We are in the process of moving from a Proxmox cluster to Kubernetes and need to transfer data from a Percona MySQL Server 8.0 to the Percona Operator for MySQL XtraDBCluster. I’m following this documentatio… --- ## [Restore from Azure Blob fails – mandatory metadata files are chunked, not reassembled](https://forums.percona.com/t/restore-from-azure-blob-fails-mandatory-metadata-files-are-chunked-not-reassembled/39118)
**Author:** [@noops](https://forums.percona.com/u/noops)\ **Replies:** 1\ **Last updated:** [September 22, 2025, 1:41pm UTC](https://forums.percona.com/t/restore-from-azure-blob-fails-mandatory-metadata-files-are-chunked-not-reassembled/39118 "2025-09-22T13:41:46Z")
Hi, I’m trying to restore a backup from Azure Blob Storage to a Percona XtraDB Cluster using the PerconaXtraDBClusterRestore CR. My CR looks like this: apiVersion: pxc.percona.com/v1 kind: PerconaXtraDBClusterRestore … --- ## [Xbcloud get incorrect listing on GET](https://forums.percona.com/t/xbcloud-get-incorrect-listing-on-get/39414)
**Author:** [@jon.hartley](https://forums.percona.com/u/jon.hartley)\ **Replies:** 1\ **Last updated:** [September 19, 2025, 3:26pm UTC](https://forums.percona.com/t/xbcloud-get-incorrect-listing-on-get/39414 "2025-09-19T15:26:49Z")
xbcloud get s3://${OBJECTBUCKET}/${NAMESPACE}/${CLUSTER\_NAME}/${BACKUP} --insecure --storage=s3 --s3-endpoint=${OBJECTENDPOINT} --s3-access-key=${ACCESSKEY} --s3-secret-key=${SECRETKEY} --s3-bucket=${OBJECTBUCKET} \> /dev… --- ## [Missing system level metrics in PMM server for RDS MySQL Community](https://forums.percona.com/t/missing-system-level-metrics-in-pmm-server-for-rds-mysql-community/13397)
**Author:** [@ashishps1](https://forums.percona.com/u/ashishps1)\ **Replies:** 8\ **Last updated:** [September 17, 2025, 1:49pm UTC](https://forums.percona.com/t/missing-system-level-metrics-in-pmm-server-for-rds-mysql-community/13397 "2025-09-17T13:49:58Z")
I have installed PMM server using docker (version 2.23.0). My RDS engine is MySQL Community and version 8.0.25. I followed Amazon RDS - Percona Monitoring and Management for setting up RDS instance in PMM. I am able t… --- ## [Percona Cluster : Issue with node recovery](https://forums.percona.com/t/percona-cluster-issue-with-node-recovery/39267)
**Author:** [@VithalAkunuri](https://forums.percona.com/u/VithalAkunuri)\ **Replies:** 5\ **Last updated:** [September 16, 2025, 10:31am UTC](https://forums.percona.com/t/percona-cluster-issue-with-node-recovery/39267 "2025-09-16T10:31:30Z")
Hi, PXC cluster with 5 nodes (mysql-pxc-0,mysql-pxc-1,mysql-pxc-2 ,mysql-pxc-3, mysql-pxc-4 are the pod names ) Operator version: 1.13.0 percona-xtradb-cluster image: percona/percona-xtradb-cluster:8.0.35 kubernetes … --- ## [One of the nodes in the Galera Cluster is down with error "mysqld got signal 11"](https://forums.percona.com/t/one-of-the-nodes-in-the-galera-cluster-is-down-with-error-mysqld-got-signal-11/39341)
**Author:** [@ocean](https://forums.percona.com/u/ocean)\ **Replies:** 9\ **Last updated:** [September 16, 2025, 12:55am UTC](https://forums.percona.com/t/one-of-the-nodes-in-the-galera-cluster-is-down-with-error-mysqld-got-signal-11/39341 "2025-09-16T00:55:48Z")
here is the error 2025-09-11T09:00:50Z UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID\[sha1\]=ae1efca2c0800a60ab995705a17c005525d455fc … --- ## [Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc\_strict\_mode = ENFORCING](https://forums.percona.com/t/percona-xtradb-cluster-doesnt-recommend-using-serializable-isolation-with-pxc-strict-mode-enforcing/16115)
**Author:** [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Replies:** 5\ **Last updated:** [September 15, 2025, 2:24pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-doesnt-recommend-using-serializable-isolation-with-pxc-strict-mode-enforcing/16115 "2025-09-15T14:24:38Z")
Hi there, when i am logging the database iam getting the below error… since the database is using REPEATABLE-READ isolation. Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc\_strict\_mode = … --- ## [Support for OpenBao for TDE Key Management](https://forums.percona.com/t/support-for-openbao-for-tde-key-management/28120)
**Author:** [@JoeMurray](https://forums.percona.com/u/JoeMurray)\ **Replies:** 9\ **Last updated:** [September 10, 2025, 7:36pm UTC](https://forums.percona.com/t/support-for-openbao-for-tde-key-management/28120 "2025-09-10T19:36:55Z")
Percona has integrations for key management for several of its products (MySQL, MongoDB, Postgres) with the formerly open source HashiCorp Vault product (changed to a Business Source License 1.1 2023-08-10 with most cove… --- ## [How to get audit log filter output which we got in legacy audit plugin. Please check below example](https://forums.percona.com/t/how-to-get-audit-log-filter-output-which-we-got-in-legacy-audit-plugin-please-check-below-example/39313)
**Author:** [@krunal](https://forums.percona.com/u/krunal)\ **Replies:** 1\ **Last updated:** [September 10, 2025, 7:03am UTC](https://forums.percona.com/t/how-to-get-audit-log-filter-output-which-we-got-in-legacy-audit-plugin-please-check-below-example/39313 "2025-09-10T07:03:19Z")
Hello Team, Anyone share explanation about how we can get audit log filter (new component based) output like Legacy audit plugin ? Please share audit filter definition if possible. – Legacy Plugin Output before/ and … --- ## [MySQL instance is in CrashLoopBackOff after killing pod](https://forums.percona.com/t/mysql-instance-is-in-crashloopbackoff-after-killing-pod/36360)
**Author:** [@AlexKuleshov](https://forums.percona.com/u/AlexKuleshov)\ **Replies:** 1\ **Last updated:** [September 8, 2025, 10:32am UTC](https://forums.percona.com/t/mysql-instance-is-in-crashloopbackoff-after-killing-pod/36360 "2025-09-08T10:32:08Z")
Description: Hello, I have deployed two percona-server instances with: unsafeFlags: mysqlSize: true proxy: true proxySize: true orchestrator: true orchestratorSize: true mysql: size: 2 imagePullSecrets: … --- ## [Open Source MySQL DBA ToolKit coded in PHP - CR\[U\]D DB](https://forums.percona.com/t/open-source-mysql-dba-toolkit-coded-in-php-cr-u-d-db/39288)
**Author:** [@ArorA\_Sameer](https://forums.percona.com/u/ArorA_Sameer)\ **Replies:** 0\ **Last updated:** [September 6, 2025, 7:53am UTC](https://forums.percona.com/t/open-source-mysql-dba-toolkit-coded-in-php-cr-u-d-db/39288 "2025-09-06T07:53:52Z")
Hi there, I have developed a small DBA toolkit in PHP to perform basic operations such: Create DB n user, drop DB, Backup n Download, Manage existing backups, monitor. The GitHub link for the same is given below: Fe… --- ## [Deprecated Warnings Causing Nodes to Drop From Cluster](https://forums.percona.com/t/deprecated-warnings-causing-nodes-to-drop-from-cluster/39227)
**Author:** [@Matthew\_Pinkston](https://forums.percona.com/u/Matthew_Pinkston)\ **Replies:** 3\ **Last updated:** [September 4, 2025, 1:58pm UTC](https://forums.percona.com/t/deprecated-warnings-causing-nodes-to-drop-from-cluster/39227 "2025-09-04T13:58:36Z")
Current Percona XtraDB Cluster Version: 8.0.41-32 (2025-03-13) We have a situation where running invalid SQL queries that produce deprecation warnings causes nodes to be ejected from the cluster. For instance in the exa… --- ## [Install component 'file://component\_percona\_udf' is failing post upgrade to 8.4](https://forums.percona.com/t/install-component-file-component-percona-udf-is-failing-post-upgrade-to-8-4/39225)
**Author:** [@srikar\_arutla](https://forums.percona.com/u/srikar_arutla)\ **Replies:** 5\ **Last updated:** [September 3, 2025, 4:11pm UTC](https://forums.percona.com/t/install-component-file-component-percona-udf-is-failing-post-upgrade-to-8-4/39225 "2025-09-03T16:11:12Z")
Hi, I just upgraded my percona server from 8.0 to 8.4 Iam trying to run below commad Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit. \* Run the following command to … --- ## [Xtrabackup crashed when redo log size exceed 128G](https://forums.percona.com/t/xtrabackup-crashed-when-redo-log-size-exceed-128g/39236)
**Author:** [@ksql-team](https://forums.percona.com/u/ksql-team)\ **Replies:** 1\ **Last updated:** [September 1, 2025, 3:52am UTC](https://forums.percona.com/t/xtrabackup-crashed-when-redo-log-size-exceed-128g/39236 "2025-09-01T03:52:52Z")
Using xtrabackup version 8.0.33 with MySQL 8.0.32. When using xtrabackup to back up a MySQL instance with a very large dataset, the redo log generated during the backup can be extremely large, exceeding 128GB. In such ca… --- ## [How to create new database and user with the chart](https://forums.percona.com/t/how-to-create-new-database-and-user-with-the-chart/28065)
**Author:** [@sohamc](https://forums.percona.com/u/sohamc)\ **Replies:** 14\ **Last updated:** [August 29, 2025, 7:51pm UTC](https://forums.percona.com/t/how-to-create-new-database-and-user-with-the-chart/28065 "2025-08-29T19:51:03Z")
Description: We are exploring GitHub - percona/percona-xtradb-cluster-operator: Percona Operator for MySQL based on Percona XtraDB Cluster to set up mysql cluster. Now I am looking to create an user(s) and empty database… --- ## [Percona MySQL Server 8.0 on Rocky 9.6](https://forums.percona.com/t/percona-mysql-server-8-0-on-rocky-9-6/39206)
**Author:** [@MaartenE](https://forums.percona.com/u/MaartenE)\ **Replies:** 8\ **Last updated:** [August 28, 2025, 10:19am UTC](https://forums.percona.com/t/percona-mysql-server-8-0-on-rocky-9-6/39206 "2025-08-28T10:19:30Z")
My last Percona MySQL Server 8.0.x deploy was on 2025-06-17 on Rocky Linux 9.6. Using percona-release-latest.noarch.rpm, which on that date was percona-release-1.0-30.noarch.rpm 27.6 KiB 2025-Feb-12 14:02. Today on Aug… --- ## [DROP 100000 table without DDL lock?](https://forums.percona.com/t/drop-100000-table-without-ddl-lock/39207)
**Author:** [@TAndreotti](https://forums.percona.com/u/TAndreotti)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 3:52pm UTC](https://forums.percona.com/t/drop-100000-table-without-ddl-lock/39207 "2025-08-27T15:52:50Z")
Hi, i have a Percona XtraDB Cluster 8.0.33-25.1 My cluster have 2 Master-node and a abritators. The cluster container ~1000 database with ~180 tables in each database ( its saas app… 1database by client ) We make a l… --- ## [Upgrade from 5.7 to 8](https://forums.percona.com/t/upgrade-from-5-7-to-8/39184)
**Author:** [@ultrapain](https://forums.percona.com/u/ultrapain)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 1:35pm UTC](https://forums.percona.com/t/upgrade-from-5-7-to-8/39184 "2025-08-27T13:35:46Z")
I have a Percona MySQL 5.7 Master/slave setup at the moment where the install was performed using RPMs. I stood up a 3 node Percona 8 cluster on a new set of servers, which is the architecture that we want to move to. … --- ## [Pt-online-schema-change --execute fails to connect after MySQL 8 upgrade, but --dry-run still works](https://forums.percona.com/t/pt-online-schema-change-execute-fails-to-connect-after-mysql-8-upgrade-but-dry-run-still-works/27897)
**Author:** [@JohnB](https://forums.percona.com/u/JohnB)\ **Replies:** 10\ **Last updated:** [August 26, 2025, 2:24pm UTC](https://forums.percona.com/t/pt-online-schema-change-execute-fails-to-connect-after-mysql-8-upgrade-but-dry-run-still-works/27897 "2025-08-26T14:24:19Z")
Good morning, If this belongs in the polyglot section, I apologize, but my issue is specific to MySQL 8. We’ve recently upgraded from MySQL 5.7 to MySQL 8 (Running in RDS Aurora 3.05.1). On 5.7, pt-ost worked as expec… --- ## [Increased Statistics Ratio in Database Load on Performance Insights When vCPU is Exceeded in AWS RDS for MySQL (8.0.42) During Load Spikes](https://forums.percona.com/t/increased-statistics-ratio-in-database-load-on-performance-insights-when-vcpu-is-exceeded-in-aws-rds-for-mysql-8-0-42-during-load-spikes/39171)
**Author:** [@wanskim](https://forums.percona.com/u/wanskim)\ **Replies:** 1\ **Last updated:** [August 24, 2025, 4:44am UTC](https://forums.percona.com/t/increased-statistics-ratio-in-database-load-on-performance-insights-when-vcpu-is-exceeded-in-aws-rds-for-mysql-8-0-42-during-load-spikes/39171 "2025-08-24T04:44:53Z")
Hello, I am using AWS RDS for MySQL (8.0.42). For performance testing related to an event, I applied a spike load to the database. The load was approximately 7 to 8 times the current vCPU capacity, with a sudden influx … --- ## [Clone plugin replica to replica cloning](https://forums.percona.com/t/clone-plugin-replica-to-replica-cloning/39191)
**Author:** [@jknight](https://forums.percona.com/u/jknight)\ **Replies:** 4\ **Last updated:** [August 21, 2025, 10:11pm UTC](https://forums.percona.com/t/clone-plugin-replica-to-replica-cloning/39191 "2025-08-21T22:11:38Z")
I have tried using a replica as the source to create a new replica using the clone plugin. All goes well except the binlog\_file, binlog\_position from performance\_schema.clone\_status shows a different log and position th… --- ## [Lost percona-xtrabackup-84\_8.4.0-3 in the tools repo](https://forums.percona.com/t/lost-percona-xtrabackup-84-8-4-0-3-in-the-tools-repo/39072)
**Author:** [@dimetrius](https://forums.percona.com/u/dimetrius)\ **Replies:** 2\ **Last updated:** [August 18, 2025, 3:38pm UTC](https://forums.percona.com/t/lost-percona-xtrabackup-84-8-4-0-3-in-the-tools-repo/39072 "2025-08-18T15:38:48Z")
Hello, we use mirror of tools and don’t see ‘percona-xtrabackup-84\_8.4.0-3-1’ package. The latest available is ‘percona-xtrabackup-84\_8.4.0-2-1’. But in the pxb-84-lts repo i see package ‘percona-xtrabackup-84\_8.4.0-3-1… --- ## [Trying to track down the cause of an error](https://forums.percona.com/t/trying-to-track-down-the-cause-of-an-error/38607)
**Author:** [@Gerwin\_van\_de\_Steeg](https://forums.percona.com/u/Gerwin_van_de_Steeg)\ **Replies:** 7\ **Last updated:** [August 18, 2025, 2:09pm UTC](https://forums.percona.com/t/trying-to-track-down-the-cause-of-an-error/38607 "2025-08-18T14:09:52Z")
Folks, I’m seeing an error with the backup of one of our Percona XtraDB databases which is: 2025-06-30 00:03:48.591 INFO: RECV thread exiting 0: Success 2025-06-30 00:03:48.591 INFO: Terminating SST script 2025-06-30… --- ## [All xtrabackup\_checkpoints file disappears after first incremental is prepared](https://forums.percona.com/t/all-xtrabackup-checkpoints-file-disappears-after-first-incremental-is-prepared/39033)
**Author:** [@dcbrown73](https://forums.percona.com/u/dcbrown73)\ **Replies:** 4\ **Last updated:** [August 18, 2025, 9:42am UTC](https://forums.percona.com/t/all-xtrabackup-checkpoints-file-disappears-after-first-incremental-is-prepared/39033 "2025-08-18T09:42:21Z")
Hi, I’m trying to setup xtrabackup automation, but I’m having an issue with preparing the backups. I run prepare on the base backup with –apply-log-only and it’s fine. I run prepare on the first incremental backup (in… --- ## [Frequent sporadic "MySQL server has gone away" errors with Operator for MySQL (XtraDB Cluster) and HAProxy](https://forums.percona.com/t/frequent-sporadic-mysql-server-has-gone-away-errors-with-operator-for-mysql-xtradb-cluster-and-haproxy/37974)
**Author:** [@jhwalker](https://forums.percona.com/u/jhwalker)\ **Replies:** 4\ **Last updated:** [August 15, 2025, 8:42am UTC](https://forums.percona.com/t/frequent-sporadic-mysql-server-has-gone-away-errors-with-operator-for-mysql-xtradb-cluster-and-haproxy/37974 "2025-08-15T08:42:17Z")
Description: We are running a Percona Operator for MySQL (XtraDB Cluster) cluster with 3 PXC replicas and 3 HAProxy replicas. This cluster is serving a PHP application that connects using PDO to the \-haprox… [Previous page](https://forums.percona.com/c/mysql-mariadb/36.md?page=6) [Next page](https://forums.percona.com/c/mysql-mariadb/36.md?page=8)