docker-install-mariadb-with-slow-query

docker-install-mariadb-with-slow-query.txt

# Docker image mariadb 10.2.24 (https://hub.docker.com/_/mariadb)
~$ docker run --name mariadb -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 -d docker.io/library/mariadb:10.2.24 --slow-query-log=TRUE --log-output=TABLE

# SQL check variables
SHOW VARIABLES LIKE 'slow_query%';
SHOW VARIABLES LIKE 'log_output%';
SHOW VARIABLES LIKE 'long_%';
SELECT benchmark(100000000, md5('running query'));
SELECT * FROM mysql.slow_log;