MYSQL5.5.20 启动一段时间后出现访问不了,错误日志是这样的;请大神帮助

李枫华 发布于 2015/04/09 17:08
阅读 466
收藏 0
150409 16:18:00 [Note] Plugin 'FEDERATED' is disabled.
150409 16:18:00 InnoDB: The InnoDB memory heap is disabled
150409 16:18:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150409 16:18:00 InnoDB: Compressed tables use zlib 1.2.3
150409 16:18:00 InnoDB: Initializing buffer pool, size = 256.0M
150409 16:18:00 InnoDB: Completed initialization of buffer pool
150409 16:18:00 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150409 16:18:00  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...
150409 16:18:00  InnoDB: Waiting for the background threads to start
150409 16:18:01 InnoDB: 1.1.8 started; log sequence number 338117271
150409 16:18:01 [Note] Event Scheduler: Loaded 0 events
150409 16:18:01 [Note] E:\mysql\bin\mysqld: ready for connections.
Version: '5.5.20'  socket: ''  port: 3320  MySQL Community Server (GPL)
150409 16:18:44 [Note] Plugin 'FEDERATED' is disabled.
150409 16:18:44 InnoDB: The InnoDB memory heap is disabled
150409 16:18:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150409 16:18:44 InnoDB: Compressed tables use zlib 1.2.3
150409 16:18:44 InnoDB: Initializing buffer pool, size = 256.0M
150409 16:18:45 InnoDB: Completed initialization of buffer pool
150409 16:18:45 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150409 16:18: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...
150409 16:18:45  InnoDB: Waiting for the background threads to start
150409 16:18:46 InnoDB: 1.1.8 started; log sequence number 338122110
150409 16:18:46 [Note] Event Scheduler: Loaded 0 events
150409 16:18:46 [Note] E:\mysql\bin\mysqld: ready for connections.
Version: '5.5.20'  socket: ''  port: 3320  MySQL Community Server (GPL)

以下是问题补充:

@李枫华:网络上的各种方法也试过,但是还是解决不了这个问题; (2015/04/09 17:09)
加载中
0
clouddyy
clouddyy
貌似你的表有问题,看看能不能定位是哪张表,修复一下
clouddyy
clouddyy
回复 @李枫华 : 能把数据导出来么,重新建表,再导回去试试?
李枫华
~~~修复过了表啊; 还是不行哦; 为什么; 疯掉了;
返回顶部
顶部