MariaDB Future Blog Articles

Flipping Query Execution Plans

• 5.7
• ANALYZE + persistent statistics + historgrams (LOCKing 5.7 - 8.4)
  • after load
  • regular mysql-check –analyze
• Index drop
• fake data
• Hints
• Datenmodell

https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html https://dev.mysql.com/doc/refman/8.4/en/cost-model.html https://dev.mysql.com/doc/refman/8.4/en/controlling-optimizer.html https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html https://dev.mysql.com/doc/refman/8.4/en/index-hints.html https://dev.mysql.com/doc/refman/8.4/en/cost-model.html https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html

MariaDB downground

$ dpkg -l | grep maria -i ii libdbd-mysql-perl:amd64 4.050-5ubuntu0.22.04.1 amd64 Perl5 database interface to the MariaDB/MySQL database ii libmariadb3:amd64 1:10.11.12+mariaubu2204 amd64 MariaDB database client library ii mariadb-client 1:10.11.12+mariaubu2204 amd64 MariaDB database client binaries ii mariadb-client-core 1:10.11.12+mariaubu2204 amd64 MariaDB database core client binaries ii mariadb-common 1:10.11.12+mariaubu2204 all MariaDB database common files (e.g. /etc/mysql/mariadb.conf.d/) ii mariadb-server 1:10.11.12+mariaubu2204 amd64 MariaDB database server binaries ii mariadb-server-core 1:10.11.12+mariaubu2204 amd64 MariaDB database core server files ii mysql-common 1:10.11.12+maria~ubu2204 all MariaDB client common configuration files package (e.g. /etc/mysql/my.cnf)

$ apt-cache show mariadb* | grep -B2 -e ‘Version: 1:10.11.11+maria~ubu22’

$ apt install libmariadb3:amd64=1:10.11.11+mariaubu2204 mariadb-client=1:10.11.11+mariaubu2204 mariadb-client-core=1:10.11.11+mariaubu2204 mariadb-common=1:10.11.11+mariaubu2204 mariadb-server=1:10.11.11+mariaubu2204 mariadb-server-core=1:10.11.11+mariaubu2204 mysql-common=1:10.11.11+maria~ubu2204