1.确认已经安装好了mysql 如果没有 请看我上一个文章
2.修改配置文件
vi /etc/my.cnf
[mysqld]
slow_query_log=1
long-query-time=2
log-slow-queries=/var/log/mariadb/mariadb-slow.log
3.重启 mysql
systemctl restart mariadb
4.打开目录 /var/log/mariadb/mariadb-slow.log
可以 看到日志记录了 每个慢查询的sql语句
# Time: 220512 9:45:23
# User@Host: root[root] @ [120.244.231.12]
# Thread_id: 3 Schema: orderwater_prod QC_hit: No
# Query_time: 35.002074 Lock_time: 0.000295 Rows_sent: 27 Rows_examined: 21292314
SET timestamp=1652319923;
SELECT
* from table