Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
- +-----------------------+-----------------+
- | @@GLOBAL.tx_isolation | @@tx_isolation |
- +-----------------------+-----------------+
- | REPEATABLE-READ | REPEATABLE-READ |
- +-----------------------+-----------------+
- 1 row in set (0.00 sec)
- mysql> set autocommit = 0;
- Query OK, 0 rows affected (0.00 sec)
- mysql> SELECT @@autocommit;
- +--------------+
- | @@autocommit |
- +--------------+
- | 0 |
- +--------------+
- 1 row in set (0.00 sec)
- mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
- Query OK, 0 rows affected (0.00 sec)
- mysql> START TRANSACTION;
- Query OK, 0 rows affected (0.00 sec)
- mysql> delete from 売上明細情報テーブル where 年月 = 201709;
- Query OK, 8345 rows affected (2.18 sec)
- mysql> use information_schema;
- Database changed
- mysql> SELECT trx_rows_locked FROM INNODB_TRX;
- +-----------------+
- | trx_rows_locked |
- +-----------------+
- | 16690 |
- +-----------------+
- 1 row in set (0.00 sec)
- mysql> set autocommit = 0;
- Query OK, 0 rows affected (0.00 sec)
- mysql> SELECT @@autocommit;
- +--------------+
- | @@autocommit |
- +--------------+
- | 0 |
- +--------------+
- 1 row in set (0.00 sec)
- mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
- Query OK, 0 rows affected (0.00 sec)
- mysql> START TRANSACTION;
- Query OK, 0 rows affected (0.00 sec)
- mysql> delete from 売上明細情報テーブル where 年月 = 201708;
- ロック待ち★
Add Comment
Please, Sign In to add comment