Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10198

MariaDB restart is too slow

    XMLWordPrintable

Details

    Description

      The size of our data is around 200 - 300G and 4703 tables. After restart, on doing strace we can see that it scans all the .ibd files nearly 200000 files and takes about 10 mins to start.

      160608 02:11:45 mysqld_safe Starting mysqld daemon with databases from /path/to/mysql/data
      2016-06-08  2:11:46 139989491841056 [Warning] option 'general_log': boolean value '/path/to/log/mysqld.log' wasn't recognized. Set to OFF.
      2016-06-08  2:11:46 139989491841056 [Note] /usr/libexec/mysqld (mysqld 10.1.14-MariaDB) starting as process 10933 ...
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: The InnoDB memory heap is disabled
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Memory barrier is not used
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Using Linux native AIO
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Using SSE crc32 instructions
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Initializing buffer pool, size = 2.0G
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Completed initialization of buffer pool
      2016-06-08  2:11:46 139989491841056 [Note] InnoDB: Highest supported file format is Barracuda.
      2016-06-08  2:22:38 139989491841056 [Note] InnoDB: 128 rollback segment(s) are active.
      2016-06-08  2:22:38 139989491841056 [Note] InnoDB: Waiting for purge to start
      2016-06-08  2:22:39 139989491841056 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 21147217244291
      2016-06-08  2:22:39 139986282186496 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2016-06-08  2:22:39 139989491841056 [Note] Plugin 'FEEDBACK' is disabled.
      2016-06-08  2:22:39 139989491841056 [Note] Server socket created on IP: '::'.
      2016-06-08  2:22:39 139989491841056 [Note] /usr/libexec/mysqld: ready for connections.
      Version: '10.1.14-MariaDB'  socket: '/path/to/mysql.sock'  port: 3306  MariaDB Server
      

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              dgavhane Darshit Gavhane
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.