# No correctly shutdown when pool-of-threads is configured

**URL:** <https://forums.percona.com/t/no-correctly-shutdown-when-pool-of-threads-is-configured/5291>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [December 14, 2016, 1:48am UTC](https://forums.percona.com/t/no-correctly-shutdown-when-pool-of-threads-is-configured/5291 "2016-12-14T01:48:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Masataka\_Fukui](https://avatars.discourse-cdn.com/v4/letter/m/8c91f0/32.png) [@Masataka\_Fukui](https://forums.percona.com/u/Masataka_Fukui)\
**Post date:** [December 14, 2016, 1:48am UTC](https://forums.percona.com/t/no-correctly-shutdown-when-pool-of-threads-is-configured/5291/1 "2016-12-14T01:48:22Z")

</div>

Hi,  
I set “thread\_handling=pool-of-threads” to “my.cnf” on Precona-server 5.7.16-10-log.

Mysqld\_safe detected that mysqld is downed, and Mysqld\_safe restarted mysqld,  
when mysql is shutdown with commands below:

Case1# /etc/init.d/mysql stop  
Case2# kill “mysqld process id”

Log below was written.

> 2016-12-13T05:05:45.910205Z mysqld\_safe Number of processes running now: 0  
> 2016-12-13T05:05:45.911295Z mysqld\_safe mysqld restarted

Shutdown process is not written.

I use “kill -9 all mysql process(mysqld\_safe and mysqld)” in order to stop mysql.

if “thread\_handling=one-thread-per-connection” is configured,  
msyql is correctly shutdown with using above command.

Log below was written.

> 2016-12-14T11:44:52.475282+09:00 0 [Note] Giving 1 client threads a chance to die gracefully  
> 2016-12-14T11:44:52.475325+09:00 0 [Note] Shutting down slave threads  
> 2016-12-14T11:44:54.475460+09:00 0 [Note] Forcefully disconnecting 1 remaining clients  
> 2016-12-14T11:44:54.475551+09:00 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 1  
> 2016-12-14T11:44:54.475566+09:00 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply  
> 2016-12-14T11:44:54.475711+09:00 0 [Note] Event Scheduler: Stopped  
> 2016-12-14T11:44:54.475752+09:00 0 [Note] Event Scheduler: Purging the queue. 0 events  
> 2016-12-14T11:44:54.475929+09:00 0 [Note] Binlog end  
> 2016-12-14T11:44:54.477679+09:00 0 [Note] Shutting down plugin ‘validate\_password’  
> 2016-12-14T11:44:54.477710+09:00 0 [Note] Shutting down plugin ‘ngram’  
> 2016-12-14T11:44:54.477715+09:00 0 [Note] Shutting down plugin ‘ARCHIVE’  
> 2016-12-14T11:44:54.477743+09:00 0 [Note] Shutting down plugin ‘partition’  
> 2016-12-14T11:44:54.477748+09:00 0 [Note] Shutting down plugin ‘BLACKHOLE’  
> 2016-12-14T11:44:54.477753+09:00 0 [Note] Shutting down plugin ‘MEMORY’  
> 2016-12-14T11:44:54.477763+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_VIRTUAL’  
> 2016-12-14T11:44:54.477771+09:00 0 [Note] Shutting down plugin ‘INNODB\_CHANGED\_PAGES’  
> 2016-12-14T11:44:54.477774+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_DATAFILES’  
> 2016-12-14T11:44:54.477780+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLESPACES’  
> 2016-12-14T11:44:54.477796+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_FOREIGN\_COLS’  
> 2016-12-14T11:44:54.477809+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_FOREIGN’  
> 2016-12-14T11:44:54.477821+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_FIELDS’  
> 2016-12-14T11:44:54.477856+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_COLUMNS’  
> 2016-12-14T11:44:54.477864+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_INDEXES’  
> 2016-12-14T11:44:54.477867+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLESTATS’  
> 2016-12-14T11:44:54.477870+09:00 0 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLES’  
> 2016-12-14T11:44:54.477873+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_INDEX\_TABLE’  
> 2016-12-14T11:44:54.477876+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_INDEX\_CACHE’  
> 2016-12-14T11:44:54.477878+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_CONFIG’  
> 2016-12-14T11:44:54.477895+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_BEING\_DELETED’  
> 2016-12-14T11:44:54.477914+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_DELETED’  
> 2016-12-14T11:44:54.477921+09:00 0 [Note] Shutting down plugin ‘INNODB\_FT\_DEFAULT\_STOPWORD’  
> 2016-12-14T11:44:54.477924+09:00 0 [Note] Shutting down plugin ‘INNODB\_METRICS’  
> 2016-12-14T11:44:54.477927+09:00 0 [Note] Shutting down plugin ‘INNODB\_TEMP\_TABLE\_INFO’  
> 2016-12-14T11:44:54.477930+09:00 0 [Note] Shutting down plugin ‘INNODB\_BUFFER\_POOL\_STATS’  
> 2016-12-14T11:44:54.477933+09:00 0 [Note] Shutting down plugin ‘INNODB\_BUFFER\_PAGE\_LRU’  
> 2016-12-14T11:44:54.477939+09:00 0 [Note] Shutting down plugin ‘INNODB\_BUFFER\_PAGE’  
> 2016-12-14T11:44:54.477953+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX\_RESET’  
> 2016-12-14T11:44:54.477967+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX’  
> 2016-12-14T11:44:54.477970+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMPMEM\_RESET’  
> 2016-12-14T11:44:54.477973+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMPMEM’  
> 2016-12-14T11:44:54.477975+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMP\_RESET’  
> 2016-12-14T11:44:54.477978+09:00 0 [Note] Shutting down plugin ‘INNODB\_CMP’  
> 2016-12-14T11:44:54.477984+09:00 0 [Note] Shutting down plugin ‘INNODB\_LOCK\_WAITS’  
> 2016-12-14T11:44:54.477995+09:00 0 [Note] Shutting down plugin ‘INNODB\_LOCKS’  
> 2016-12-14T11:44:54.477998+09:00 0 [Note] Shutting down plugin ‘INNODB\_TRX’  
> 2016-12-14T11:44:54.478000+09:00 0 [Note] Shutting down plugin ‘XTRADB\_RSEG’  
> 2016-12-14T11:44:54.478003+09:00 0 [Note] Shutting down plugin ‘XTRADB\_INTERNAL\_HASH\_TABLES’  
> 2016-12-14T11:44:54.478005+09:00 0 [Note] Shutting down plugin ‘XTRADB\_READ\_VIEW’  
> 2016-12-14T11:44:54.478008+09:00 0 [Note] Shutting down plugin ‘InnoDB’  
> 2016-12-14T11:44:54.478072+09:00 0 [Note] InnoDB: FTS optimize thread exiting.  
> 2016-12-14T11:44:54.478187+09:00 0 [Note] InnoDB: Starting shutdown…  
> 2016-12-14T11:44:54.578444+09:00 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/ext0/mysql/ib\_buffer\_pool  
> 2016-12-14T11:44:54.578770+09:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 161214 11:44:54  
> 2016-12-14T11:44:54.978770+09:00 0 [Note] InnoDB: Waiting for page\_cleaner to finish flushing of buffer pool  
> 2016-12-14T11:44:56.392944+09:00 0 [Note] InnoDB: Shutdown completed; log sequence number 2491861  
> 2016-12-14T11:44:56.394624+09:00 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”  
> 2016-12-14T11:44:56.394649+09:00 0 [Note] Shutting down plugin ‘CSV’  
> 2016-12-14T11:44:56.394659+09:00 0 [Note] Shutting down plugin ‘MyISAM’  
> 2016-12-14T11:44:56.394677+09:00 0 [Note] Shutting down plugin ‘MRG\_MYISAM’  
> 2016-12-14T11:44:56.394687+09:00 0 [Note] Shutting down plugin ‘PERFORMANCE\_SCHEMA’  
> 2016-12-14T11:44:56.394718+09:00 0 [Note] Shutting down plugin ‘sha256\_password’  
> 2016-12-14T11:44:56.394726+09:00 0 [Note] Shutting down plugin ‘mysql\_native\_password’  
> 2016-12-14T11:44:56.394902+09:00 0 [Note] Shutting down plugin ‘binlog’  
> 2016-12-14T11:44:56.397651+09:00 0 [Note] /usr/sbin/mysqld: Shutdown complete

I investigated.

When pool-of-threads is configured,  
Mysql seems to not shutdown correctly with kill command.

I think that it’s necessary to shutdown mysql correctly with kill command when pool-of-threads is configured.

Please check this.

Thanks,  
Mastaka