启动MySQL问题

[weixin_38824277]

MySQL里的ib_logfile必须删除掉才能启动数据库服务,否则每隔一段时间数据库服务就不能启动，这是什么原因导致的呢？？？

[OwenZeng_DBA]

不能启动的时候看错误日志，把日志发上来

[二月十六]

删除这个文件的方法是从哪得到的?

[weixin_38824277]

2018-06-24T02:31:10.915760Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-06-24T02:31:11.197002Z 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.
2018-06-24T02:31:11.212627Z 0 [Note] MySQL (mysqld 5.7.11) starting as process 2888 ...
2018-06-24T02:31:11.712611Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2018-06-24T02:31:11.728236Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-06-24T02:31:11.743857Z 0 [Note] InnoDB: Uses event mutexes
2018-06-24T02:31:11.743857Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-06-24T02:31:11.743857Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-06-24T02:31:11.759485Z 0 [Note] InnoDB: Number of pools: 1
2018-06-24T02:31:11.759485Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-06-24T02:31:11.837614Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-06-24T02:31:11.837614Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-06-24T02:31:11.931371Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-24T02:31:11.946981Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 5020796
2018-06-24T02:31:11.946981Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5020805
2018-06-24T02:31:11.946981Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5020805
2018-06-24T02:31:11.946981Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-06-24T02:31:11.946981Z 0 [Note] InnoDB: Starting crash recovery.
2018-06-24T02:31:15.524987Z 0 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=5020814
2018-06-24T02:31:15.774990Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-06-24T02:31:15.790594Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2018-06-24T02:31:16.509320Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2018-06-24T02:31:17.228066Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2018-06-24T02:31:17.228066Z 0 [Warning] InnoDB: New log files created, LSN=5020814
2018-06-24T02:31:17.540556Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-06-24T02:31:17.540556Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-06-24T02:31:17.571804Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-06-24T02:31:17.899918Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-06-24T02:31:17.899918Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-06-24T02:31:17.899918Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-06-24T02:31:17.899918Z 0 [Note] InnoDB: Waiting for purge to start
2018-06-24T02:31:17.978041Z 0 [Note] InnoDB: Waiting for purge to start
2018-06-24T02:31:18.040523Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6187ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-06-24T02:31:18.056163Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 5020805
2018-06-24T02:31:18.118661Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\wampserver3.0.4\wamp64\bin\mysql\mysql5.7.11\data\ib_buffer_pool
2018-06-24T02:31:18.134269Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-06-24T02:31:18.696768Z 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-06-24T02:31:18.696768Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-06-24T02:31:18.696768Z 0 [Note] IPv6 is available.
2018-06-24T02:31:18.696768Z 0 [Note] - '::' resolves to '::';
2018-06-24T02:31:18.696768Z 0 [Note] Server socket created on IP: '::'.
2018-06-24T02:31:18.806117Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180624 10:31:18
2018-06-24T02:31:20.250144Z 0 [Note] Event Scheduler: Loaded 1 event
2018-06-24T02:31:20.250144Z 0 [Note] MySQL: ready for connections.
Version: '5.7.11' socket: '' port: 3306 MySQL Community Server (GPL)

[zjcxc]

你这是正常日志吧，最后面不是已经提示 ready 了么？

2018-06-24T02:31:20.250144Z 0 [Note] MySQL: ready for connections.
Version: '5.7.11' socket: '' port: 3306 MySQL Community Server (GPL)

[jinsenhome]

1）mysql 异常关闭，innodb引擎的log日志损坏（上次异常关闭，事务日志并未完全写入硬盘中的日志文件）
2）上次关闭时有大量的未完成事务