错误日志:
131019 14:00:54 [Note] Plugin 'FEDERATED' is disabled.
131019 14:00:54 InnoDB: Initializing buffer pool, size = 40.0M
131019 14:00:54 InnoDB: Completed initialization of buffer pool
131019 14:00:54 InnoDB: Started; log sequence number 0 179746
131019 14:00:59 [Note] Event Scheduler: Loaded 0 events
131019 14:00:59 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.62-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
131019 14:01:45 InnoDB: MySQL and InnoDB data dictionaries are out of sync.
InnoDB: Unable to find the AUTOINC column Id in the InnoDB table lake/admin.
InnoDB: We set the next AUTOINC column value to 0,
InnoDB: in effect disabling the AUTOINC next value generation.
InnoDB: You can either set the next AUTOINC value explicitly using ALTER TABLE
InnoDB: or fix the data dictionary by recreating the table.
131019 14:01:45 InnoDB: Assertion failure in thread 4944 in file .\handler\ha_innodb.cc line 8246
InnoDB: Failing assertion: auto_inc > 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 3604 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 3600 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 6064 stopped in file .\mem\mem0pool.c line 337 环境: Windows7 32位旗舰版.
出错原因,使用SQLyog随便选张表编辑,然后 MySQL服务就自动停止了...
求解决方法啊,
服务 MySQL 意外停止。这发生了 27 次。
(这是Windows的错误日志信息. 27次啊~~~~~)