Question : have an issue with MariaDB 10.2.12 running in aws rds (single master, no slave) when I run prepared […]
Tag: mariadb-10.2
How to clear the InnoDB redo log before starting mysqld for crash recovery
Question : System: Windows Server 2012 R2, MariaDB 10.2.8 We are currently trying to recover from a quasi-crash (it was […]
Allow only unique combination of values for a composite primary key
Question : I created the following table called books: CREATE TABLE IF NOT EXISTS `books` ( `id` BIGINT UNSIGNED NOT […]
MariaDB 10.2.22 Galera Cluster Using Bad Indexes After Analyze
Question : I’m using Drupal on a MariaDB Galera 10.2.22 3 node cluster and I’m having some problems with one […]
Connection aborts is happening in MariaDB 10.2 but not in 10.1 even with log_warnings level set to 2
Question : I am noticing different behavior in mariadb 10.1 & 10.2 reg.connection aborts. I noticed connection getting aborted after […]
How to clear the InnoDB redo log before starting mysqld for crash recovery
Question : System: Windows Server 2012 R2, MariaDB 10.2.8 We are currently trying to recover from a quasi-crash (it was […]
table_open_cache increase issue – MariaDB 10.2
Question : I’m trying to increase to 9000 but MariaDB sets it at 4895 automatically. Here is my simple config […]
perform non locking select when updating another table
Question : We need to perform the following (periodic) query in mariadb: update A set status=’INACTIVE’ where status=’ACTIVE’ and a.b_id […]
MariaDB optimisation [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Which way should be selected when move from mysql to mariadb? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]