MySQL状态变量 Handler_delete和Com_delete关系（转老金）

原文http://www.mysqlops.com/2011/02/10/mysql%E7%8A%B6%E6%80%81%E5%8F%98%E9%87%8F-handler_delete%E5%92%8Ccom_delete%E6%9C%89%E4%BB%80%E4%B9%88%E5%85%B3%E7%B3%BB%EF%BC%9F.html

 

 

这两个都是MYSQL,SHOW STATUS里的一个状态变量.
根据MYSQL官方文档解释:
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命令的执行次数.
<!–more–> 
下面我们来测试一下:

(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的结果来看,都与官文描述是相符的.