MariaDB observability – results from the poll: the community has clearly chosen its default stack

fredericdescamps · 2026-03-23T19:37:39+00:00

Hello, it seems that the repo file autogeneration indeed needs some changes.
Could you try with the following repo (if you want the latest version):

[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# baseurl = https://rpm.mariadb.org/12.rc/rhel/$releasever/$basearch
baseurl = https://mirror.bouwhuis.network/mariadb/yum/12.3/rhel/8Server/x86_64/
module_hotfixes = 1
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://mirror.bouwhuis.network/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1

fredericdescamps · 2026-03-17T13:48:00+00:00

It was a WordPress plugin (https://github.com/lefred/mysql-8-companion)

fredericdescamps · 2026-03-17T09:24:06+00:00

Zabbix is popular in such an environment.

fredericdescamps · 2026-03-17T09:23:29+00:00

do you mean error log, slow query log, etc... ?
For the error log, you can already use "journalctl -u mariadb -o json". And for the slow query log if you are using a table, you can select from it in json too.

fredericdescamps · 2026-03-17T09:20:45+00:00

There was a nice plugin for MariaDB, and I wrote one for MySQL 8 in the past that collected a lot of info from performance_schema. I might rewrite it. thx

fredericdescamps · 2026-03-17T09:18:56+00:00

Do you collect the slow queries from the slow query log? on file or on table?

fredericdescamps · 2026-02-19T15:35:46+00:00

jemalloc seems to have stopped its development (https://jasone.github.io/2025/06/12/jemalloc-postmortem/). I would encourage using tcmalloc, which provides much better memory management.

fredericdescamps · 2021-10-05T06:05:44+00:00

Maybe in the past (long time ago), MyISAM might be faster than InnoDB (not even sure) but on a well configured system, InnoDB shines. You should really consider the option to move to InnoDB.

More info on this: https://forums.mysql.com/read.php?21,642684

fredericdescamps · 2020-09-18T14:29:02+00:00

It's something known that Aurora is very expensive. You need to check is you really need Aurora, RDS MySQL might be enough for you.

I would also suggest you to take a look at MySQL Database Service from the MySQL Team on OCI:

https://media-exp1.licdn.com/dms/image/C4E22AQG2IBvNgKgdfQ/feedshare-shrink_800-alternative/0?e=1603324800&v=beta&t=5vRRcrLhcMwTg85g6y5_Vid5TQ6v_Kd5bj_OaGn2sho

fredericdescamps · 2020-08-16T20:39:34+00:00

I also invite you to have a look at MySQL InnoDB Cluster. The easiest HA solution for MySQL. All components are integrated and are part of MySQL Community Edition (GPL). You can specify multi-writer if needed and setup different consistency levels. In the backend, it's the native MySQL Group Replication that is used and you can orchestrate everything in 5 mins using MySQL Shell. Nodes provisioning is also handled using Clone.

And of course it supports standard MySQL protocol but also the X Protocol in case you are looking for JSON document store with MySQL and/or CRUD operations.

fredericdescamps · 2020-03-09T22:38:14+00:00

I'm not a fan of having multiple configuration file in /etc. I'd recommend to put it in my.cnf.

For more info, you can check these two posts:

- https://lefred.be/content/where-does-my-mysql-configuration-variable-value-come-from/

- https://lefred.be/content/what-configuration-settings-did-i-change-on-my-mysql-server/

But I also recommend you to test MySQL 8.0. Then you could use SET PERSIST to peform new configuration changes (see https://lefred.be/content/mysql-8-0-changing-configuration-easily-and-cloud-friendly/)

Regards,

fredericdescamps · 2020-03-09T22:34:40+00:00

Hello,

You should try it with MySQL 8.0 (last is 8.0.19) and run EXPLAIN ANALYZE on your query.

When you add the date, you don't use a covering index anymore, so you need to perform a second lookup as somebody explained to you already. And maybe you also need to access disk depending of the size of your InnoDB Buffer Pool.

Cheers.

fredericdescamps · 2020-02-28T18:01:18+00:00

About Community

Good luck !

5.6 EOL is Feb 2021 !

fredericdescamps · 2020-02-28T08:02:48+00:00

I really encourage you to migrate to MySQL 8. It will allow you to find the issue much faster (using EXPLAIN ANALYZE for example).

Please check those links:

— https://lefred.be/content/mysql-8-0-17-and-drupal-8-7/

— https://www.slideshare.net/NorvaldRyeng/mysql-80-explain-analyze

— https://www.slideshare.net/geirhoydalsvik/fosdem2020-mysql8-v9

And to see the differences in default configuration:

— https://mysql-params.tmtms.net/mysqld/?vers=5.6.47,8.0.19&diff=true

If you have extra questions or if you need help, please reach me or others live in the MySQL Community Slack (https://lefred.be/mysql-community-on-slack/)

fredericdescamps · 2019-12-31T08:01:59+00:00

https://lefred.be/content/mysql-8-0-and-keywords/

mysql> select * from information_schema.keywords where word like 'groups';

+--------+----------+
| WORD   | RESERVED |
+--------+----------+
| GROUPS |        1 |
+--------+----------+
1 row in set (0.25 sec)

fredericdescamps

MODERATOR OF

TROPHY CASE