# MySQL & MariaDB **URL:** https://forums.percona.com/c/mysql-mariadb/36.md?page=6 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 7 --- ## [What is the difference between MyISAM and InnoDB tables?](https://forums.percona.com/t/what-is-the-difference-between-myisam-and-innodb-tables/39730)
**Author:** [@SQLCaesar](https://forums.percona.com/u/SQLCaesar)\ **Replies:** 3\ **Last updated:** [November 17, 2025, 7:07pm UTC](https://forums.percona.com/t/what-is-the-difference-between-myisam-and-innodb-tables/39730 "2025-11-17T19:07:52Z")
Hello Percona Community, We would like to better understand the following topic regarding the use of MyISAM and InnoDB tables. Is my understanding correct that PXC needs the transactional capabilities and row-level loc… --- ## [After importing data in pxc8.0, the restart failed without any error message.](https://forums.percona.com/t/after-importing-data-in-pxc8-0-the-restart-failed-without-any-error-message/39722)
**Author:** [@wxc](https://forums.percona.com/u/wxc)\ **Replies:** 1\ **Last updated:** [November 14, 2025, 9:36am UTC](https://forums.percona.com/t/after-importing-data-in-pxc8-0-the-restart-failed-without-any-error-message/39722 "2025-11-14T09:36:36Z")
After importing data in pxc 8.0, the restart failed without any error message. --- ## [Cluster broke after \[InnoDB\] Assertion failure: row0ins.cc:279:!cursor-\>index-\>is\_committed()](https://forums.percona.com/t/cluster-broke-after-innodb-assertion-failure-row0ins-cc-cursor-index-is-committed/39699)
**Author:** [@shakalandy](https://forums.percona.com/u/shakalandy)\ **Replies:** 5\ **Last updated:** [November 13, 2025, 5:04am UTC](https://forums.percona.com/t/cluster-broke-after-innodb-assertion-failure-row0ins-cc-cursor-index-is-committed/39699 "2025-11-13T05:04:59Z")
Hi, yesterday we had a severe incident on one of our productive clusters running the recent percona-xtradb-cluster-server version 8.0.43-34-1. The cluster consists of 3 nodes, of which 2 shutdown with the same error me… --- ## [Installing for ARM64 - Missing Telemetry Agent](https://forums.percona.com/t/installing-for-arm64-missing-telemetry-agent/32253)
**Author:** [@Tobias\_Wilson](https://forums.percona.com/u/Tobias_Wilson)\ **Replies:** 11\ **Last updated:** [November 12, 2025, 4:29am UTC](https://forums.percona.com/t/installing-for-arm64-missing-telemetry-agent/32253 "2025-11-12T04:29:39Z")
Hi all, I’ve read the announcement about Percona Server for MySQL packages for ARM64 @ Percona Server for MySQL and Percona XtraBackup Now Available for ARM64 and trying to follow the instructions but hitting a wall wit… --- ## [Unable to run util.checkForServerUpgrade()](https://forums.percona.com/t/unable-to-run-util-checkforserverupgrade/38189)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 4\ **Last updated:** [November 12, 2025, 4:21am UTC](https://forums.percona.com/t/unable-to-run-util-checkforserverupgrade/38189 "2025-11-12T04:21:59Z")
Hi, I am trying to run util.checkForServerUpgrade and I get an error that I am using the incorrect syntax. I’m sure its something simple but I am just trying to run the util.checkForServerUpgrade without any options an… --- ## [Rocksdb: Alter table fails silently and drops all data: Global seqno is required, but disabled,](https://forums.percona.com/t/rocksdb-alter-table-fails-silently-and-drops-all-data-global-seqno-is-required-but-disabled/27038)
**Author:** [@peterdk](https://forums.percona.com/u/peterdk)\ **Replies:** 6\ **Last updated:** [November 12, 2025, 3:48am UTC](https://forums.percona.com/t/rocksdb-alter-table-fails-silently-and-drops-all-data-global-seqno-is-required-but-disabled/27038 "2025-11-12T03:48:37Z")
I did alter a fairly small rocksdb table yesterday, and it reported that everything went ok. So I was happy. Today I did another table which was a bit larger, and added a field there as well. It reported that all went f… --- ## [Can't get SELECT WHERE IN (huge list of items) to use index, does table scan](https://forums.percona.com/t/cant-get-select-where-in-huge-list-of-items-to-use-index-does-table-scan/27418)
**Author:** [@peterdk](https://forums.percona.com/u/peterdk)\ **Replies:** 4\ **Last updated:** [November 12, 2025, 3:41am UTC](https://forums.percona.com/t/cant-get-select-where-in-huge-list-of-items-to-use-index-does-table-scan/27418 "2025-11-12T03:41:42Z")
So I recently reimported my ROCKSDB database from a backup, with a fresh bulk\_load and all inserted in primary key order. Took some time, but now it’s fresh and shiny ;). However, without having changed anything in the … --- ## [Mysqld got signal 11 right after “Initiating SST cancellation” — race in wsrep 26.1.4.3?](https://forums.percona.com/t/mysqld-got-signal-11-right-after-initiating-sst-cancellation-race-in-wsrep-26-1-4-3/39689)
**Author:** [@Aleksander\_Lutsenko](https://forums.percona.com/u/Aleksander_Lutsenko)\ **Replies:** 7\ **Last updated:** [November 6, 2025, 3:46pm UTC](https://forums.percona.com/t/mysqld-got-signal-11-right-after-initiating-sst-cancellation-race-in-wsrep-26-1-4-3/39689 "2025-11-06T15:46:27Z")
We’re hitting intermittent crashes on one node when an SST cancellation is triggered: \[WSREP\] Initiating SST cancellation mysqld got signal 11 (Thread pointer: 0x0) Crashes occur intermittently during or shortly aft… --- ## [Percona Server 8.4-lts memory leakage](https://forums.percona.com/t/percona-server-8-4-lts-memory-leakage/39538)
**Author:** [@burlutskiy](https://forums.percona.com/u/burlutskiy)\ **Replies:** 6\ **Last updated:** [November 5, 2025, 1:34pm UTC](https://forums.percona.com/t/percona-server-8-4-lts-memory-leakage/39538 "2025-11-05T13:34:54Z")
Hello everyone! I decided to install a new MySQL 8.4 server for our new projects… Specifically, a Percona server, in group replication mode, not an extradb cluster… I discovered that when idle, the server constantly c… --- ## [Automated way to get notified on Percona Downloads](https://forums.percona.com/t/automated-way-to-get-notified-on-percona-downloads/39682)
**Author:** [@Chanakya](https://forums.percona.com/u/Chanakya)\ **Replies:** 1\ **Last updated:** [November 5, 2025, 10:43am UTC](https://forums.percona.com/t/automated-way-to-get-notified-on-percona-downloads/39682 "2025-11-05T10:43:55Z")
Hi, I am trying to build a small utility to automatically download Percona Server 8.4.x binaries as soon as Percona Releases it. Is there a way around to interpret the exact version (specifically linux generic 2.28 and… --- ## [Unable to join node to Percona XtraDB Cluster 8.4.6](https://forums.percona.com/t/unable-to-join-node-to-percona-xtradb-cluster-8-4-6/39665)
**Author:** [@pkm2112](https://forums.percona.com/u/pkm2112)\ **Replies:** 2\ **Last updated:** [November 1, 2025, 3:56am UTC](https://forums.percona.com/t/unable-to-join-node-to-percona-xtradb-cluster-8-4-6/39665 "2025-11-01T03:56:14Z")
Hello Experts Need your help My cluster version is 8.4.6, ssl is not enabled, firewall is not running , selinux is switched to permissive mode ============= begin node 1 Config file ==============================… --- ## [Replication issue between our 2 servers](https://forums.percona.com/t/replication-issue-between-our-2-servers/39311)
**Author:** [@Govind\_Premakumar](https://forums.percona.com/u/Govind_Premakumar)\ **Replies:** 11\ **Last updated:** [October 31, 2025, 2:23pm UTC](https://forums.percona.com/t/replication-issue-between-our-2-servers/39311 "2025-10-31T14:23:20Z")
We recently upgraded our server MySQL version from 8.0.20-11 to version 8.4.5-5 for Linux on x86\_64 (Percona Server (GPL), Release 5, Revision 3d3abca6). We imported the MySQL dump, transferring it to the DR DB servers,… --- ## [Delay in user synchronization across Percona XtraDB Cluster nodes](https://forums.percona.com/t/delay-in-user-synchronization-across-percona-xtradb-cluster-nodes/39626)
**Author:** [@TAndreotti](https://forums.percona.com/u/TAndreotti)\ **Replies:** 8\ **Last updated:** [October 29, 2025, 5:05pm UTC](https://forums.percona.com/t/delay-in-user-synchronization-across-percona-xtradb-cluster-nodes/39626 "2025-10-29T17:05:46Z")
Hi everyone, I’m currently managing a Percona XtraDB Cluster (PXC) environment with the following setup: Cluster version: 8.0.43-34.1 - Percona XtraDB Cluster (GPL), Release rel34, Revision 0682ba7, WSREP version 26.… --- ## [Tarball not found for mysql XtraDB cluster 8.4.6](https://forums.percona.com/t/tarball-not-found-for-mysql-xtradb-cluster-8-4-6/39631)
**Author:** [@pkm2112](https://forums.percona.com/u/pkm2112)\ **Replies:** 2\ **Last updated:** [October 28, 2025, 8:28am UTC](https://forums.percona.com/t/tarball-not-found-for-mysql-xtradb-cluster-8-4-6/39631 "2025-10-28T08:28:06Z")
Hello I checked https://www.percona.com/downloads I couldnt find tarball for mysql XtraDB Cluster 8.4.6 Rgds PKM --- ## [Percona xtraDB Cluster 8.x Setup With proxysql and keepalived as HA](https://forums.percona.com/t/percona-xtradb-cluster-8-x-setup-with-proxysql-and-keepalived-as-ha/37154)
**Author:** [@Faisal\_Hassan](https://forums.percona.com/u/Faisal_Hassan)\ **Replies:** 10\ **Last updated:** [October 22, 2025, 4:16pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-8-x-setup-with-proxysql-and-keepalived-as-ha/37154 "2025-10-22T16:16:18Z")
Hi , We are setting up a Percona XtraDB Cluster with three nodes, each running on an AWS EC2 instance. To handle query routing, we plan to use ProxySQL, also deployed on an EC2 instance. However, in this setup, ProxySQ… --- ## [Participate in State of MariaDB Survey](https://forums.percona.com/t/participate-in-state-of-mariadb-survey/39589)
**Author:** [@Robert\_Silen](https://forums.percona.com/u/Robert_Silen)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 9:03am UTC](https://forums.percona.com/t/participate-in-state-of-mariadb-survey/39589 "2025-10-21T09:03:06Z")
Are you running MariaDB? MariaDB Foundation is launching the first ever annual State of MariaDB Survey and we want your input—whether you’re running MariaDB in production, learning it for a project, or dealing with a set… --- ## [Replication not sync \[MY-010956\]](https://forums.percona.com/t/replication-not-sync-my-010956/39577)
**Author:** [@Hany\_Widodo](https://forums.percona.com/u/Hany_Widodo)\ **Replies:** 3\ **Last updated:** [October 20, 2025, 3:38pm UTC](https://forums.percona.com/t/replication-not-sync-my-010956/39577 "2025-10-20T15:38:53Z")
\[Warning\] \[MY-010956\] \[Server\] Invalid replication timestamps: original commit timestamp is more recent than the immediate commit timestamp. Slave status : no error Slave\_IO\_Running: Yes Slave\_SQL\_Running: Yes Chronol… --- ## [Unable to restore backup via xtrabackup](https://forums.percona.com/t/unable-to-restore-backup-via-xtrabackup/39460)
**Author:** [@cosmicOpie](https://forums.percona.com/u/cosmicOpie)\ **Replies:** 1\ **Last updated:** [October 17, 2025, 3:58am UTC](https://forums.percona.com/t/unable-to-restore-backup-via-xtrabackup/39460 "2025-10-17T03:58:07Z")
I’m trying to restore one of my incremental backup. I applied 4 incremental to my base, but during the 5th one it crashed. ata.ibd2025-09-26T17:24:30.085192-00:00 0 \[Note\] \[MY-011825\] \[Xtrabackup\] page size for /xbacku… --- ## [How to add Topology in PMM for MySQL servers](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424)
**Author:** [@tee952](https://forums.percona.com/u/tee952)\ **Replies:** 14\ **Last updated:** [October 16, 2025, 9:27pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424 "2025-10-16T21:27:17Z")
Hi All, Do anyone know if we can add topology in PMM for MySQL/MariaDB servers, if so can you let me know how it can be done. Example: If we have Primary-Secondary setup, then I need to see a Pictorial form which serve… --- ## [Best Practices for Handling Prepared Statements in a Proxied Percona XtraDB Cluster Setup](https://forums.percona.com/t/best-practices-for-handling-prepared-statements-in-a-proxied-percona-xtradb-cluster-setup/39559)
**Author:** [@Neil\_Billett](https://forums.percona.com/u/Neil_Billett)\ **Replies:** 2\ **Last updated:** [October 16, 2025, 12:54pm UTC](https://forums.percona.com/t/best-practices-for-handling-prepared-statements-in-a-proxied-percona-xtradb-cluster-setup/39559 "2025-10-16T12:54:16Z")
Hi there, We’re running a Java application that connects to a Percona XtraDB Cluster (v8). The DB cluster is proxied by HAProxy which is configured to keep connections on the same backend node as much as possible - we d… --- ## [Enforcing mTLS with ProxySQL](https://forums.percona.com/t/enforcing-mtls-with-proxysql/39536)
**Author:** [@vis21](https://forums.percona.com/u/vis21)\ **Replies:** 1\ **Last updated:** [October 15, 2025, 6:35am UTC](https://forums.percona.com/t/enforcing-mtls-with-proxysql/39536 "2025-10-15T06:35:46Z")
Description: Attempting to enforce mTLS using ProxySQL. In values, I have tls enabled: tls: enabled: true I’ve set the interfaces ssl\_verify\_client and ssl\_required as well as have\_ssl. interfaces="0.0.0.0:… --- ## [Defining rules for audit log filter component (v8.0 / 8.4)](https://forums.percona.com/t/defining-rules-for-audit-log-filter-component-v8-0-8-4/36276)
**Author:** [@audit\_4852](https://forums.percona.com/u/audit_4852)\ **Replies:** 3\ **Last updated:** [October 14, 2025, 11:41am UTC](https://forums.percona.com/t/defining-rules-for-audit-log-filter-component-v8-0-8-4/36276 "2025-10-14T11:41:12Z")
Dear Percona community, I am struggling to configure the rules for the audit log filter component. I would like to filter events in a way that only certain sql commands are logged. This is what I have so far: “filter”… --- ## [Audit\_log\_filter.file parameter - Cannot change default location](https://forums.percona.com/t/audit-log-filter-file-parameter-cannot-change-default-location/39541)
**Author:** [@j\_a\_y](https://forums.percona.com/u/j_a_y)\ **Replies:** 2\ **Last updated:** [October 13, 2025, 1:50pm UTC](https://forums.percona.com/t/audit-log-filter-file-parameter-cannot-change-default-location/39541 "2025-10-13T13:50:35Z")
(Note: Using Percona MySQL 8.4.6-6 on RHEL 9) When using the new audit log filter component by default the my.cnf file contains the following configuration: audit\_log\_filter.file=audit\_filter.log With the older audit … --- ## [Write audit\_log\_filter definitons](https://forums.percona.com/t/write-audit-log-filter-definitons/37704)
**Author:** [@dba\_S4dscjz](https://forums.percona.com/u/dba_S4dscjz)\ **Replies:** 5\ **Last updated:** [October 13, 2025, 12:09pm UTC](https://forums.percona.com/t/write-audit-log-filter-definitons/37704 "2025-10-13T12:09:30Z")
Hi dear community, We currently test the Percona Audit Log Filter component and we have some difficulties to find the right filter to match our needs. Our test environment runs last Percona Server for MySQL 8.4.4-4 and… --- ## [DDL just for Percona](https://forums.percona.com/t/ddl-just-for-percona/39512)
**Author:** [@Phillip85](https://forums.percona.com/u/Phillip85)\ **Replies:** 3\ **Last updated:** [October 9, 2025, 3:44pm UTC](https://forums.percona.com/t/ddl-just-for-percona/39512 "2025-10-09T15:44:48Z")
Hi, is it possible to Comment a Part of a DDL to just get used on percona server? I want to use the Percona exclusive compressed column in a Projekt which needs to be compatible to mysql / mariadb too. When i try it l… --- ## [Updates break cluster (clustercheck)](https://forums.percona.com/t/updates-break-cluster-clustercheck/39514)
**Author:** [@dcbrown73](https://forums.percona.com/u/dcbrown73)\ **Replies:** 1\ **Last updated:** [October 8, 2025, 6:09pm UTC](https://forums.percona.com/t/updates-break-cluster-clustercheck/39514 "2025-10-08T18:09:03Z")
Hi, We use NinjaOne to apply updates nightly. Every time an update for XtraDB comes out, it overwrites our clustercheck file which holds the credentials for checking the cluster. This is a major problem as it breaks … --- ## [Pt-deadlock stopped working with 'Use of uninitialized value $query\_text'](https://forums.percona.com/t/pt-deadlock-stopped-working-with-use-of-uninitialized-value-query-text/38094)
**Author:** [@poltpolt](https://forums.percona.com/u/poltpolt)\ **Replies:** 6\ **Last updated:** [October 8, 2025, 12:14pm UTC](https://forums.percona.com/t/pt-deadlock-stopped-working-with-use-of-uninitialized-value-query-text/38094 "2025-10-08T12:14:24Z")
Suddenly (possibly after upgrade) my percone-deadlock logger returns Error getting SHOW ENGINE INNODB STATUS: Use of uninitialized value $query\_text in substitution (s///) at /usr/bin/pt-deadlock-logger line 4949. per… --- ## [PMM Backups fail, says latest XtraBackup 8.4.0-4 is incompatible with XtraDB cluster 8.4.5-5.1](https://forums.percona.com/t/pmm-backups-fail-says-latest-xtrabackup-8-4-0-4-is-incompatible-with-xtradb-cluster-8-4-5-5-1/39478)
**Author:** [@Jay\_McNab](https://forums.percona.com/u/Jay_McNab)\ **Replies:** 4\ **Last updated:** [October 3, 2025, 3:02am UTC](https://forums.percona.com/t/pmm-backups-fail-says-latest-xtrabackup-8-4-0-4-is-incompatible-with-xtradb-cluster-8-4-5-5-1/39478 "2025-10-03T03:02:55Z")
Here is the error I get when trying to perform a backup from PMM Console: xtrabackup version “8.4.0-4” is not compatible with mysql version “8.4.5-5.1”: incompatible xtrabackup WTH? If I installed the latest production… --- ## [Order of the tables - suggestion for performance improvement](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487)
**Author:** [@edhunter](https://forums.percona.com/u/edhunter)\ **Replies:** 2\ **Last updated:** [October 2, 2025, 8:25pm UTC](https://forums.percona.com/t/order-of-the-tables-suggestion-for-performance-improvement/39487 "2025-10-02T20:25:12Z")
My specific scenario is: 20TB mysql instance with about 400 innodb tables. From that many tables there are only a few very large (\>2TB). The tables sizes are varaying 1-100G. The time it takes to do full xtrabackup is s… --- ## [PAM Authentication plugin 'dialog'](https://forums.percona.com/t/pam-authentication-plugin-dialog/18340)
**Author:** [@valera.antropow](https://forums.percona.com/u/valera.antropow)\ **Replies:** 1\ **Last updated:** [September 25, 2025, 10:25am UTC](https://forums.percona.com/t/pam-authentication-plugin-dialog/18340 "2025-09-25T10:25:31Z")
Good afternoon everyone. We are using MYSQL Percona 8 with PAM+SSSD+AD authentication. Faced with the fact that authentication works well only on the machine where the server is installed, from the terminal console. Whe… [Previous page](https://forums.percona.com/c/mysql-mariadb/36.md?page=5) [Next page](https://forums.percona.com/c/mysql-mariadb/36.md?page=7)