Sysadmin Garden of Eden Docs

Version 1337.42.0

Cheat Sheet

Re-Create the debian-sys-maint User

1
mysqldump --complete-insert --extended-insert=0 -u root -p mysql | grep 'debian-sys-maint'

Run a SQL “script” on init / startup

1
init_file = /etc/mysql/init.sql

The /etc/mysql/init.sql file can contain “any” SQL queries.

Example to enable / install the MariaDB Query Response Time Plugin plugin:

1
2
3
4
INSTALL SONAME 'query_response_time';

SET GLOBAL query_response_time_stats = 1;
SET GLOBAL query_response_time_flush = 1;

NOTE

There are other ways to install the plugin, but to “initially” flush the plugin’s data the SET GLOBAL query_response_time_ can be used.

Last updated on 21 Feb 2020
Published on 16 Jun 2019
Edit on GitHub