0、查看系统信息
查看数据库有哪些登录用户
mysql> select user,host from mysql.user;
+----------+-----------+
| user | host |
+----------+-----------+
| root | % |
| root | localhost |
+----------+-----------+
4 rows in set (0.00 sec)
1、查看服务器运行状态
服务器运行过程中,MySQL可能出现连接不上的情况,此时就需要查询mysql的状态,用到如下命令:
查看最大连接数
mysql> show variables like '%max_connections%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 9999 |
+-----------------+-------+
查看线程信息
#查看线程信息
mysql> show global status like 'Thread%';
+-------------------+----------+
| Variable_name | Value |
+-------------------+----------+
| Threads_cached | 0 |
| Threads_connected | 687 |
| Threads_created | 51714161 |
| Threads_running | 1 |
+-------------------+----------+
4 rows in set (0.00 sec)
各字段分别代表的含义:
Threads_cached:线程缓存内的线程数;
Threads_connected:当前打开的连接数;
Threads_created:为处理连接而创建的线程数。 如果Threads_created很大,可能希望增加thread_cache_size值。 缓存未命中率可以计算为Threads_created / Connections;
Threads_running:当前未挂起的连接数(即激活的连接数),一般远低于Threads_connected的值;