MySQL
努力xxx
这个作者很懒,什么都没留下…
展开
-
开启MySQL慢查询
1.查看当前MySQL慢查询配置信息mysql> show variables like '%slow%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | log_slow_queries | OFF | #OFF关闭,ON开启| slow_launch_time | 2 | #超过2秒即为慢查询+------------原创 2022-01-04 11:59:29 · 917 阅读 · 0 评论 -
如何查看MySQL慢查询语句
1. 查看MySQL运行了哪些语句mysql> show processlist;+------+-----------------+-----------+------+---------+--------+------------------------+------------------+| Id | User | Host | db | Command | Time | State | Info原创 2021-05-31 12:13:04 · 1064 阅读 · 0 评论 -
Mysql开启和查看慢查询
一、查看慢查询的各种信息1.1 查看是否开启慢查询mysql> show variables like 'slow_query%';+---------------------+---------------------------------------+| Variable_name | Value |+---------------------+---------------------------------原创 2021-05-31 12:03:02 · 215 阅读 · 0 评论