2018-03-20T04:31:53.785192Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T04:31:53.816851Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
2018-03-20T04:31:53.816859Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
 100
 100
2018-03-20T04:31:55.224795Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-03-20T04:31:55.585111Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T04:31:55.806092Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T04:31:55.806502Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9eed3f26-2bf7-11e8-93d9-000d3afd167e.
2018-03-20T04:31:55.816294Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-03-20T04:31:55.816965Z 1 [Note] A temporary password is generated for root@localhost: k5<OIOq.yTgH
2018-03-20T04:32:05.801699Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T04:32:05.804008Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 14445 ...
2018-03-20T04:32:05.806448Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
2018-03-20T04:32:05.806458Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2018-03-20T04:32:05.807757Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T04:32:05.807774Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T04:32:05.807780Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T04:32:05.807786Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T04:32:05.807791Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T04:32:05.807800Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T04:32:05.808222Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T04:32:05.808346Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T04:32:05.825215Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T04:32:06.012550Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T04:32:06.048698Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T04:32:06.204969Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T04:32:07.586843Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T04:32:07.586911Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T04:32:07.905367Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T04:32:07.906445Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T04:32:07.906456Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T04:32:07.906695Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T04:32:07.960425Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536227
2018-03-20T04:32:07.960855Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T04:32:07.965324Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T04:32:07.981082Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T04:32:08.074798Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-03-20T04:32:08.074820Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T04:32:08.074844Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T04:32:08.074874Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T04:32:08.353657Z 0 [ERROR] /usr/sbin/mysqld: slave_preserve_commit_order is not supported unless the binlog and log_slave update options are both enabled.
2018-03-20T04:32:08.353678Z 0 [Note] Check error log for additional messages. You will not be able to start replication until the issue is resolved and the server restarted.
2018-03-20T04:32:08.361079Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T04:32:08.361143Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.Lo7ulT.sql' started.
2018-03-20T04:32:08.363598Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  4:32:08
2018-03-20T04:32:08.372546Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.Lo7ulT.sql' ended.
2018-03-20T04:32:08.372602Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T04:32:08.372612Z 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-03-20T04:32:08.372616Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T04:32:08.372775Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-03-20T04:32:08.372788Z 0 [Note] Shutting down slave threads
2018-03-20T04:32:08.372794Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-03-20T04:32:08.372826Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-03-20T04:32:08.383821Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T04:32:08.383916Z 0 [Note] Binlog end
2018-03-20T04:32:08.384346Z 0 [Note] Shutting down plugin 'ngram'
2018-03-20T04:32:08.384357Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-03-20T04:32:08.384362Z 0 [Note] Shutting down plugin 'partition'
2018-03-20T04:32:08.384367Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-03-20T04:32:08.384372Z 0 [Note] Shutting down plugin 'MyISAM'
2018-03-20T04:32:08.384380Z 0 [Note] Shutting down plugin 'CSV'
2018-03-20T04:32:08.384385Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-03-20T04:32:08.384390Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-03-20T04:32:08.384395Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-03-20T04:32:08.384399Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-03-20T04:32:08.384404Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-03-20T04:32:08.384427Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-03-20T04:32:08.384433Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-03-20T04:32:08.384437Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-03-20T04:32:08.384441Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-03-20T04:32:08.384445Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-03-20T04:32:08.384449Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-03-20T04:32:08.384453Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-03-20T04:32:08.384457Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-03-20T04:32:08.384461Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-03-20T04:32:08.384465Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-03-20T04:32:08.384470Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-03-20T04:32:08.384474Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-03-20T04:32:08.384482Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-03-20T04:32:08.384487Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-03-20T04:32:08.384491Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-03-20T04:32:08.384495Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-03-20T04:32:08.384499Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-03-20T04:32:08.384503Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-03-20T04:32:08.384507Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-03-20T04:32:08.384511Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-03-20T04:32:08.384515Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-03-20T04:32:08.384519Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-03-20T04:32:08.384524Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-03-20T04:32:08.384528Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-03-20T04:32:08.384532Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-03-20T04:32:08.384536Z 0 [Note] Shutting down plugin 'InnoDB'
2018-03-20T04:32:08.384580Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-03-20T04:32:08.384658Z 0 [Note] InnoDB: Starting shutdown...
2018-03-20T04:32:08.484905Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-03-20T04:32:08.485034Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180320  4:32:08
2018-03-20T04:32:10.035121Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2536499
2018-03-20T04:32:10.035263Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T04:32:10.035273Z 0 [Note] Shutting down plugin 'MEMORY'
2018-03-20T04:32:10.035280Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-03-20T04:32:10.035306Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-03-20T04:32:10.035315Z 0 [Note] Shutting down plugin 'sha256_password'
2018-03-20T04:32:10.035320Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-03-20T04:32:10.035482Z 0 [Note] Shutting down plugin 'binlog'
2018-03-20T04:32:10.069020Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-03-20T04:32:11.135622Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T04:32:11.137297Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 15311 ...
2018-03-20T04:32:11.139405Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
2018-03-20T04:32:11.139429Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2018-03-20T04:32:11.140924Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T04:32:11.140941Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T04:32:11.140948Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T04:32:11.140954Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T04:32:11.140959Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T04:32:11.140964Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T04:32:11.141396Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T04:32:11.141522Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T04:32:11.146812Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T04:32:11.316889Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T04:32:11.346115Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T04:32:11.453365Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T04:32:12.677105Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T04:32:12.677167Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T04:32:12.884039Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T04:32:12.884971Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T04:32:12.885006Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T04:32:12.885372Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T04:32:12.939158Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2536499
2018-03-20T04:32:12.939490Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T04:32:12.944167Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
2018-03-20T04:32:12.957458Z 0 [Note] Plugin 'validate_password' is disabled.
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T04:32:12.957652Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T04:32:12.982617Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-03-20T04:32:12.982934Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-20T04:32:12.984574Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T04:32:12.984621Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T04:32:12.984693Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T04:32:13.144805Z 0 [ERROR] /usr/sbin/mysqld: slave_preserve_commit_order is not supported unless the binlog and log_slave update options are both enabled.
2018-03-20T04:32:13.144824Z 0 [Note] Check error log for additional messages. You will not be able to start replication until the issue is resolved and the server restarted.
2018-03-20T04:32:13.151945Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T04:32:13.152169Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T04:32:13.152179Z 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-03-20T04:32:13.152183Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T04:32:13.164615Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T04:32:13.168654Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  4:32:13
2018-03-20T04:32:13.455604Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
2018-03-20T04:34:02.728720Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2018-03-20T04:34:54.472244Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-03-20T04:34:54.472268Z 0 [Note] Shutting down slave threads
2018-03-20T04:34:54.472275Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-03-20T04:34:54.472285Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-03-20T04:34:54.472435Z 0 [Note] Binlog end
2018-03-20T04:34:54.473974Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2018-03-20T04:34:54.473991Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master'
2018-03-20T04:34:54.474004Z 0 [Note] unregister_replicator OK
2018-03-20T04:34:54.474009Z 0 [Note] Shutting down plugin 'ngram'
2018-03-20T04:34:54.474014Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-03-20T04:34:54.474019Z 0 [Note] Shutting down plugin 'partition'
2018-03-20T04:34:54.474024Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-03-20T04:34:54.474030Z 0 [Note] Shutting down plugin 'MyISAM'
2018-03-20T04:34:54.474037Z 0 [Note] Shutting down plugin 'CSV'
2018-03-20T04:34:54.474061Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-03-20T04:34:54.474066Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-03-20T04:34:54.474087Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-03-20T04:34:54.474091Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-03-20T04:34:54.474102Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-03-20T04:34:54.474107Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-03-20T04:34:54.474111Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-03-20T04:34:54.474115Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-03-20T04:34:54.474120Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-03-20T04:34:54.474148Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-03-20T04:34:54.474153Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-03-20T04:34:54.474180Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-03-20T04:34:54.474184Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-03-20T04:34:54.474205Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-03-20T04:34:54.474209Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-03-20T04:34:54.474214Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-03-20T04:34:54.474218Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-03-20T04:34:54.474222Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-03-20T04:34:54.474226Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-03-20T04:34:54.474230Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-03-20T04:34:54.474243Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-03-20T04:34:54.474247Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-03-20T04:34:54.474252Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-03-20T04:34:54.474256Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-03-20T04:34:54.474260Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-03-20T04:34:54.474289Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-03-20T04:34:54.474293Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-03-20T04:34:54.474297Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-03-20T04:34:54.474301Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-03-20T04:34:54.474305Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-03-20T04:34:54.474309Z 0 [Note] Shutting down plugin 'InnoDB'
2018-03-20T04:34:54.474403Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-03-20T04:34:54.474595Z 0 [Note] InnoDB: Starting shutdown...
2018-03-20T04:34:54.574854Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-03-20T04:34:54.574964Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180320  4:34:54
2018-03-20T04:34:56.116910Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2544585
2018-03-20T04:34:56.117102Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T04:34:56.117112Z 0 [Note] Shutting down plugin 'MEMORY'
2018-03-20T04:34:56.117119Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-03-20T04:34:56.117162Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-03-20T04:34:56.117190Z 0 [Note] Shutting down plugin 'sha256_password'
2018-03-20T04:34:56.117195Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-03-20T04:34:56.117388Z 0 [Note] Shutting down plugin 'binlog'
2018-03-20T04:34:56.147678Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-03-20T04:36:28.018199Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T04:36:28.020727Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 15911 ...
2018-03-20T04:36:28.032294Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T04:36:28.032316Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T04:36:28.032326Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T04:36:28.032332Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T04:36:28.032339Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T04:36:28.032345Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T04:36:28.032870Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T04:36:28.032988Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T04:36:28.039924Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T04:36:28.211504Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T04:36:28.242499Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T04:36:28.442172Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T04:36:29.936385Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T04:36:29.936477Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T04:36:30.063059Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T04:36:30.064068Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T04:36:30.064082Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T04:36:30.064325Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T04:36:30.118097Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 2544585
2018-03-20T04:36:30.118461Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T04:36:30.122660Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T04:36:30.133284Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T04:36:30.305027Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-03-20T04:36:30.305252Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-20T04:36:30.306416Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T04:36:30.306446Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T04:36:30.306475Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T04:36:30.387534Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T04:36:30.387601Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T04:36:30.452479Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T04:36:30.478926Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T04:36:30.479122Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T04:36:30.479132Z 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-03-20T04:36:30.479136Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T04:36:30.490265Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T04:36:30.533180Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  4:36:30
2018-03-20T04:36:35.736422Z 17 [Note] Semi-sync replication initialized for transactions.
2018-03-20T04:36:35.736438Z 17 [Note] Semi-sync replication enabled on the master.
2018-03-20T04:36:35.737157Z 0 [Note] Starting ack receiver thread
2018-03-20T04:36:39.434737Z 20 [Note] Start binlog_dump to master_thread_id(20) slave_server(18), pos(, 4)
2018-03-20T04:36:39.434812Z 20 [Note] Start semi-sync binlog_dump to slave (server_id: 18), pos(, 4)
2018-03-20T04:36:40.209276Z 21 [Note] Start binlog_dump to master_thread_id(21) slave_server(17), pos(, 4)
2018-03-20T04:36:40.435941Z 21 [Note] Start semi-sync binlog_dump to slave (server_id: 17), pos(, 4)
2018-03-20T05:10:13.354065Z 0 [ERROR] /usr/sbin/mysqld: Got an error reading communication packets
2018-03-20T05:10:13.397767Z 21 [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply
2018-03-20T05:10:13.397856Z 21 [Note] Stop semi-sync binlog_dump to slave (server_id: 17)
2018-03-20T05:10:41.683900Z 940 [Note] While initializing dump thread for slave with UUID <8e24c946-2bf7-11e8-8f7e-000d3af9da0d>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(21).
2018-03-20T05:10:41.684016Z 940 [Note] Start binlog_dump to master_thread_id(940) slave_server(17), pos(, 4)
2018-03-20T05:10:43.563918Z 940 [Note] Start semi-sync binlog_dump to slave (server_id: 17), pos(, 4)
2018-03-20T05:27:38.163915Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4835ms. The settings might not be optimal. (flushed=94 and evicted=0, during the time.)
2018-03-20T06:12:50.178854Z 486 [Note] Aborted connection 486 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.178986Z 475 [Note] Aborted connection 475 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179091Z 468 [Note] Aborted connection 468 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179179Z 465 [Note] Aborted connection 465 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179397Z 474 [Note] Aborted connection 474 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179517Z 469 [Note] Aborted connection 469 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179615Z 466 [Note] Aborted connection 466 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179779Z 563 [Note] Aborted connection 563 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.179923Z 558 [Note] Aborted connection 558 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180014Z 553 [Note] Aborted connection 553 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180133Z 557 [Note] Aborted connection 557 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180262Z 559 [Note] Aborted connection 559 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180335Z 476 [Note] Aborted connection 476 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180438Z 561 [Note] Aborted connection 561 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180551Z 549 [Note] Aborted connection 549 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180627Z 555 [Note] Aborted connection 555 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180719Z 551 [Note] Aborted connection 551 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180767Z 554 [Note] Aborted connection 554 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.180809Z 548 [Note] Aborted connection 548 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181009Z 552 [Note] Aborted connection 552 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181065Z 550 [Note] Aborted connection 550 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181116Z 467 [Note] Aborted connection 467 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181161Z 546 [Note] Aborted connection 546 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181204Z 536 [Note] Aborted connection 536 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181264Z 545 [Note] Aborted connection 545 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181307Z 532 [Note] Aborted connection 532 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181369Z 533 [Note] Aborted connection 533 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181500Z 529 [Note] Aborted connection 529 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181549Z 535 [Note] Aborted connection 535 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181628Z 540 [Note] Aborted connection 540 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181673Z 531 [Note] Aborted connection 531 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181736Z 528 [Note] Aborted connection 528 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181783Z 525 [Note] Aborted connection 525 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181832Z 538 [Note] Aborted connection 538 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181877Z 524 [Note] Aborted connection 524 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181922Z 526 [Note] Aborted connection 526 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.181966Z 541 [Note] Aborted connection 541 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182027Z 523 [Note] Aborted connection 523 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182105Z 518 [Note] Aborted connection 518 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182166Z 521 [Note] Aborted connection 521 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182209Z 547 [Note] Aborted connection 547 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182269Z 534 [Note] Aborted connection 534 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182310Z 537 [Note] Aborted connection 537 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182353Z 516 [Note] Aborted connection 516 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182397Z 514 [Note] Aborted connection 514 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182450Z 515 [Note] Aborted connection 515 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182509Z 507 [Note] Aborted connection 507 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182593Z 522 [Note] Aborted connection 522 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182685Z 508 [Note] Aborted connection 508 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.182865Z 511 [Note] Aborted connection 511 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183010Z 512 [Note] Aborted connection 512 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183080Z 504 [Note] Aborted connection 504 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183148Z 510 [Note] Aborted connection 510 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183216Z 506 [Note] Aborted connection 506 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183285Z 509 [Note] Aborted connection 509 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183383Z 503 [Note] Aborted connection 503 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183495Z 513 [Note] Aborted connection 513 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183590Z 496 [Note] Aborted connection 496 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183668Z 499 [Note] Aborted connection 499 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183729Z 495 [Note] Aborted connection 495 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183789Z 500 [Note] Aborted connection 500 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183849Z 505 [Note] Aborted connection 505 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183926Z 493 [Note] Aborted connection 493 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.183988Z 492 [Note] Aborted connection 492 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184047Z 490 [Note] Aborted connection 490 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184106Z 488 [Note] Aborted connection 488 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184164Z 489 [Note] Aborted connection 489 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184277Z 484 [Note] Aborted connection 484 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184341Z 481 [Note] Aborted connection 481 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184458Z 491 [Note] Aborted connection 491 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184520Z 480 [Note] Aborted connection 480 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184583Z 478 [Note] Aborted connection 478 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184662Z 473 [Note] Aborted connection 473 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184727Z 470 [Note] Aborted connection 470 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184803Z 479 [Note] Aborted connection 479 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184863Z 483 [Note] Aborted connection 483 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.184923Z 477 [Note] Aborted connection 477 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.185043Z 464 [Note] Aborted connection 464 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.185103Z 487 [Note] Aborted connection 487 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets)
2018-03-20T06:12:50.189500Z 471 [Note] Aborted connection 471 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.189592Z 497 [Note] Aborted connection 497 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.189669Z 556 [Note] Aborted connection 556 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.189743Z 502 [Note] Aborted connection 502 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.189816Z 544 [Note] Aborted connection 544 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.189906Z 482 [Note] Aborted connection 482 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190012Z 472 [Note] Aborted connection 472 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190081Z 494 [Note] Aborted connection 494 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190149Z 539 [Note] Aborted connection 539 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190234Z 519 [Note] Aborted connection 519 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190320Z 501 [Note] Aborted connection 501 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190388Z 520 [Note] Aborted connection 520 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190474Z 517 [Note] Aborted connection 517 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190544Z 562 [Note] Aborted connection 562 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190628Z 542 [Note] Aborted connection 542 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190696Z 560 [Note] Aborted connection 560 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190766Z 498 [Note] Aborted connection 498 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190854Z 485 [Note] Aborted connection 485 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.190924Z 527 [Note] Aborted connection 527 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.191034Z 543 [Note] Aborted connection 543 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:12:50.236148Z 530 [Note] Aborted connection 530 to db: 'temp1' user: 'admin' host: '13.228.235.229' (Got an error writing communication packets)
2018-03-20T06:13:33.832427Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T06:13:33.843060Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 96141 ...
2018-03-20T06:13:33.853276Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T06:13:33.853341Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T06:13:33.853350Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T06:13:33.853361Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T06:13:33.853368Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T06:13:33.853375Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T06:13:33.855099Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T06:13:33.855869Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T06:13:33.873324Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T06:13:34.355725Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T06:13:34.429961Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T06:13:34.955372Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T06:13:35.030542Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 355444710
2018-03-20T06:13:35.030579Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 355444719
2018-03-20T06:13:35.079755Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 355444719
2018-03-20T06:13:35.079800Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-03-20T06:13:35.079809Z 0 [Note] InnoDB: Starting crash recovery.
2018-03-20T06:13:42.855053Z 0 [Note] InnoDB: Last MySQL binlog file position 0 352921108, file name mysql-bin.000001
2018-03-20T06:13:43.818353Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T06:13:43.818377Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T06:13:43.818425Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T06:13:43.928419Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T06:13:43.929378Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T06:13:43.929773Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T06:13:43.930157Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T06:13:43.980290Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9551ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-03-20T06:13:44.013525Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 355444719
2018-03-20T06:13:44.014060Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T06:13:44.018521Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T06:13:44.035855Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T06:13:44.036484Z 0 [Note] Recovering after a crash using mysql-bin
2018-03-20T06:13:44.810199Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  6:13:44
2018-03-20T06:14:02.038581Z 0 [Note] Starting crash recovery...
2018-03-20T06:14:02.038657Z 0 [Note] Crash recovery finished.
2018-03-20T06:15:25.066659Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T06:15:25.069822Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 3321 ...
2018-03-20T06:15:25.076301Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T06:15:25.076325Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T06:15:25.076332Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T06:15:25.076339Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T06:15:25.076345Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T06:15:25.076351Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T06:15:25.077142Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T06:15:25.077273Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T06:15:25.085215Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T06:15:25.253004Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T06:15:25.282352Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T06:15:25.794684Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T06:15:25.816206Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 355444754
2018-03-20T06:15:25.816238Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 355444763
2018-03-20T06:15:25.832303Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 355444763
2018-03-20T06:15:25.832323Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-03-20T06:15:25.832329Z 0 [Note] InnoDB: Starting crash recovery.
2018-03-20T06:15:30.930565Z 0 [Note] InnoDB: Last MySQL binlog file position 0 352921108, file name mysql-bin.000001
2018-03-20T06:15:31.097020Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T06:15:31.097042Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T06:15:31.097077Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T06:15:31.281654Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T06:15:31.282762Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T06:15:31.282776Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T06:15:31.283001Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T06:15:31.333157Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6051ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-03-20T06:15:31.369311Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 355444763
2018-03-20T06:15:31.369646Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T06:15:31.374493Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T06:15:31.452344Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T06:15:31.452484Z 0 [Note] Recovering after a crash using mysql-bin
2018-03-20T06:15:31.452496Z 0 [Note] Starting crash recovery...
2018-03-20T06:15:31.452518Z 0 [Note] Crash recovery finished.
2018-03-20T06:15:31.549891Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-03-20T06:15:31.550119Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-20T06:15:31.551377Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T06:15:31.551427Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T06:15:31.551460Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T06:15:31.729623Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:15:31.729687Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:15:31.818066Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:15:31.904971Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T06:15:31.905104Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T06:15:31.905113Z 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-03-20T06:15:31.905117Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T06:15:31.916267Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T06:15:31.969049Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  6:15:31
2018-03-20T06:16:16.409745Z 18 [Note] Semi-sync replication initialized for transactions.
2018-03-20T06:16:16.409759Z 18 [Note] Semi-sync replication enabled on the master.
2018-03-20T06:16:16.410468Z 0 [Note] Starting ack receiver thread
2018-03-20T06:38:51.428477Z 635 [Note] Aborted connection 635 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets)
2018-03-20T06:40:05.283816Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-03-20T06:40:05.283837Z 0 [Note] Shutting down slave threads
2018-03-20T06:40:05.283843Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-03-20T06:40:05.366346Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-03-20T06:40:05.493460Z 0 [Note] Binlog end
2018-03-20T06:40:05.574037Z 0 [Note] Shutting down plugin 'validate_password'
2018-03-20T06:40:05.612640Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2018-03-20T06:40:05.612663Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master'
2018-03-20T06:40:05.612688Z 0 [Note] Stopping ack receiver thread
2018-03-20T06:40:05.612947Z 0 [Note] unregister_replicator OK
2018-03-20T06:40:05.612960Z 0 [Note] Shutting down plugin 'ngram'
2018-03-20T06:40:05.612966Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-03-20T06:40:05.612972Z 0 [Note] Shutting down plugin 'partition'
2018-03-20T06:40:05.612978Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-03-20T06:40:05.612985Z 0 [Note] Shutting down plugin 'MyISAM'
2018-03-20T06:40:05.613013Z 0 [Note] Shutting down plugin 'CSV'
2018-03-20T06:40:05.613019Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-03-20T06:40:05.613041Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-03-20T06:40:05.613046Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-03-20T06:40:05.613067Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-03-20T06:40:05.613072Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-03-20T06:40:05.613077Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-03-20T06:40:05.613082Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-03-20T06:40:05.613086Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-03-20T06:40:05.613108Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-03-20T06:40:05.613112Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-03-20T06:40:05.613117Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-03-20T06:40:05.613121Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-03-20T06:40:05.613126Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-03-20T06:40:05.613130Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-03-20T06:40:05.613135Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-03-20T06:40:05.613140Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-03-20T06:40:05.613152Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-03-20T06:40:05.613157Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-03-20T06:40:05.613177Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-03-20T06:40:05.613181Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-03-20T06:40:05.613186Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-03-20T06:40:05.613190Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-03-20T06:40:05.613194Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-03-20T06:40:05.613199Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-03-20T06:40:05.613203Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-03-20T06:40:05.613207Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-03-20T06:40:05.613211Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-03-20T06:40:05.613216Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-03-20T06:40:05.613220Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-03-20T06:40:05.613224Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-03-20T06:40:05.613228Z 0 [Note] Shutting down plugin 'InnoDB'
2018-03-20T06:40:05.666599Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-03-20T06:40:05.666785Z 0 [Note] InnoDB: Starting shutdown...
2018-03-20T06:40:05.767094Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-03-20T06:40:05.877435Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180320  6:40:05
2018-03-20T06:40:07.961488Z 0 [Note] InnoDB: Shutdown completed; log sequence number 355445855
2018-03-20T06:40:07.961655Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T06:40:07.961683Z 0 [Note] Shutting down plugin 'MEMORY'
2018-03-20T06:40:07.961690Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-03-20T06:40:07.961733Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-03-20T06:40:07.961954Z 0 [Note] Shutting down plugin 'sha256_password'
2018-03-20T06:40:07.961963Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-03-20T06:40:07.962188Z 0 [Note] Shutting down plugin 'binlog'
2018-03-20T06:40:07.962888Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-03-20T06:40:35.966327Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T06:40:35.968266Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 23448 ...
2018-03-20T06:40:35.974299Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T06:40:35.974322Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T06:40:35.974332Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T06:40:35.974340Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T06:40:35.974346Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T06:40:35.974353Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T06:40:35.974864Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T06:40:35.975006Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T06:40:35.979554Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T06:40:36.163776Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T06:40:36.195821Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T06:40:36.497850Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T06:40:42.213928Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T06:40:42.214002Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T06:40:42.476616Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T06:40:42.477758Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T06:40:42.477772Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T06:40:42.478018Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T06:40:42.528205Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6333ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-03-20T06:40:42.551275Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 355445855
2018-03-20T06:40:42.551568Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T06:40:42.551774Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T06:40:42.864897Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T06:40:43.403573Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-03-20T06:40:43.472932Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-20T06:40:43.474360Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T06:40:43.474398Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T06:40:43.474445Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T06:40:43.755180Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:40:43.790269Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:40:44.293861Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:40:45.877559Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T06:40:45.877862Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T06:40:45.877874Z 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-03-20T06:40:45.877879Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T06:40:47.254306Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T06:40:51.375244Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  6:40:51
2018-03-20T06:41:28.332547Z 17 [Note] Semi-sync replication initialized for transactions.
2018-03-20T06:41:28.332568Z 17 [Note] Semi-sync replication enabled on the master.
2018-03-20T06:41:28.333804Z 0 [Note] Starting ack receiver thread
2018-03-20T06:45:42.662263Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-03-20T06:45:42.662282Z 0 [Note] Shutting down slave threads
2018-03-20T06:45:42.662287Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-03-20T06:45:42.662295Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-03-20T06:45:42.662537Z 0 [Note] Binlog end
2018-03-20T06:45:42.689391Z 0 [Note] Shutting down plugin 'validate_password'
2018-03-20T06:45:42.689421Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2018-03-20T06:45:42.689430Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master'
2018-03-20T06:45:42.689449Z 0 [Note] Stopping ack receiver thread
2018-03-20T06:45:42.689493Z 0 [Note] unregister_replicator OK
2018-03-20T06:45:42.689500Z 0 [Note] Shutting down plugin 'ngram'
2018-03-20T06:45:42.689505Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-03-20T06:45:42.689509Z 0 [Note] Shutting down plugin 'partition'
2018-03-20T06:45:42.689514Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-03-20T06:45:42.689519Z 0 [Note] Shutting down plugin 'MyISAM'
2018-03-20T06:45:42.689526Z 0 [Note] Shutting down plugin 'CSV'
2018-03-20T06:45:42.689531Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-03-20T06:45:42.689536Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-03-20T06:45:42.689546Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-03-20T06:45:42.689550Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-03-20T06:45:42.689554Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-03-20T06:45:42.689558Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-03-20T06:45:42.689562Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-03-20T06:45:42.689566Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-03-20T06:45:42.689569Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-03-20T06:45:42.689573Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-03-20T06:45:42.689577Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-03-20T06:45:42.689581Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-03-20T06:45:42.689584Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-03-20T06:45:42.689588Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-03-20T06:45:42.689592Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-03-20T06:45:42.689595Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-03-20T06:45:42.689599Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-03-20T06:45:42.689603Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-03-20T06:45:42.689607Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-03-20T06:45:42.689610Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-03-20T06:45:42.689614Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-03-20T06:45:42.689618Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-03-20T06:45:42.689621Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-03-20T06:45:42.689625Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-03-20T06:45:42.689629Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-03-20T06:45:42.689632Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-03-20T06:45:42.689636Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-03-20T06:45:42.689640Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-03-20T06:45:42.689644Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-03-20T06:45:42.689647Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-03-20T06:45:42.689651Z 0 [Note] Shutting down plugin 'InnoDB'
2018-03-20T06:45:42.689720Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-03-20T06:45:42.689816Z 0 [Note] InnoDB: Starting shutdown...
2018-03-20T06:45:42.790185Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool
2018-03-20T06:45:42.790374Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180320  6:45:42
2018-03-20T06:45:44.567519Z 0 [Note] InnoDB: Shutdown completed; log sequence number 355445883
2018-03-20T06:45:44.567699Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T06:45:44.567712Z 0 [Note] Shutting down plugin 'MEMORY'
2018-03-20T06:45:44.567720Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-03-20T06:45:44.567750Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-03-20T06:45:44.567763Z 0 [Note] Shutting down plugin 'sha256_password'
2018-03-20T06:45:44.567768Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-03-20T06:45:44.568002Z 0 [Note] Shutting down plugin 'binlog'
2018-03-20T06:45:44.569376Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-03-20T06:46:07.153704Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T06:46:07.155623Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-log) starting as process 27143 ...
2018-03-20T06:46:07.159546Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-03-20T06:46:07.159566Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-20T06:46:07.159572Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T06:46:07.159577Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-20T06:46:07.159582Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T06:46:07.159590Z 0 [Note] InnoDB: Using Linux native AIO
2018-03-20T06:46:07.160045Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T06:46:07.160182Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-03-20T06:46:07.167096Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-20T06:46:07.340114Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T06:46:07.372437Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-03-20T06:46:07.846311Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T06:46:12.003061Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T06:46:12.003771Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T06:46:12.178383Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-20T06:46:12.179332Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T06:46:12.179345Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T06:46:12.179602Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T06:46:12.229716Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4857ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-03-20T06:46:12.232747Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 355445883
2018-03-20T06:46:12.233100Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T06:46:12.237536Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool
mysqld: File '/var/log/mysql/var/log/mysql/mysql-slowquery.log' not found (Errcode: 2 - No such file or directory)
2018-03-20T06:46:12.373439Z 0 [ERROR] Could not use /var/log/mysql//var/log/mysql/mysql-slowquery.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-03-20T06:46:12.740456Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2018-03-20T06:46:12.740731Z 0 [Warning] CA certificate ca.pem is self signed.
2018-03-20T06:46:12.741949Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-03-20T06:46:12.741979Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2018-03-20T06:46:12.742008Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2018-03-20T06:46:12.862836Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:46:12.862893Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:46:13.049479Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-03-20T06:46:13.226669Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T06:46:13.226812Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2018-03-20T06:46:13.226822Z 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-03-20T06:46:13.226826Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-03-20T06:46:13.237224Z 0 [Note] End of list of non-natively partitioned tables
2018-03-20T06:46:15.123932Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320  6:46:15
2018-03-20T06:46:55.958844Z 17 [Note] Semi-sync replication initialized for transactions.
2018-03-20T06:46:55.958860Z 17 [Note] Semi-sync replication enabled on the master.
2018-03-20T06:46:55.959674Z 0 [Note] Starting ack receiver thread
2018-03-20T07:11:36.113337Z 548 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000005, pos: 310), semi-sync up to file , position 0.
2018-03-20T07:11:36.113389Z 548 [Note] Semi-sync replication switched OFF.