[php] 2025-05-05 圈点981
摘要:当mysql出现错误提示:ERROR 144 (HY000): Table "tbname.MYI" is marked as crashed and last (automatic?) repair failed时可以用myisamchk使用命令进行修复表
当mysql出现错误提示:ERROR 144 (HY000): Table "tbname.MYI" is marked as crashed and last (automatic?) repair failed时可以用myisamchk使用命令进行修复表。
myisamchk使用命令格式:
myisamchk -r -f tbname.MYI
备注:加参数可以加速速度如下:
myisamchk --myisam_sort_buffer_size=1024M --key_buffer_size=2048M --read_buffer_size=1024M --write_buffer_size=1024M