5.7.9

- 1st run: ignored
- 2nd run: 00:02:47
- 3rd run: 00:02:52
- 4th run: 00:02:47

Startup log for runs 2 through 4 pasted below:

##

root@ip-172-31-13-38:~# ./run_mysql.sh 5.7.9
2015-12-19T12:44:07.471116Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-19T12:44:07.473516Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-12-19T12:44:07.473923Z 0 [Note] bin/mysqld (mysqld 5.7.9) starting as process 2426 ...
2015-12-19T12:44:07.501871Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2015-12-19T12:44:07.504310Z 0 [Note] InnoDB: PUNCH HOLE support available
2015-12-19T12:44:07.504353Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-19T12:44:07.504414Z 0 [Note] InnoDB: Uses event mutexes
2015-12-19T12:44:07.504451Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2015-12-19T12:44:07.504487Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-19T12:44:07.506609Z 0 [Note] InnoDB: Number of pools: 1
2015-12-19T12:44:07.510640Z 0 [Note] InnoDB: Using CPU crc32 instructions
2015-12-19T12:44:07.516667Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 4, chunk size = 128M
2015-12-19T12:44:07.757748Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-12-19T12:44:07.819411Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2015-12-19T12:44:07.839474Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-19T12:44:07.889643Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1244299166
2015-12-19T12:44:07.889668Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299185
2015-12-19T12:44:07.933076Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299185
2015-12-19T12:44:07.933589Z 0 [Note] InnoDB: Database was not shutdown normally!
2015-12-19T12:44:07.933608Z 0 [Note] InnoDB: Starting crash recovery.
2015-12-19T12:46:54.806633Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2015-12-19T12:46:54.806679Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-12-19T12:46:54.806731Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-12-19T12:46:54.836363Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2015-12-19T12:46:54.853839Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-12-19T12:46:54.853889Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-12-19T12:46:54.854446Z 0 [Note] InnoDB: Waiting for purge to start
2015-12-19T12:46:54.904640Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 167085ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-12-19T12:46:54.904642Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1244299185
2015-12-19T12:46:54.904924Z 0 [Note] InnoDB: not started
2015-12-19T12:46:54.905577Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-12-19T12:46:54.916483Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-12-19T12:46:54.916508Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 5709
2015-12-19T12:46:54.916590Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-12-19T12:46:54.916615Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2015-12-19T12:46:54.981456Z 0 [Note] Event Scheduler: Loaded 0 events
2015-12-19T12:46:54.981601Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.9'  socket: '/tmp/mysql-5.7.9.sock'  port: 5709  Source distribution

##

root@ip-172-31-13-38:~# ./run_mysql.sh 5.7.9
2015-12-19T12:49:25.919643Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-19T12:49:25.921996Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-12-19T12:49:25.922710Z 0 [Note] bin/mysqld (mysqld 5.7.9) starting as process 2499 ...
2015-12-19T12:49:25.951535Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2015-12-19T12:49:25.953901Z 0 [Note] InnoDB: PUNCH HOLE support available
2015-12-19T12:49:25.953923Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-19T12:49:25.953940Z 0 [Note] InnoDB: Uses event mutexes
2015-12-19T12:49:25.953949Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2015-12-19T12:49:25.953959Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-19T12:49:25.956170Z 0 [Note] InnoDB: Number of pools: 1
2015-12-19T12:49:25.960291Z 0 [Note] InnoDB: Using CPU crc32 instructions
2015-12-19T12:49:25.966348Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 4, chunk size = 128M
2015-12-19T12:49:26.204663Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-12-19T12:49:26.263887Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2015-12-19T12:49:26.284521Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-19T12:49:26.334879Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1244299213
2015-12-19T12:49:26.334904Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299232
2015-12-19T12:49:26.378068Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299232
2015-12-19T12:49:26.378591Z 0 [Note] InnoDB: Database was not shutdown normally!
2015-12-19T12:49:26.378622Z 0 [Note] InnoDB: Starting crash recovery.
2015-12-19T12:52:16.826424Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2015-12-19T12:52:16.826469Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-12-19T12:52:16.826521Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-12-19T12:52:16.856966Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2015-12-19T12:52:16.874415Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-12-19T12:52:16.874461Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-12-19T12:52:16.875172Z 0 [Note] InnoDB: Waiting for purge to start
2015-12-19T12:52:16.925349Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 170662ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-12-19T12:52:16.925355Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1244299232
2015-12-19T12:52:16.925664Z 0 [Note] InnoDB: not started
2015-12-19T12:52:16.926669Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-12-19T12:52:16.941430Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-12-19T12:52:16.941454Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 5709
2015-12-19T12:52:16.941534Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-12-19T12:52:16.941558Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2015-12-19T12:52:17.006115Z 0 [Note] Event Scheduler: Loaded 0 events
2015-12-19T12:52:17.006262Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.9'  socket: '/tmp/mysql-5.7.9.sock'  port: 5709  Source distribution

##

root@ip-172-31-13-38:~# ./run_mysql.sh 5.7.9
2015-12-19T12:53:58.331542Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-19T12:53:58.334635Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-12-19T12:53:58.335405Z 0 [Note] bin/mysqld (mysqld 5.7.9) starting as process 2569 ...
2015-12-19T12:53:58.365257Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
2015-12-19T12:53:58.367553Z 0 [Note] InnoDB: PUNCH HOLE support available
2015-12-19T12:53:58.367598Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-19T12:53:58.367648Z 0 [Note] InnoDB: Uses event mutexes
2015-12-19T12:53:58.367688Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2015-12-19T12:53:58.367712Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-19T12:53:58.370046Z 0 [Note] InnoDB: Number of pools: 1
2015-12-19T12:53:58.373890Z 0 [Note] InnoDB: Using CPU crc32 instructions
2015-12-19T12:53:58.379822Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 4, chunk size = 128M
2015-12-19T12:53:58.621401Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-12-19T12:53:58.680750Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2015-12-19T12:53:58.701593Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-19T12:53:58.752118Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1244299285
2015-12-19T12:53:58.752143Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299304
2015-12-19T12:53:58.795329Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1244299304
2015-12-19T12:53:58.795924Z 0 [Note] InnoDB: Database was not shutdown normally!
2015-12-19T12:53:58.795941Z 0 [Note] InnoDB: Starting crash recovery.
2015-12-19T12:56:45.055354Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2015-12-19T12:56:45.055400Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-12-19T12:56:45.055450Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-12-19T12:56:45.085615Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2015-12-19T12:56:45.103115Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-12-19T12:56:45.103163Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-12-19T12:56:45.103793Z 0 [Note] InnoDB: Waiting for purge to start
2015-12-19T12:56:45.154005Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 166473ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-12-19T12:56:45.154011Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1244299304
2015-12-19T12:56:45.154448Z 0 [Note] InnoDB: not started
2015-12-19T12:56:45.155373Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-12-19T12:56:45.168749Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-12-19T12:56:45.168773Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 5709
2015-12-19T12:56:45.168849Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-12-19T12:56:45.168879Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2015-12-19T12:56:45.232786Z 0 [Note] Event Scheduler: Loaded 0 events
2015-12-19T12:56:45.232932Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.9'  socket: '/tmp/mysql-5.7.9.sock'  port: 5709  Source distribution