mysql 暂停_mysql 启动时暂停

mysql启动时都会很久才启动，系统日志里提示说是“MySQL服务在启动时暂停”。一般过十分钟才正常启动。查看mysql系统日志如下11040623:49:40[Note]Plugin'FEDERATED'isdisabled.InnoD...

mysql启动时都会很久才启动，系统日志里提示说是“MySQL 服务在启动时暂停”。一般过十分钟才正常启动。

查看mysql系统日志如下

110406 23:49:40 [Note] Plugin 'FEDERATED' is disabled.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

110406 23:49:45 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

110406 23:49:51 InnoDB: Started; log sequence number 0 137046

110407 0:00:13 [Note] Event Scheduler: Loaded 0 events

110407 0:00:13 [Note] D:\MySQL Server\bin\mysqld: ready for connections.

Version: '5.1.51-community' socket: '' port: 3306 MySQL Community Server (GPL)

展开