check table 后Keypointers and record positions doesn't match
Found 101 keys of 527
Corrupt
Key 3 doesn't point at same records that key 1
size of indexfile is: 8192 Should be: 10240重要的是我修复后,表过一段时间还是会错! 搞过几次了 一直不能根治!!
求助
Found 101 keys of 527
Corrupt
Key 3 doesn't point at same records that key 1
size of indexfile is: 8192 Should be: 10240重要的是我修复后,表过一段时间还是会错! 搞过几次了 一直不能根治!!
求助
解决方案 »
- Input string was not in a correct format.
- select语句出错,求教
- 求救高人!INSERT command denied to user 'mydb'@'192.1.169.2'
- mysql table 'user' read only
- 问个linux下mysql自动启动的问题
- mysql乱码
- mysql数据库是什么
- mysql 如何 算出 时间段 里面的周末
- Mysql 存储过程中 变量赋值问题
- 程序运行中,MySQL弹出一个taskeng.exe。不知道是怎么回事?
- mysql中data下数据还原
- select时添加自增的编号(就像oracle中的rowid,rownum) 急!急!急!
31181 121025 11:04:07 mysqld_safe mysqld restarted
31182 121025 11:19:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
31183 121025 11:19:36 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
31184 121025 11:19:36 [Note] Plugin 'FEDERATED' is disabled.
31185 121025 11:19:36 InnoDB: Initializing buffer pool, size = 8.0M
31186 121025 11:19:36 InnoDB: Completed initialization of buffer pool
31187 InnoDB: The log sequence number in ibdata files does not match
31188 InnoDB: the log sequence number in the ib_logfiles!
31189 121025 11:19:36 InnoDB: Database was not shut down normally!
31190 InnoDB: Starting crash recovery.
31191 InnoDB: Reading tablespace information from the .ibd files...
31192 InnoDB: Restoring possible half-written data pages from the doublewrite
31193 InnoDB: buffer...
31194 InnoDB: Last MySQL binlog file position 0 19755756, file name ./mysql-bin.000047
31195 121025 11:19:36 InnoDB: Started; log sequence number 0 278007475
31196 121025 11:19:37 [Note] Recovering after a crash using mysql-bin
31197 121025 11:19:37 [Note] Starting crash recovery...
31198 121025 11:19:37 [Note] Crash recovery finished.
31199 121025 11:19:37 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is ed as crashed and should be repaired 31201 121025 11:19:37 [ERROR] 1 client is using or hasn't closed the table properly
31202 121025 11:19:37 [Note] Event Scheduler: Loaded 0 events
31203 121025 11:19:37 [Note] /usr/sbin/mysqld: ready for connections.
31204 Version: '5.1.65-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
31205 121025 11:19:49 [ERROR] /usr/sbin/mysqld: Table './cphulkd/auths' is ed as crashed and should be repaired
31206 121025 11:19:49 [Warning] Checking table: './cphulkd/auths'
31207 121025 11:19:49 [ERROR] /usr/sbin/mysqld: Table './cphulkd/logins' is ed as crashed and should be repaired
31208 121025 11:19:49 [Warning] Checking table: './cphulkd/logins'
31209 121025 11:19:50 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is ed as crashed and should be repaired
31210 121025 11:19:50 [Warning] Checking table: './eximstats/sends'
31211 121025 11:19:51 [ERROR] /usr/sbin/mysqld: Table './witdeals_main/sessions' is ed as crashed and should be re paired
31212 121025 11:19:51 [Warning] Checking table: './witdeals_main/sessions'
31213 121025 11:19:53 [ERROR] /usr/sbin/mysqld: Table './witdeals_main/specials' is ed as crashed and should be re paired
31214 121025 11:19:53 [Warning] Checking table: './witdeals_main/specials'
31215 121025 11:19:53 [ERROR] /usr/sbin/mysqld: Table './witdeals_main/featured' is ed as crashed and should be re paired
31216 121025 11:19:53 [Warning] Checking table: './witdeals_main/featured'
31217 121025 11:19:53 [ERROR] /usr/sbin/mysqld: Table './witdeals_main/categories_description' is ed as crashed an d should be repaired
31218 121025 11:19:53 [Warning] Checking table: './witdeals_main/categories_description'
这是错误前后的日志!!