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

Slow startup after upgrade from 5.7 to 8

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: New
    • Priority: Low
    • Resolution: Reopened
    • Affects Version/s: Not 5.6, Not 5.7, 8.0.13-4
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      Ubuntu 18.04 LTS

      Description

      After an upgrade from MySQL 5.7 to 8, the startup time increased from <1 minute to 20-40 minutes. The startup procedure freezes at "(mysqld 8.0.13-4) starting as process" .

      During the freeze, the process CPU usage is more or less idle while the storage (HDD RAID array) is overloaded, doing 100-200 read requests/second (average 3-6MB/s). Since RAID array is capable of over 1000 read requests per second when doing multithread reads, this suggests the internal job is single threaded. The disk and cpu usage pattern are strikingly similar with the ones experienced during upgrade.

      The database has over 70K tables and is very large. All tables are using InnoDB. Before upgrade, restart cycle was constant to less than 3 minutes. Configuration parameters were kept the same with the except of InnoDB buffer which was doubled in size. To be noted that server is configured not to dump or load any part of InnoDB buffer during shutdown/startup

        Smart Checklist

          Attachments

          1. debug-logs.txt
            17 kB
          2. ms_8_0_13.log
            214 kB
          3. my.cnf
            1 kB
          4. ps_8_0_13.log
            194 kB
          5. PS-5379_mysql_log_slow_startup.log
            19 kB
          6. PS-5379_upsteam_mysql_8_0_14_mysql_startup.log
            8 kB

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                sergiuhlihor Sergiu Hlihor
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: