2017-08-01T13:53:10.931436Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-08-01T13:53:10.931518Z 0 [Note] Shutting down slave threads
2017-08-01T13:53:10.931530Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-08-01T13:53:10.931547Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-08-01T13:53:10.938932Z 0 [Note] Binlog end
2017-08-01T13:53:10.944594Z 0 [Note] Shutting down plugin 'validate_password'
2017-08-01T13:53:10.944642Z 0 [Note] Shutting down plugin 'auth_socket'
2017-08-01T13:53:10.944650Z 0 [Note] Shutting down plugin 'ngram'
2017-08-01T13:53:10.944655Z 0 [Note] Shutting down plugin 'partition'
2017-08-01T13:53:10.944661Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-08-01T13:53:10.944667Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-08-01T13:53:10.944672Z 0 [Note] Shutting down plugin 'CSV'
2017-08-01T13:53:10.944683Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-08-01T13:53:10.944689Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-08-01T13:53:10.944694Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-08-01T13:53:10.944699Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-08-01T13:53:10.944703Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-08-01T13:53:10.944708Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-08-01T13:53:10.944713Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-08-01T13:53:10.944717Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-08-01T13:53:10.944722Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-08-01T13:53:10.944726Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-08-01T13:53:10.944731Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-08-01T13:53:10.944735Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-08-01T13:53:10.944740Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-08-01T13:53:10.944744Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-08-01T13:53:10.944749Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-08-01T13:53:10.944753Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-08-01T13:53:10.944758Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-08-01T13:53:10.944762Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-08-01T13:53:10.944767Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-08-01T13:53:10.944771Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-08-01T13:53:10.944776Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-08-01T13:53:10.944780Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-08-01T13:53:10.944785Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-08-01T13:53:10.944790Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-08-01T13:53:10.944794Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-08-01T13:53:10.944799Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-08-01T13:53:10.944803Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-08-01T13:53:10.944808Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-08-01T13:53:10.944812Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-08-01T13:53:10.944817Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-08-01T13:53:10.944821Z 0 [Note] Shutting down plugin 'InnoDB'
2017-08-01T13:53:10.944946Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-08-01T13:53:10.945163Z 0 [Note] InnoDB: Starting shutdown...
2017-08-01T13:53:11.045591Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-08-01T13:53:11.046129Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170801 14:53:11
2017-08-01T13:53:12.161383Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2959955
2017-08-01T13:53:12.165051Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-08-01T13:53:12.165080Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-08-01T13:53:12.165129Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-08-01T13:53:12.165136Z 0 [Note] Shutting down plugin 'MyISAM'
2017-08-01T13:53:12.165162Z 0 [Note] Shutting down plugin 'MEMORY'
2017-08-01T13:53:12.165191Z 0 [Note] Shutting down plugin 'sha256_password'
2017-08-01T13:53:12.165197Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-08-01T13:53:12.165779Z 0 [Note] Shutting down plugin 'binlog'
2017-08-01T13:53:12.166713Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-08-01T14:17:41.339635Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-08-01T14:17:41.339780Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-08-01T14:17:41.503893Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-08-01T14:17:41.505560Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.16.04.1) starting as process 9240 ...
2017-08-01T14:17:41.510015Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-08-01T14:17:41.510040Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-01T14:17:41.510050Z 0 [Note] InnoDB: Uses event mutexes
2017-08-01T14:17:41.510055Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-08-01T14:17:41.510059Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-08-01T14:17:41.510064Z 0 [Note] InnoDB: Using Linux native AIO
2017-08-01T14:17:41.510335Z 0 [Note] InnoDB: Number of pools: 1
2017-08-01T14:17:41.510458Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-08-01T14:17:41.512095Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-08-01T14:17:41.520390Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-08-01T14:17:41.522535Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-08-01T14:17:41.534374Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-01T14:17:41.543432Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-08-01T14:17:41.543504Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-08-01T14:17:41.567051Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-08-01T14:17:41.567855Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-08-01T14:17:41.567868Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-08-01T14:17:41.569355Z 0 [Note] InnoDB: Waiting for purge to start
2017-08-01T14:17:41.619625Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2959955
2017-08-01T14:17:41.619866Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-08-01T14:17:41.620085Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-08-01T14:17:41.621291Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170801 15:17:41
2017-08-01T14:17:41.626711Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-08-01T14:17:41.626742Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-08-01T14:17:41.626759Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-08-01T14:17:41.626812Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-08-01T14:17:41.639908Z 0 [Note] Event Scheduler: Loaded 0 events
2017-08-01T14:17:41.640203Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2017-08-01T14:17:41.640229Z 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. 
2017-08-01T14:17:41.640235Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-08-01T14:17:41.662297Z 0 [Note] End of list of non-natively partitioned tables