MySQL – Status for Insert Per Secound 計算每秒寫入次數

可以利用 MySQL 例如要取得多少個 insert/update/delete per second 可以用在 global status 裡面找到:

show global status like "com_insert";

當然也可以用 Com_delete, Com_update, Com_select …等等下去找

詳見:MySQL Server Status Variables

Posted in DB

Leave a Reply

Your email address will not be published.