MariaDB slow queries

https://mariadb.com/kb/en/slow-query-log/

/etc/mysql/mariadb.conf.d/50-server.cnf
/var/log/mysql/mariadb-slow.log
systemctl restart mariadb && systemctl status mariadb

/etc/mysql/mariadb.conf.d/50-server.cnf
#Enable the slow query log to see queries with especially long duration
slow_query_log_file	= /var/log/mysql/mariadb-slow.log
long_query_time = 10
log_slow_rate_limit	= 1000
log_slow_verbosity	= query_plan
log-queries-not-using-indexes

Nagios

/usr/lib/nagios/plugins/check_mysql
Uptime: 1133648  Threads: 14  Questions: 159793336  Slow queries: 1718223  Opens: 191  Flush tables: 1  Open tables: 184  Queries per second avg: 140.954|Connections=2757900c;;; Open_files=57;;; Open_tables=184;;; Qcache_free_memory=2423328;;; Qcache_hits=38449185c;;; Qcache_inserts=106590640c;;; Qcache_lowmem_prunes=105448285c;;; Qcache_not_cached=342783c;;; Qcache_queries_in_cache=3589;;; Queries=159793336c;;; Questions=159793336c;;; Table_locks_waited=0c;;; Threads_connected=1;;; Threads_running=6;;; Uptime=1133648c;;;

Related

• AWS RDS query logging, log_statement and log_min_duration_statement
• 504 Gateway Time-out
• pt-query-digest
• mysqldump --single-transaction
• PostgreSQL: log_duration
• mariadb-dumpslow
• mysqldumpslow
• systemctl restart php* && systemctl status php*
• SHOW PROCESSLIST;
• MySQL Workbench
• metricbeat modules list

See also

• /var/log/mysql/error.log, mariadbcheck, MariaDB binary log