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

LP #1307377: pt-stalk ominous open_tables function

Details

    • Yes
    • 6

    Description

      **Reported in Launchpad by MikeG last update 17-11-2016 12:11:25

      Currently the open_tables function logs to the TS-opentables files what appears to be an error message, rather than a warning:

      open_tables() {
      local open_tables=$($CMD_MYSQLADMIN $EXT_ARGV ext | grep "Open_tables" | awk '

      {print $4}

      ')
      if [ -n "$open_tables" -a $open_tables -le 1000 ]; then
      $CMD_MYSQL $EXT_ARGV -e 'SHOW OPEN TABLES' &
      else
      log "Too many open tables: $open_tables"
      fi
      }

      This would be less confusing if it had a log entry that was more verbose, such as the following:

      log "Logging disabled due to having over 1000 tables open. Number of tables currently open: $open_tables"

      Attachments

        Issue Links

          Activity

            People

              sveta.smirnova Sveta Smirnova
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist