2020-07-20T09:00:27.901908+08:00 0 [Note] Giving 93 client threads a chance to die gracefully
2020-07-20T09:00:27.902043+08:00 0 [Note] Shutting down slave threads
2020-07-20T09:00:29.902245+08:00 0 [Note] Forcefully disconnecting 81 remaining clients
2020-07-20T09:00:29.904014+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54253 user: 'tcqrkeys'
2020-07-20T09:00:29.904042+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54191 user: 'tcqrass'
2020-07-20T09:00:29.904069+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54167 user: 'tcqrmng'
2020-07-20T09:00:29.904092+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54227 user: 'tcqrass'
2020-07-20T09:00:29.904137+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54187 user: 'tcqrbfs'
2020-07-20T09:00:29.904191+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54215 user: 'tcqrcs'
2020-07-20T09:00:29.904216+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54198 user: 'tcqrcs'
2020-07-20T09:00:29.904235+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54229 user: 'tcqrwxs'
2020-07-20T09:00:29.904259+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54214 user: 'tcqrrps'
2020-07-20T09:00:29.904276+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54250 user: 'tcqrcs'
2020-07-20T09:00:29.904296+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54222 user: 'tcqrbfs'
2020-07-20T09:00:29.904361+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54233 user: 'tcqrcs'
2020-07-20T09:00:29.904379+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54199 user: 'tcqrposfe'
2020-07-20T09:00:29.904399+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54244 user: 'tcqrrps'
2020-07-20T09:00:29.904419+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54223 user: 'tcqrwxs'
2020-07-20T09:00:29.904438+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54188 user: 'tcqrposfe'
2020-07-20T09:00:29.904457+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54249 user: 'tcqrcs'
2020-07-20T09:00:29.904478+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54254 user: 'tcqrass'
2020-07-20T09:00:29.904498+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54235 user: 'tcqrrps'
2020-07-20T09:00:29.904517+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54238 user: 'tcqrposfe'
2020-07-20T09:00:29.904536+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54177 user: 'tcqrkeys'
2020-07-20T09:00:29.904555+08:00 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 54179 user: 'tcqrass'
2020-07-20T09:00:29.904585+08:00 0 [Note] Event Scheduler: Purging the queue. 0 event
2020-07-20T09:00:29.923844+08:00 0 [Note] Binlog end
2020-07-20T09:00:29.930890+08:00 0 [Note] Shutting down plugin 'ngram'
2020-07-20T09:00:29.930941+08:00 0 [Note] Shutting down plugin 'partition'
2020-07-20T09:00:29.930949+08:00 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-07-20T09:00:29.930957+08:00 0 [Note] Shutting down plugin 'ARCHIVE'
2020-07-20T09:00:29.930962+08:00 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-07-20T09:00:29.930996+08:00 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-07-20T09:00:29.931005+08:00 0 [Note] Shutting down plugin 'MyISAM'
2020-07-20T09:00:29.931019+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-07-20T09:00:29.931026+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-07-20T09:00:29.931030+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-07-20T09:00:29.931035+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-07-20T09:00:29.931040+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-07-20T09:00:29.931044+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-07-20T09:00:29.931049+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-07-20T09:00:29.931053+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-07-20T09:00:29.931058+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-07-20T09:00:29.931062+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-07-20T09:00:29.931066+08:00 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-07-20T09:00:29.931071+08:00 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-07-20T09:00:29.931075+08:00 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-07-20T09:00:29.931080+08:00 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-07-20T09:00:29.931084+08:00 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-07-20T09:00:29.931101+08:00 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-07-20T09:00:29.931107+08:00 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-07-20T09:00:29.931164+08:00 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-07-20T09:00:29.931177+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-07-20T09:00:29.931182+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-07-20T09:00:29.931186+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-07-20T09:00:29.931191+08:00 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-07-20T09:00:29.931196+08:00 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-07-20T09:00:29.931200+08:00 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-07-20T09:00:29.931205+08:00 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-07-20T09:00:29.931209+08:00 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-07-20T09:00:29.931213+08:00 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-07-20T09:00:29.931218+08:00 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-07-20T09:00:29.931222+08:00 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-07-20T09:00:29.931227+08:00 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-07-20T09:00:29.931232+08:00 0 [Note] Shutting down plugin 'InnoDB'
2020-07-20T09:00:29.931305+08:00 0 [Note] InnoDB: FTS optimize thread exiting.
2020-07-20T09:00:29.931432+08:00 0 [Note] InnoDB: Starting shutdown...
2020-07-20T09:00:30.031790+08:00 0 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/3306/ib_buffer_pool
2020-07-20T09:00:30.051024+08:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 200720 9:00:30
2020-07-20T09:00:31.453688+08:00 0 [Note] InnoDB: Shutdown completed; log sequence number 22460500736
2020-07-20T09:00:31.453850+08:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-07-20T09:00:31.453871+08:00 0 [Note] Shutting down plugin 'MEMORY'
2020-07-20T09:00:31.453880+08:00 0 [Note] Shutting down plugin 'CSV'
2020-07-20T09:00:31.453887+08:00 0 [Note] Shutting down plugin 'sha256_password'
2020-07-20T09:00:31.453893+08:00 0 [Note] Shutting down plugin 'mysql_native_password'
2020-07-20T09:00:31.454048+08:00 0 [Note] Shutting down plugin 'binlog'
2020-07-20T09:00:31.454959+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-07-20T01:00:43.045604Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 15000)
2020-07-20T01:00:43.045862Z 0 [Warning] Changed limits: table_open_cache: 995 (requested 2048)
2020-07-20T09:00:43.227335+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-07-20T09:00:43.227374+08:00 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2020-07-20T09:00:43.227380+08:00 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-07-20T09:00:43.228778+08:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 35585 ...
2020-07-20T09:00:43.255713+08:00 0 [Note] InnoDB: PUNCH HOLE support available
2020-07-20T09:00:43.255790+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-07-20T09:00:43.255799+08:00 0 [Note] InnoDB: Uses event mutexes
2020-07-20T09:00:43.255805+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-07-20T09:00:43.255811+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-07-20T09:00:43.255817+08:00 0 [Note] InnoDB: Using Linux native AIO
2020-07-20T09:00:43.257855+08:00 0 [Note] InnoDB: Number of pools: 1
2020-07-20T09:00:43.258023+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
2020-07-20T09:00:43.262083+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 8, chunk size = 128M
2020-07-20T09:00:44.545483+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-20T09:00:44.680148+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-07-20T09:00:44.722413+08:00 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-07-20T09:00:45.402396+08:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-20T09:00:45.402590+08:00 0 [Note] InnoDB: Setting file '/data/mysql/3306/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-20T09:00:45.464160+08:00 0 [Note] InnoDB: File '/data/mysql/3306/ibtmp1' size is now 12 MB.
2020-07-20T09:00:45.465508+08:00 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-07-20T09:00:45.465535+08:00 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-07-20T09:00:45.467315+08:00 0 [Note] InnoDB: Waiting for purge to start
2020-07-20T09:00:45.518533+08:00 0 [Note] InnoDB: 5.7.18 started; log sequence number 22460500736
2020-07-20T09:00:45.518855+08:00 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/3306/ib_buffer_pool
2020-07-20T09:00:45.519057+08:00 0 [Note] Plugin 'FEDERATED' is disabled.
2020-07-20T09:00:45.835841+08:00 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usab
uj5u.com熱心網友回復：
Giving 93 client threads a chance to die gracefully93個行程優雅gg。。。
檢查下：
1.是否是系統層面的例外
2.是否是內核引數的設定問題
3.是否是資料庫引數的設定
4.bug
可以參考下：https://blog.csdn.net/weixin_34378045/article/details/90248044
希望有用
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/11840.html
標籤：MySQL