- 积分
- 10
- 威望
-
- 金钱
-
- 注册时间
- 2014-3-11
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
楼主 |
发表于 2014-3-30 10:52:35
|
显示全部楼层
原帖由 licess 于 2014-3-30 09:08 发表
关闭的是二进制日志,不是日志,日志是记录错误信息的
我的数据库表是MyISAM的,四百个小站共用103fanci/mydecms_item这个表。
-
- 140330 10:38:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
- 140330 10:38:46 InnoDB: The InnoDB memory heap is disabled
- 140330 10:38:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 140330 10:38:46 InnoDB: Compressed tables use zlib 1.2.3
- 140330 10:38:46 InnoDB: Initializing buffer pool, size = 16.0M
- 140330 10:38:46 InnoDB: Completed initialization of buffer pool
- 140330 10:38:46 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!
- 140330 10:38:46 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...
- InnoDB: 13 transaction(s) which must be rolled back or cleaned up
- InnoDB: in total 13 row operations to undo
- InnoDB: Trx id counter is E84F00
- InnoDB: Last MySQL binlog file position 0 494744242, file name ./mysql-bin.000068
- InnoDB: Starting in background the rollback of uncommitted transactions
- 140330 10:39:16 InnoDB: Rolling back trx with id E845A9, 1 rows to undo
- 140330 10:39:16 InnoDB: Waiting for the background threads to start
- InnoDB: Rolling back of trx id E845A9 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E84468, 1 rows to undo
- InnoDB: Rolling back of trx id E84468 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E843C6, 1 rows to undo
- InnoDB: Rolling back of trx id E843C6 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E843AB, 1 rows to undo
- InnoDB: Rolling back of trx id E843AB completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E84328, 1 rows to undo
- InnoDB: Rolling back of trx id E84328 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E8420A, 1 rows to undo
- InnoDB: Rolling back of trx id E8420A completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E840F8, 1 rows to undo
- InnoDB: Rolling back of trx id E840F8 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E840EB, 1 rows to undo
- InnoDB: Rolling back of trx id E840EB completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E84043, 1 rows to undo
- InnoDB: Rolling back of trx id E84043 completed
- 140330 10:39:16 InnoDB: Rolling back trx with id E84015, 1 rows to undo
- InnoDB: Rolling back of trx id E84015 completed
- 140330 10:39:17 InnoDB: Rolling back trx with id E83F8A, 1 rows to undo
- 140330 10:39:17 InnoDB: 1.1.8 started; log sequence number 83787785563
- 140330 10:39:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 140330 10:39:17 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 140330 10:39:17 [Note] Server socket created on IP: '0.0.0.0'.
- InnoDB: Rolling back of trx id E83F8A completed
- 140330 10:39:17 InnoDB: Rolling back trx with id E83F61, 1 rows to undo
- 140330 10:39:17 [Note] Event Scheduler: Loaded 0 events
- 140330 10:39:17 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
- Version: '5.5.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution
- InnoDB: Rolling back of trx id E83F61 completed
- 140330 10:39:17 InnoDB: Rolling back trx with id E83F30, 1 rows to undo
- InnoDB: Rolling back of trx id E83F30 completed
- 140330 10:39:17 InnoDB: Rollback of non-prepared transactions completed
- 140330 10:39:20 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:20 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:20 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:21 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:22 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:23 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:23 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:26 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
- 140330 10:39:27 [ERROR] /usr/local/mysql/bin/mysqld: Table './103fanci/mydecms_item' is marked as crashed and last (automatic?) repair failed
复制代码 |
|