Difference between revisions of "MariaDB slow queries"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
https://mariadb.com/kb/en/slow-query-log/ | https://mariadb.com/kb/en/slow-query-log/ | ||
<code>[[mysqldump]] --single-transaction</code> | <code>[[mysqldump]] --single-transaction</code> | ||
+ | * [[AWS RDS query logging]] | ||
== See also == | == See also == |
Revision as of 11:12, 22 September 2022
/etc/mysql/mariadb.conf.d/50-server.cnf /var/log/mysql/mariadb-slow.log systemctl restart mariadb && systemctl status mariadb
Related
pt-query-digest
https://mariadb.com/kb/en/slow-query-log/
mysqldump --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: