mysqld data tafura kukanganisa kwakanyorwa sekuparara uye kwekupedzisira (otomatiki?) kugadzirisa mhinduro

Chikanganiso chetafura yeMySQL chakanyorwa sechakarova uye chekupedzisira (otomatiki?) - mhinduro.

Ichi chinyorwa chichakuzivisa iwe kune mazano edu pakugadzirisa tafuraError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedmhinduro.

Pane dambudziko netafura yeMySQL , sezvinoratidzwa nemeseji inotevera: ▼

Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed

mysql_upgrade inoita iyo inotevera mirairo yekutarisa uye kugadzirisa matafura uye kusimudzira system matafura ▼

mysqlcheck --all-databases --check-upgrade --auto-repair

• Iko kutadza kwekushanda hakuchinjike uye dhatabhesi rinofanira kumiswa:

  service monit stop

  service mysqld stop

• Pinda dhairekitori pane database iripo:

  cd /var/lib/mysql/db_name/

Ongorora: Iyo mysql sevhisi inofanirwa kumiswa basa risati ragadziriswa.

• Gadzirisa dheta rimwe chete:

  myisamchk -r tablename.MYI

• Gadzirisa mapepa ese:

  myisamchk -r *.MYI

• Safe Mode:

  myisamchk -r -v -o <table_name>

• Kumanikidza maitiro:

  myisamchk -r -v -f <table_name>

myisamchk kushandiswa

Cherechedza: Usati washandisa myisamchk, ita shuwa kuti mysqld haisi kuwana tafura kuti itariswe.Zvirinani kumira mysqld.

1. shandisa

   myisamchk –update-state -s *.myi

   , uye tarisa kuti ndeapi mafaera ane indekisi ane matambudziko (angatora nguva yakareba).

2. Iyo yekuvandudza-state sarudzo inongo shandiswa pakumisa mysqld. -s zvinoreva kufuratira mamwe akajairwa tafura yerondedzero ruzivo uye kungonyora zvikanganiso.
3. Patafura yega yega yakaora, edza

   myisamchk -r -q table_name

   Iyi ndiyo nzira yekukurumidza kugadzirisa, iyo inongotarisa kana iyo index index uye tafura yedata inogona kuenderana.Kana ichienderana, inogona kugadziriswa.

4. Kana kukurumidza-kugadzirisa modhi ikatadza, funga:

   myisamchk -r table_name

   Data risingaenderani uye indexes zvinodzimwa, uye indexes anovakwa patsva.

5. Kana izvo zvisingakwanisi, funga:

   myisamchk –safe-recover table_name

Muenzaniso wekushanda

Iko kutadza kwekushanda hakuchinjike uye dhatabhesi rinofanira kumiswa:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Gadzirisa mapepa ese:

myisamchk -r *.MYI

myisamchk -r -v -f wp_postmeta.MYI

myisamchk -r -v -f wp_posts.MYI

myisamchk -r -v -f wp_options.MYI

myisamchk -r -v -f wp_itsec_log

Izvi zvinononoka kupfuura -r, asi zvinobata mamiriro ayo -r asingagone.

myisamchk -r -f -o /var/lib/mysql/eloha_ufo/wp_postmeta.MYI

Heino murairo weiyo nzira yakazara kune tafura yedatabase:

myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_postmeta.MYI

myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_posts.MYI

Tanga iyo MYSQLD database:

service mysqld start

service mysqld restart

Tanga chirongwa chekutarisa MONIT :

service monit restart

service monit start