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

            Issue Links

              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