暂无图片
如何讲计数器清零?flush status没起到作用
我来答
分享
暂无图片 匿名用户
如何讲计数器清零?flush status没起到作用

mysql> show status like 'innodb_row_lock%';
+-------------------------------+--------+
| Variable_name | Value |
+-------------------------------+--------+
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 101613 |
| Innodb_row_lock_time_avg | 50806 |
| Innodb_row_lock_time_max | 51220 |
| Innodb_row_lock_waits | 2 |
+-------------------------------+--------+
5 rows in set (0.00 sec)

mysql> flush status;
Query OK, 0 rows affected (0.01 sec)

mysql> show status like 'innodb_row_lock%';
+-------------------------------+--------+
| Variable_name | Value |
+-------------------------------+--------+
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 101613 |
| Innodb_row_lock_time_avg | 50806 |
| Innodb_row_lock_time_max | 51220 |
| Innodb_row_lock_waits | 2 |
+-------------------------------+--------+

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
lianR

可以试试:ALTER  TABLE  tablename  AUTO_INCREMENT  =  1;

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏