Shulou(Shulou.com)06/01 Report--

Quickly preheat buffer_pool

The way of mysql management, optimize P82 page

# # innodb_buffer_pool_dump_at_shutdown=1

# innodb_buffer_pool_dump_now=1-enable these two parameters when off

Innodb_buffer_pool_load_at_startup=1

Innodb_buffer_pool_load_now=1-enable these two parameters at startup

Close the log:

2016-07-13T07:58:55.450965Z 0 [Note] InnoDB: Dumping buffer pool (s) to / var/lib/mysql/ib_buffer_pool

2016-07-13T07:58:55.451435Z 0 [Note] InnoDB: Buffer pool (s) dump completed at 160713 15:58:55

Open the log

2016-07-13T08:00:15.642531Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 2489080

2016-07-13T08:00:15.643271Z 0 [Note] InnoDB: Loading buffer pool (s) from / var/lib/mysql/ib_buffer_pool

Note:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.