mysql table is marked as crashed and last (automatic?) repair failed

image_pdfimage_print

В логах MySQL вижу уже второй раз такую ошибку


<span class="kwd">Table</span> <span class="str">'./glpi/glpi_log/'</span> <span class="kwd">is</span><span class="pln"> marked </span><span class="kwd">as</span><span class="pln"> crashed </span><span class="kwd">and</span><span class="pln"> last </span><span class="pun">(</span><span class="pln">automatic</span><span class="pun">?)</span><span class="pln"> repair failed
</span>

165
down vote
accepted
If your MySQL process is running, stop it. On Debian:

sudo service mysql stop
Go to your data folder. On Debian:

cd /var/lib/mysql/$DATABASE_NAME
Try running:

myisamchk -r $TABLE_NAME
If that doesn’t work, you can try:

myisamchk -r -v -f $TABLE_NAME
You can start your MySQL server again. On Debian:

sudo service mysql start

 

но может быть и проблема типа

ve got a

myisam_sort_buffer_size is too small

error, so this command worked for me:

myisamchk -r -v --sort_buffer_size=2G &lt;table_name&gt;

Оставьте комментарий