Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1897

pt-stalk on MySQL 8 not collecting "lock" information

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 3.2.1
    • 3.5.0
    • 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.

      Attachments

        Issue Links

          Activity

            People

              sveta.smirnova Sveta Smirnova
              vinicius.grippa Vinicius Grippa
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist