MySQL狀态變量 Handler_delete和Com_delete有什麼關系？

這兩個都是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–> 

下面我們來測試一下:

+——+——-+

| name | n1    |

| aaa  | NULL  |

| bbb  | NULL  |

| ccc  | NULL  |

| aaa  | aaaaa |

4 rows in set (0.00 sec)

+———————+——-+

| Variable_name       | Value |

| Com_delete          | 0     |

| Com_delete_multi    | 0     |

| Handler_delete      | 0     |

| Innodb_rows_deleted | 0     |

Query OK, 4 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

| Com_delete          | 1     |

| Handler_delete      | 4     |

| Innodb_rows_deleted | 4     |

從兩次SHOW STATUS的結果來看,都與官文描述是相符的.

本文轉自 liang3391 51CTO部落格，原文連結:http://blog.51cto.com/liang3391/824834