Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
3.2.1
-
None
-
None
-
16
Description
The pt-stalk tool has on the code:
local have_lock_waits_table="" $CMD_MYSQL $EXT_ARGV -e "SHOW TABLES FROM INFORMATION_SCHEMA" \ | grep -i "INNODB_LOCK_WAITS" >/dev/null 2>&1 if [ $? -eq 0 ]; then have_lock_waits_table="yes" fi
However, in MySQL 8 this table was migrated to PS. I suggest we start using the following table for MySQL 8:
sys.innodb_lock_waitsÂ
It contains a lot of information and pretty much resumes the necessary analysis for lock situation.