How can I view real-time locks in innodb when information_schema.innodb_locks is not available?
Asked
Active
Viewed 232 times
1
RolandoMySQLDBA
- 185,223
- 33
- 326
- 536
1 Answers
0
The quick way to see it is to run SHOW ENGINE INNODB STATUS\G
You will see
- exclusive locks
- shared locks
- corresponding queries
- number of read IO thread in use
- number of write IO thread in use
Here are some sample questions I answered that uses the output of SHOW ENGINE INNODB STATUS\G
- Will these two queries result in a deadlock if executed in sequence?
- Trouble deciphering a deadlock in an innodb status log
Give it a Try !!!
RolandoMySQLDBA
- 185,223
- 33
- 326
- 536