Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.14
-
OS: centos-release-6-6.el6.centos.12.2.x86_64
Architecture: x86_64
Hardware: vcpu-4, memory-15GiB
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
- is blocked by
-
MDEV-9931 InnoDB reads first page of every .ibd file at startup
- Closed
- relates to
-
MDEV-12610 MariaDB start is slow
- Closed