Difference between revisions of "MariaDB slow queries"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | https://mariadb.com/kb/en/slow-query-log/ | ||
[[/etc/mysql/mariadb.conf.d/50-server.cnf]] | [[/etc/mysql/mariadb.conf.d/50-server.cnf]] | ||
| Line 16: | Line 17: | ||
* <code>[[504 Gateway Time-out]]</code> | * <code>[[504 Gateway Time-out]]</code> | ||
* <code>[[pt-query-digest]]</code> | * <code>[[pt-query-digest]]</code> | ||
| − | |||
* <code>[[mysqldump]] --single-transaction</code> | * <code>[[mysqldump]] --single-transaction</code> | ||
Revision as of 08:29, 11 October 2022
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
#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
Related
- AWS RDS query logging,
log_statement 504 Gateway Time-outpt-query-digestmysqldump --single-transaction
See also
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306,/etc/mysql/
Advertising:
