Home
>
ステータス系の値からロック状態を確認する方法(途中)
ステータス系の値からロック状態を確認する方法(途中)
[test]> show global status like '%lock%';
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Com_lock_tables | 0 |
| Com_unlock_tables | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 7243 |
| Key_blocks_used | 7248 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Table_locks_immediate | 17 |
| Table_locks_waited | 0 |
+-------------------------------+-------+
14 rows in set (0.00 sec)
Home
>
ステータス系の値からロック状態を確認する方法(途中)