MySQL写压力性能监控与调优
mysql> show global status like 'i%rows%';+
| Variable_name | Value |
+
| Innodb_rows_deleted| 0 |
| Innodb_rows_inserted | 145 |
| Innodb_rows_read | 233 |
| Innodb_rows_updated| 5 |
+
4 rows in set (0.01 sec)
mysql> show global status like '%commit%';
+
| Variable_name| Value |
+
| Com_commit | 0 |
| Com_xa_commit| 0 |
| Handler_commit | 16 |
+
3 rows in set (0.01 sec)
mysql> show global status like '%rollback%';
+
| Variable_name | Value |
+
| Com_rollback | 0 |
| Com_rollback_to_savepoint| 0 |
| Com_xa_rollback | 0 |
| Handler_rollback | 0 |
| Handler_savepoint_rollback | 0 |
+
5 rows in set (0.01 sec)
页:
[1]