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)

 

原文地址:https://www.cnblogs.com/ayanboke/p/12602876.html