ITPub博客

首页 > 应用开发 > IT综合 > Handler_delete和Com_delete有什么关系

Handler_delete和Com_delete有什么关系

原创 IT综合 作者:Steven1981 时间:2009-11-09 16:44:00 0 删除 编辑
今天有人问, Handler_delete和Com_delete有什么关系?
Handler_delete:
com_delete:[@more@]

这两个都是MYSQL,SHOW STATUS里的一个状态变量.

根据MYSQL 5.0 官方文档解释:
Handler_delete:
The number of times that rows have been deleted from tables.
DELETED行数.
com_delete:
The Com_xxx statement counter variables indicate the number of times each xxx statement has been executed.
DELETE命令的执行次数.

下面我们来测试一下:

(root@sns-ptst4:)[test]> select * from t1;
+------+-------+
| name | n1 |
+------+-------+
| aaa | NULL |
| bbb | NULL |
| ccc | NULL |
| aaa | aaaaa |
+------+-------+
4 rows in set (0.00 sec)

(root@sns-ptst4:)[test]> show global status like '%delete%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Handler_delete | 0 |
| Innodb_rows_deleted | 0 |
+---------------------+-------+
4 rows in set (0.00 sec)

(root@sns-ptst4:)[test]> delete from t1;
Query OK, 4 rows affected (0.00 sec)

(root@sns-ptst4:)[test]> commit;
Query OK, 0 rows affected (0.00 sec)

(root@sns-ptst4:)[test]> show global status like '%delete%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| Com_delete | 1 |
| Com_delete_multi | 0 |
| Handler_delete | 4 |
| Innodb_rows_deleted | 4 |
+---------------------+-------+
4 rows in set (0.00 sec)

从两次SHOW STATUS的结果来看,官方文档的解释是正确的!

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/703656/viewspace-1028575/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    127
  • 访问量
    855001