Linux学习笔记：MySQL日常运维查询状态

这个语句主要用于查询耗时太长的SQL语句
[root@vmtest ~]# mysql -uroot -p -h 127.0.0.1 -P 3308 -e 'show full processlist;'
+-----+------+-----------------+------+---------+------+-------+-----------------------+
| Id  | User | Host            | db   | Command | Time | State | Info                  |
+-----+------+-----------------+------+---------+------+-------+-----------------------+
| 145 | root | 127.0.0.1:35471 | NULL | Query   |    0 | NULL  | show full processlist |
+-----+------+-----------------+------+---------+------+-------+-----------------------+

这个语句主要用于查看全局实时状态

mysql -uroot -pjet-speed -h 127.0.0.1 -P 3308 -e 'show global status;'