Guest User

Untitled

a guest
Oct 24th, 2017
419
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
  2. +-----------------------+-----------------+
  3. | @@GLOBAL.tx_isolation | @@tx_isolation |
  4. +-----------------------+-----------------+
  5. | REPEATABLE-READ | REPEATABLE-READ |
  6. +-----------------------+-----------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> set autocommit = 0;
  10. Query OK, 0 rows affected (0.00 sec)
  11.  
  12. mysql> SELECT @@autocommit;
  13. +--------------+
  14. | @@autocommit |
  15. +--------------+
  16. | 0 |
  17. +--------------+
  18. 1 row in set (0.00 sec)
  19.  
  20. mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
  21. Query OK, 0 rows affected (0.00 sec)
  22.  
  23. mysql> START TRANSACTION;
  24. Query OK, 0 rows affected (0.00 sec)
  25.  
  26. mysql> delete from 売上明細情報テーブル where 年月 = 201709;
  27. Query OK, 8345 rows affected (2.18 sec)
  28.  
  29. mysql> use information_schema;
  30. Database changed
  31. mysql> SELECT trx_rows_locked FROM INNODB_TRX;
  32. +-----------------+
  33. | trx_rows_locked |
  34. +-----------------+
  35. | 16690 |
  36. +-----------------+
  37. 1 row in set (0.00 sec)
  38.  
  39. mysql> set autocommit = 0;
  40. Query OK, 0 rows affected (0.00 sec)
  41.  
  42. mysql> SELECT @@autocommit;
  43. +--------------+
  44. | @@autocommit |
  45. +--------------+
  46. | 0 |
  47. +--------------+
  48. 1 row in set (0.00 sec)
  49.  
  50. mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
  51. Query OK, 0 rows affected (0.00 sec)
  52.  
  53. mysql> START TRANSACTION;
  54. Query OK, 0 rows affected (0.00 sec)
  55.  
  56. mysql> delete from 売上明細情報テーブル where 年月 = 201708;
  57. ロック待ち★
Add Comment
Please, Sign In to add comment