这是重启时的LOG，没有其它报错！
2018-08-15T10:57:04.065617Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6912ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
2018-08-15T11:46:19.671500Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 27823 ...
2018-08-15T11:46:19.850184Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-08-15T11:46:19.850224Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-15T11:46:19.850230Z 0 [Note] InnoDB: Uses event mutexes
2018-08-15T11:46:19.850235Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-08-15T11:46:19.850240Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-08-15T11:46:19.850247Z 0 [Note] InnoDB: Using Linux native AIO
2018-08-15T11:46:19.852433Z 0 [Note] InnoDB: Number of pools: 1
2018-08-15T11:46:19.852569Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-08-15T11:46:19.853861Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 2, chunk size = 128M
2018-08-15T11:46:20.117924Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-08-15T11:46:20.144739Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-08-15T11:46:20.175240Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-15T11:46:20.213402Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 187352683223
2018-08-15T11:46:20.213452Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 187352683232
2018-08-15T11:46:20.228231Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 187352683232
2018-08-15T11:46:20.228259Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-08-15T11:46:20.228266Z 0 [Note] InnoDB: Starting crash recovery.
2018-08-15T11:46:21.017925Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-08-15T11:46:21.017950Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-08-15T11:46:21.017994Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-08-15T11:46:21.105443Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-08-15T11:46:21.106249Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-08-15T11:46:21.106263Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-08-15T11:46:21.106600Z 0 [Note] InnoDB: Waiting for purge to start
2018-08-15T11:46:21.156748Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 187352683232
2018-08-15T11:46:21.157534Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-08-15T11:46:21.158340Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-08-15T11:46:21.186059Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-08-15T11:46:21.189986Z 0 [Warning] CA certificate ca.pem is self signed.
2018-08-15T11:46:21.195839Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-08-15T11:46:21.195883Z 0 [Note] IPv6 is available.
2018-08-15T11:46:21.195897Z 0 [Note] - '::' resolves to '::';
2018-08-15T11:46:21.195919Z 0 [Note] Server socket created on IP: '::'.
2018-08-15T11:46:21.212616Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212665Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212675Z 0 [Warning] 'user' entry 'kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212684Z 0 [Warning] 'user' entry 'lvshiguan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212692Z 0 [Warning] 'user' entry 'bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212701Z 0 [Warning] 'user' entry 'zhimeng@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212709Z 0 [Warning] 'user' entry 'vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212717Z 0 [Warning] 'user' entry 'foxphp@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212725Z 0 [Warning] 'user' entry 'h5@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212737Z 0 [Warning] 'user' entry 'zhibo@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212746Z 0 [Warning] 'user' entry 'luhan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212754Z 0 [Warning] 'user' entry 'lili@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213514Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213527Z 0 [Warning] 'db' entry 'kppw30 kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213532Z 0 [Warning] 'db' entry 'lvshiguan lvshiguan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213537Z 0 [Warning] 'db' entry 'bbs bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213542Z 0 [Warning] 'db' entry 'bbs2 bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213546Z 0 [Warning] 'db' entry 'zhimeng zhimeng@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213550Z 0 [Warning] 'db' entry 'vlcms vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213554Z 0 [Warning] 'db' entry 'foxphp foxphp@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213559Z 0 [Warning] 'db' entry 'h5 h5@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213563Z 0 [Warning] 'db' entry 'vlcms2 vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213567Z 0 [Warning] 'db' entry 'kppw308 kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213572Z 0 [Warning] 'db' entry 'zhibo zhibo@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213576Z 0 [Warning] 'db' entry 'luhan luhan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213579Z 0 [Warning] 'db' entry 'lili lili@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.214235Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.226899Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.315377Z 0 [Note] Event Scheduler: Loaded 0 events
2018-08-15T11:46:21.316910Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-08-15T11:46:21.316923Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-08-15T11:46:22.786210Z 0 [Note] End of list of non-natively partitioned tables
2018-08-15T11:46:22.786563Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-08-15T11:46:36.705441Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180815 19:46:36=====================================my.cnf=============================
group_concat_max_len = 102400
character_set_server = utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.socksymbolic-links=0
explicit_defaults_for_timestamp=true
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidopen_files_limit = 10240
max_connections = 3000
max_connect_errors = 6000
max_allowed_packet = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 300
query_cache_size = 64M
query_cache_limit = 4M
query_cache_min_res_unit = 2k default-storage-engine = MyISAM
#default_table_type = InnoDBthread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 256M
max_heap_table_size = 256M
binlog_cache_size = 4M
max_binlog_cache_size = 8M
max_binlog_size = 512Mexpire_logs_days = 7
key_buffer_size = 2048M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
#myisam_max_extra_sort_file_size = 10G
#myisam_repair_threads = 1
#myisam_recover
skip-name-resolve
lower_case_table_names = 1#server-id = 1innodb_buffer_pool_size = 3G
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
innodb_buffer_pool_instances = 2
innodb_page_cleaners = 2操作系统： CentOS 7.2 64位，mysql 5.7.17 服务器物理内存是4G，现在数据量比较小，最大的表记录数未超过250W行！数据库已经运行快2年了，随机重启的问题是从昨天才开始出现的！
2018-08-15T10:57:04.065617Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6912ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
2018-08-15T11:46:19.671500Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 27823 ...
2018-08-15T11:46:19.850184Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-08-15T11:46:19.850224Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-08-15T11:46:19.850230Z 0 [Note] InnoDB: Uses event mutexes
2018-08-15T11:46:19.850235Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-08-15T11:46:19.850240Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-08-15T11:46:19.850247Z 0 [Note] InnoDB: Using Linux native AIO
2018-08-15T11:46:19.852433Z 0 [Note] InnoDB: Number of pools: 1
2018-08-15T11:46:19.852569Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-08-15T11:46:19.853861Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 2, chunk size = 128M
2018-08-15T11:46:20.117924Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-08-15T11:46:20.144739Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-08-15T11:46:20.175240Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-15T11:46:20.213402Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 187352683223
2018-08-15T11:46:20.213452Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 187352683232
2018-08-15T11:46:20.228231Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 187352683232
2018-08-15T11:46:20.228259Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-08-15T11:46:20.228266Z 0 [Note] InnoDB: Starting crash recovery.
2018-08-15T11:46:21.017925Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-08-15T11:46:21.017950Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-08-15T11:46:21.017994Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-08-15T11:46:21.105443Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-08-15T11:46:21.106249Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-08-15T11:46:21.106263Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-08-15T11:46:21.106600Z 0 [Note] InnoDB: Waiting for purge to start
2018-08-15T11:46:21.156748Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 187352683232
2018-08-15T11:46:21.157534Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-08-15T11:46:21.158340Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-08-15T11:46:21.186059Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-08-15T11:46:21.189986Z 0 [Warning] CA certificate ca.pem is self signed.
2018-08-15T11:46:21.195839Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-08-15T11:46:21.195883Z 0 [Note] IPv6 is available.
2018-08-15T11:46:21.195897Z 0 [Note] - '::' resolves to '::';
2018-08-15T11:46:21.195919Z 0 [Note] Server socket created on IP: '::'.
2018-08-15T11:46:21.212616Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212665Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212675Z 0 [Warning] 'user' entry 'kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212684Z 0 [Warning] 'user' entry 'lvshiguan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212692Z 0 [Warning] 'user' entry 'bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212701Z 0 [Warning] 'user' entry 'zhimeng@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212709Z 0 [Warning] 'user' entry 'vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212717Z 0 [Warning] 'user' entry 'foxphp@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212725Z 0 [Warning] 'user' entry 'h5@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212737Z 0 [Warning] 'user' entry 'zhibo@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212746Z 0 [Warning] 'user' entry 'luhan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.212754Z 0 [Warning] 'user' entry 'lili@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213514Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213527Z 0 [Warning] 'db' entry 'kppw30 kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213532Z 0 [Warning] 'db' entry 'lvshiguan lvshiguan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213537Z 0 [Warning] 'db' entry 'bbs bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213542Z 0 [Warning] 'db' entry 'bbs2 bbs@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213546Z 0 [Warning] 'db' entry 'zhimeng zhimeng@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213550Z 0 [Warning] 'db' entry 'vlcms vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213554Z 0 [Warning] 'db' entry 'foxphp foxphp@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213559Z 0 [Warning] 'db' entry 'h5 h5@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213563Z 0 [Warning] 'db' entry 'vlcms2 vlcms@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213567Z 0 [Warning] 'db' entry 'kppw308 kppw@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213572Z 0 [Warning] 'db' entry 'zhibo zhibo@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213576Z 0 [Warning] 'db' entry 'luhan luhan@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.213579Z 0 [Warning] 'db' entry 'lili lili@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.214235Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.226899Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-08-15T11:46:21.315377Z 0 [Note] Event Scheduler: Loaded 0 events
2018-08-15T11:46:21.316910Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-08-15T11:46:21.316923Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-08-15T11:46:22.786210Z 0 [Note] End of list of non-natively partitioned tables
2018-08-15T11:46:22.786563Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-08-15T11:46:36.705441Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180815 19:46:36=====================================my.cnf=============================
group_concat_max_len = 102400
character_set_server = utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.socksymbolic-links=0
explicit_defaults_for_timestamp=true
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidopen_files_limit = 10240
max_connections = 3000
max_connect_errors = 6000
max_allowed_packet = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 300
query_cache_size = 64M
query_cache_limit = 4M
query_cache_min_res_unit = 2k default-storage-engine = MyISAM
#default_table_type = InnoDBthread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 256M
max_heap_table_size = 256M
binlog_cache_size = 4M
max_binlog_cache_size = 8M
max_binlog_size = 512Mexpire_logs_days = 7
key_buffer_size = 2048M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
#myisam_max_extra_sort_file_size = 10G
#myisam_repair_threads = 1
#myisam_recover
skip-name-resolve
lower_case_table_names = 1#server-id = 1innodb_buffer_pool_size = 3G
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
innodb_buffer_pool_instances = 2
innodb_page_cleaners = 2操作系统： CentOS 7.2 64位，mysql 5.7.17 服务器物理内存是4G，现在数据量比较小，最大的表记录数未超过250W行！数据库已经运行快2年了，随机重启的问题是从昨天才开始出现的！
2018-08-16T01:16:39.922793Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 16398 ...
从日志上看，page_cleaner出错后就会重启服务，
SET GLOBAL innodb_lru_scan_depth=256;
没有测试过。