当遇到'MySQL Table is marked as crashed and should be repaired'的错误时，可以按照以下步骤进行修复：1. 停止MySQL服务；2. 使用myisamchk工具尝试-r和-f选项修复；3. 如果遇到myisam_sort_buffer_size过小的问题，可以通过增加排序缓存大小解决。通过这些操作，成功修复了数据库表。
程序报错
Table '.xxxx' is marked as crashed and should be repaired
1.首先关闭mysql服务
service stop mysql
2.使用mysiamchk修复
root@10-10-74-251:/data/mysql_data/cmd5# myisamchk -r -f t_counter.MYI
– recovering (with sort) MyISAM-table ‘t_counter.MYI’Data records: 0
– Fixing index 1
myisamchk: error: myisam_sort_buffer_size is too small
MyISAM-table ‘md5_core.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
myisamchk -r -f t_counter.MYI --s
3.修复时发现报: myisam_sort_buffer_size is too small，在修复命令后面加参数，增大排序缓存，修复成功
myisamchk -r -f t_counter.MYI --sort_buffer_size=10G
扫一扫
1169
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
