Details

      Description

      Percona Server 5.7 shutdowns for 10 or more minutes on a server with over than 2M tables.

      How to Repeat.

      1. Load dump, pointed in the hidden comment 
      2. Run mysqldump --all-databases --no-data >/dev/null
      3. Watch that "Dictionary memory allocated" is 16702202333 or higher in the SHOW ENGINE INNODB STATUS output
      4. Shutdown the server, measure time

      Data from the MySQL Sandbox test:

      mysql [localhost:5726] {msandbox} ((none)) > show engine innodb status\G
      Dictionary memory allocated 167022023331 row in set (0.00 sec)
      [COR-SER] [sveta.smirnova@tp-support03 msb_5_7_26]$ time ./stop
      stop /home/sveta.smirnova/sandboxes/msb_5_7_26
      real    11m19.235s
      user    0m0.028s
      sys     0m0.066s
      

      This is only repeatable with provided structure. Tried 2M encrypted tables: shutdown is fast. Also accessing table definitions before shutdown is a must.

      This is also repeatable with upstream, but I am not creating a report there yet, because test case contains sensitive data.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                satya.bodapati Satya Bodapati
                Reporter:
                sveta.smirnova Sveta Smirnova
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 week, 1 day, 5 hours
                  1w 1d 5h