Question : I’m using MariaDB 10.5 on Centos7 with 4G RAM and 2 CPU. Here’s my.cnf configuration [mysqld] log-error=/var/lib/mysql/mysql-3.kannel.com.err max_allowed_packet=1G […]
Tag: mariadb
WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)
Question : We are running a Mariadb galera cluster with 3 data nodes. Recently one of them crashed and I […]
How do I turn off MariaDB GTID to revert back to binlog replication?
Question : We have found concerns with GTID on MariaDB related to our multi-tenant MyISAM databases. It sounds like there […]
InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations
Question : MariaDB Version: ‘10.5.13-9 I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to […]
Is it impossible to force MariaDB users to SSL?
Question : First of all, my english is really bad, so sorry for my english mistakes. I have a MariaDB […]
Prevent replication of ALTER commands
Question : I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like […]
MariaDB master to master replication auto increment is not sequential
Question : I have two master to master MariaDB server replication with the below settings: server A with 192.168.1.100: —————————— […]
Speeding up a simple select query on Mariadb
Question : I have a 100k rows table with the following structure: +———-+——————+——+—–+———+—————-+ | Field | Type | Null | […]
can’t set batched_key_access=on in optimizer_switch on mariadb 5.5
Question : I am switching my application from a Mysql5.6 to a Mariadb5.5. I am support to add batched_key_access=on in […]
Table metadata lock MariaDB
Question : I’m having serious problems in a DB, where a “Waiting for table level lock” box is loitering and […]