You are here

MySQL and MariaDB variables inflation

MySQL is well known and widely spread because of its philosophy of Keep it Simple (KISS).

We recently had the discussion that with newer releases also MySQL and MariaDB relational databases becomes more and more complicated.

One indication for this trend is the number of MySQL server system variables and status variables.

In the following tables and graphs we compare the different releases since MySQL version 4.0:

mysql> SHOW GLOBAL VARIABLES;
mysql> SHOW GLOBAL VARIABLES LIKE 'innodb%';
mysql> SHOW GLOBAL STATUS;
mysql> SHOW GLOBAL STATUS LIKE 'innodb%';

VersionSystemIB Sys.StatusIB Stat.
MySQL 4.0.3014322*133**0
MySQL 4.1.2518926*164**0
MySQL 5.0.962393625242
MySQL 5.1.732773629142
MySQL 5.5.513176031247
MySQL 5.6.3143812034151
MySQL 5.7.1549113135351
MySQL 8.0.048812436351

* Use SHOW STATUS instead.
** Use SHOW ENGINE INNODB STATUS\G instead.

inflation_mysql.png

VersionSystemIB Sys.StatusIB Stat.
MariaDB 5.1.443547230144
MariaDB 5.2.103978632446
MariaDB 5.5.4141910341399
MariaDB 10.0.2153714745595
MariaDB 10.1.18***589178517127
MariaDB 10.2.2****58616448196

*** XtraDB 5.6
****InnoDB 5.7.14???

inflation_mariadb.png

Taxonomy upgrade extras: