mysql 状态,链接多少次/次数大的话需要增加配置了

mysql> show status like 'connections';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| Connections   | 6     |

+---------------+-------+

1 row in set (0.00 sec)

 查询服务器启动了多长时间:

mysql> show status like 'Uptime';

+---------------+---------+

| Variable_name | Value   |

+---------------+---------+

| Uptime        | 1119745 |

+---------------+---------+

1 row in set (0.00 sec)

 //慢查询的次数

mysql> show status like 'Slow_queries%';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| Slow_queries  | 0     |

+---------------+-------+

1 row in set (0.01 sec)

 

//索引使用次数——没有建索引

mysql> show status like 'hander_read%';

Empty set (0.00 sec)

 

posted @ 2020-03-31 08:40  yahn~  阅读(179)  评论(1编辑  收藏  举报