set global innodb_status_output = ON;
set global innodb_status_output_locks = ON;mysql> show variables like "%innodb_status%";
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| innodb_status_output | ON |
| innodb_status_output_locks | ON |
+----------------------------+-------+
'MySQL' 카테고리의 다른 글
| ULID, UUID와 MySQL B-tree index (0) | 2022.02.25 |
|---|---|
| MySQL InnoDB architecture (0) | 2021.09.05 |
| 페이지 통합과 분할 (0) | 2021.07.12 |
| Gap lock & Next key lock (0) | 2021.07.08 |
| Lock mechanism in MySQL Internal (0) | 2021.07.05 |