Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5639

Slow shutdown with many tables

    XMLWordPrintable

    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

          1. extract_shutdown_time.sh
            0.5 kB
            Satya Bodapati
          2. percona-slow-shutdown.test
            2 kB
            Satya Bodapati
          3. percona-slow-shutdown-master.opt
            0.3 kB
            Satya Bodapati

            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