Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.1.5
-
Fix Version/s: 10.1.6
-
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
-
Labels:None
-
Sprint:10.1.6-1
Description
Hi,
Dumping the buffer pool on shutdown is very noisy when having large buffer pool:
[...]
|
2015-06-10 15:14:43 140091534046976 [Warning] InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
|
2015-06-10 15:14:43 140091534046976 [Note] InnoDB: Dumping buffer pool 1/35, page 1/124296
|
2015-06-10 15:14:43 140091534046976 [Note] InnoDB: Dumping buffer pool 1/35, page 129/124296
|
[...]
|
2015-06-10 15:14:45 140091534046976 [Note] InnoDB: Dumping buffer pool 35/35, page 123905/124054
|
2015-06-10 15:14:45 140091534046976 [Note] InnoDB: Dumping buffer pool 35/35, page 124033/124054
|
2015-06-10 15:14:45 140091534046976 [Warning] InnoDB: Buffer pool(s) dump completed at 150610 15:14:45
|
[...]
|
cat mysqld2.log | wc --lines --bytes
|
33824 3241720
|
cat mysqld2.log | grep -v "Dumping buffer pool" | wc --lines --bytes
|
41 3938
|
So the logs for the dump account for 3MB and more than 33K lines on a less than 3 seconds dump.
In 10.0.16, I do not have all those lines when doing MariaDB restart:
150611 12:50:05 [Note] /usr/sbin/mysqld: Normal shutdown
|
[...]
|
150611 12:50:05 [Note] InnoDB: Starting shutdown...
|
2015-06-11 12:50:06 7ee566df7700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
|
2015-06-11 12:50:09 7ee566df7700 InnoDB: Buffer pool(s) dump completed at 150611 12:50:09
|
[...]
|
150611 12:50:30 [Note] /usr/sbin/mysqld: Shutdown complete
|
[...]
|
150611 12:50:31 mysqld_safe Starting mysqld_wrapper daemon with databases from [...]
|
[...]
|
Version: '10.0.16-MariaDB-log' socket: 'mysql.sock' port: 3306 MariaDB Server
|
Thanks for looking into that,
JFG