解決資料庫 Table ‘xxx’ is marked as crashed and should be repaired

Discuz論壇出現以下畫面

解決辦法使用命令myisamchk修復資料庫的MYI檔即可

./myisamchk -c -r 資料庫表MYI檔的路徑(例如：/home/mysql/var/crawlerfeedsky/aaaa.MYI) 如果還不行，就-f 強制修復

myisamchk -c -r /var/lib/mysql/master01/Discuz/pre_forum_threadaddviews.MYI

Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200

Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295

Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295

Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295

- recovering (with sort) MyISAM-table '/var/lib/mysql/master01/Discuz/pre_forum_threadaddviews.MYI'

Data records: 1079

- Fixing index 1

然後myisamchk 工具會説明你恢復資料表的索引。重新啟動mysql，問題解決