Table ‘TableName’ is marked as crashed and should be repaired - Cacher Snippet

2/11/2020 - 3:39 AM

Table ‘TableName’ is marked as crashed and should be repaired

-- 進行修復
REPAIR TABLE TableName


-- 使用 myisamchk 來進行修復
shell# myisamchk -r TableName
 
-- 若是修復過程中因執行記憶體超過 Default 值就必須使用 –sort_buffer_size 來指派記憶體
shell# myisamchk -r TableName --sort_buffer_size=2G