mysql start overlaps examplpe: 2018-05-17T00:45:09.249344Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 45666 ... 2018-05-17T00:45:09.257033Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-17T00:45:09.257063Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-17T00:45:09.257078Z 0 [Note] InnoDB: Uses event mutexes 2018-05-17T00:45:09.257092Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-17T00:45:09.257106Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-17T00:45:09.257117Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-17T00:45:09.257515Z 0 [Note] InnoDB: Number of pools: 1 2018-05-17T00:45:09.257705Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-17T00:45:09.265110Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-17T00:45:09.279892Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-17T00:45:09.282899Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-17T00:45:09.549613Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-17T00:45:09.859161Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 4674921 2018-05-17T00:45:15.644083Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 9917440 2018-05-17T00:45:16.179439Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 15160320 2018-05-17T00:45:16.515200Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20403200 2018-05-17T00:45:16.676545Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 23013288 2018-05-17T00:45:16.678153Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-05-17T00:45:16.678172Z 0 [Note] InnoDB: Starting crash recovery. 2018-05-17T00:45:24.287895Z 0 [Note] InnoDB: Transaction 71922 was in the XA prepared state. 2018-05-17T00:45:24.429543Z 0 [Note] InnoDB: Transaction 71923 was in the XA prepared state. 2018-05-17T00:45:24.429589Z 0 [Note] InnoDB: Transaction 71925 was in the XA prepared state. 2018-05-17T00:45:24.429615Z 0 [Note] InnoDB: 3 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2018-05-17T00:45:24.429634Z 0 [Note] InnoDB: Trx id counter is 72192 2018-05-17T00:45:24.430100Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2018-05-17T00:45:25.440504Z 0 [Note] InnoDB: Apply batch completed 2018-05-17T00:45:25.440535Z 0 [Note] InnoDB: Last MySQL binlog file position 0 13813876, file name mysql-bin.000002 2018-05-17T00:45:26.785328Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-05-17T00:45:26.785371Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-17T00:45:26.785429Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-17T00:45:26.785681Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2018-05-17T00:45:26.785713Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-05-17T00:45:27.839090Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-17T00:45:27.840205Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-17T00:45:27.840225Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-17T00:45:27.840571Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-17T00:45:27.890806Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 23013288 2018-05-17T00:45:27.891222Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-05-17T00:45:27.892329Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18610ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2018-05-17T00:45:27.896409Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-17T00:45:28.403854Z 0 [Note] Recovering after a crash using mysql-bin 2018-05-17T00:45:29.228007Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180517 0:45:29 2018-05-17T00:45:36.974372Z 0 [Note] Starting crash recovery... 2018-05-17T00:45:36.974451Z 0 [Note] InnoDB: Starting recovery for XA transactions... 2018-05-17T00:45:36.974467Z 0 [Note] InnoDB: Transaction 71925 in prepared state after recovery 2018-05-17T00:45:36.974478Z 0 [Note] InnoDB: Transaction contains changes to 1 rows 2018-05-17T00:45:36.974492Z 0 [Note] InnoDB: Transaction 71923 in prepared state after recovery 2018-05-17T00:45:36.974502Z 0 [Note] InnoDB: Transaction contains changes to 1 rows 2018-05-17T00:45:36.974512Z 0 [Note] InnoDB: Transaction 71922 in prepared state after recovery 2018-05-17T00:45:36.974522Z 0 [Note] InnoDB: Transaction contains changes to 1 rows 2018-05-17T00:45:36.974533Z 0 [Note] InnoDB: 3 transactions in prepared state after recovery 2018-05-17T00:45:36.974543Z 0 [Note] Found 3 prepared transaction(s) in InnoDB 2018-05-17T00:45:37.024811Z 0 [Note] Crash recovery finished. 2018-05-17T00:46:39.864962Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-05-17T00:46:39.867549Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 91035 ... 2018-05-17T00:46:39.872895Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-17T00:46:39.872926Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-17T00:46:39.872942Z 0 [Note] InnoDB: Uses event mutexes 2018-05-17T00:46:39.872956Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-17T00:46:39.872967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-17T00:46:39.872982Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-17T00:46:39.873405Z 0 [Note] InnoDB: Number of pools: 1 2018-05-17T00:46:39.873634Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-17T00:46:39.881151Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-17T00:46:39.896086Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-17T00:46:39.899198Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-17T00:46:40.284908Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-17T00:46:40.392394Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 23013726 2018-05-17T00:46:40.392428Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 23013950 2018-05-17T00:46:40.392468Z 0 [Note] InnoDB: Database was not shutdown normally! 2018-05-17T00:46:40.392479Z 0 [Note] InnoDB: Starting crash recovery. 2018-05-17T00:46:42.336254Z 0 [Note] InnoDB: Last MySQL binlog file position 0 13813876, file name mysql-bin.000002 2018-05-17T00:46:42.747340Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-05-17T00:46:42.747374Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-17T00:46:42.747429Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-17T00:46:43.793431Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-17T00:46:43.794692Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-17T00:46:43.794711Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-17T00:46:43.794996Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-17T00:46:43.849880Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 23013950 2018-05-17T00:46:43.855419Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-17T00:46:43.984095Z 0 [Note] Recovering after a crash using mysql-bin 2018-05-17T00:46:43.984116Z 0 [Note] Starting crash recovery... 2018-05-17T00:46:43.984148Z 0 [Note] Crash recovery finished. 2018-05-17T00:46:44.117061Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-05-17T00:46:44.188437Z 0 [Warning] CA certificate ca.pem is self signed. 2018-05-17T00:46:44.239931Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-17T00:46:44.239982Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-17T00:46:44.240024Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-17T00:46:44.353519Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.353585Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.353630Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.353641Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.479093Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.479121Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-17T00:46:44.577822Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180517 0:46:44 2018-05-17T00:46:45.154984Z 0 [Note] Event Scheduler: Loaded 0 events 2018-05-17T00:46:45.155174Z 0 [Note] /usr/sbin/mysqld: ready for connections.