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重要的是我修复后,表过一段时间还是会错! 搞过几次了 一直不能根治!!
求助
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'
这是错误前后的日志!!