用myisamchk修复数据表如现如下错误,请问如何解决:
- recovering (with keycache) MyISAM-table '/usr/local/mysql/var/ok_bluesky/ok_log_tab.MYI'
Data records: 16402
Found link that points at 3978981063873790520 (outside data file) at 5226724
Found link that points at 3978981063873790520 (outside data file) at 5227108
Found link that points at 3546635495418167864 (outside data file) at 5228700
Found link that points at 3977573684695269944 (outside data file) at 5232476
Found link that points at 3977573684695269944 (outside data file) at 5232732
Found block with too small length at 5232844; Skipped
Found link that points at 3978981059712844344 (outside data file) at 5450804
Found link that points at 7161906714800907315 (outside data file) at 5451532
Found link that points at 8371422502050623347 (outside data file) at 5451688
Found link that points at 7089072688788745517 (outside data file) at 5451744
Found link that points at 8371422502050623347 (outside data file) at 5452024
Found link that points at 3255307777713450285 (outside data file) at 5452076
Found link that points at 4136102395879501101 (outside data file) at 5452180
Found link that points at 3255307777713450285 (outside data file) at 5452192
Found link that points at 4049971247778783536 (outside data file) at 5452292
Found link that points at 3255307777713450285 (outside data file) at 5452328
Found link that points at 3978981059712844344 (outside data file) at 5452468
Found link that points at 3978981059712844344 (outside data file) at 5452648
Found link that points at 3978981059712844344 (outside data file) at 5453176
Found link that points at 3978981059712844344 (outside data file) at 5453356
Found block with too small length at 5653824; Skipped
myisamchk: error: Not enough memory for blob at 5656088 (need 1903522412)
MyISAM-table '/usr/local/mysql/var/ok_bluesky/ok_log_tab.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag补充说明:
mysql版本是5.0.14 系统是linux.表是在系统断电的情况下出现的.
不知有没有人碰到这种问题,是如何解决的?
- recovering (with keycache) MyISAM-table '/usr/local/mysql/var/ok_bluesky/ok_log_tab.MYI'
Data records: 16402
Found link that points at 3978981063873790520 (outside data file) at 5226724
Found link that points at 3978981063873790520 (outside data file) at 5227108
Found link that points at 3546635495418167864 (outside data file) at 5228700
Found link that points at 3977573684695269944 (outside data file) at 5232476
Found link that points at 3977573684695269944 (outside data file) at 5232732
Found block with too small length at 5232844; Skipped
Found link that points at 3978981059712844344 (outside data file) at 5450804
Found link that points at 7161906714800907315 (outside data file) at 5451532
Found link that points at 8371422502050623347 (outside data file) at 5451688
Found link that points at 7089072688788745517 (outside data file) at 5451744
Found link that points at 8371422502050623347 (outside data file) at 5452024
Found link that points at 3255307777713450285 (outside data file) at 5452076
Found link that points at 4136102395879501101 (outside data file) at 5452180
Found link that points at 3255307777713450285 (outside data file) at 5452192
Found link that points at 4049971247778783536 (outside data file) at 5452292
Found link that points at 3255307777713450285 (outside data file) at 5452328
Found link that points at 3978981059712844344 (outside data file) at 5452468
Found link that points at 3978981059712844344 (outside data file) at 5452648
Found link that points at 3978981059712844344 (outside data file) at 5453176
Found link that points at 3978981059712844344 (outside data file) at 5453356
Found block with too small length at 5653824; Skipped
myisamchk: error: Not enough memory for blob at 5656088 (need 1903522412)
MyISAM-table '/usr/local/mysql/var/ok_bluesky/ok_log_tab.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag补充说明:
mysql版本是5.0.14 系统是linux.表是在系统断电的情况下出现的.
不知有没有人碰到这种问题,是如何解决的?
解决方案 »
- mysql驱动包,我如何用eclipse将它加入我的项目呢?
- mysql ID自增列,但是insert into 时,不填写ID列不行!填下去就显示重复!
- 我建立了customer的表,要约束输入是email 格式的值,不让他输入不符合的字符,该怎么弄?
- mysql中如何用mysqldump批量如何导出视图view啊?
- replace语句太可怕了,竟然会这样.
- 根据表中部分内容截取,更新其他字段
- 兄弟我是新手上路,请求各位帮助
- postgres如何查看数据库中的表有那些,如何查看数据表的结构
- 访问局域网内部mysql连接出错,在本地mysql连接却可以,为什么?
- PostgreSQL 支持 OBJECT 或是BINARY 类型字段吗?
- 紧急求助!mysql收回权限后任何机器都不能访问
- 请教这个sql语句的意思
如:shell> myisamchk --silent --force --fast --safe-recover \
-O key_buffer=64M -O sort_buffer=64M \
-O read_buffer=1M -O write_buffer=1M \
/path/to/datadir/*/*.MYI
从这里就可以看出内存不够了。在my.cnf或者my.ini里面:
将下面的值增大,试试看。
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M