An yiwa kuskuren tebur ɗin bayanan mysqld alama azaman faɗuwa kuma mafita ta ƙarshe (atomatik?) gyara

An yiwa kuskuren tebur na MySQL alama a matsayin wanda ya lalace kuma na ƙarshe (atomatik?) - mafita.

Wannan labarin zai gabatar muku da shawarwarinmu lokacin gyaran teburError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedmafita.

Akwai matsala da teburin MySQL , kamar yadda sakon da ke tafe ya nuna: ▼

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

mysql_upgrade yana aiwatar da waɗannan umarni don dubawa da gyara tebur da haɓaka teburin tsarin ▼

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

• Rashin nasarar aikin ba zai iya jurewa ba kuma dole ne a dakatar da bayanan bayanan:

  service monit stop

  service mysqld stop

• Shigar da kundin adireshi inda bayanan bayanai yake:

  cd /var/lib/mysql/db_name/

Lura: Dole ne a dakatar da sabis na mysql kafin a gyara aikin.

• Gyara takaddun bayanai guda ɗaya:

  myisamchk -r tablename.MYI

• Gyara duk takaddun bayanai:

  myisamchk -r *.MYI

• Yanayin aminci:

  myisamchk -r -v -o <table_name>

• Yanayin tilastawa:

  myisamchk -r -v -f <table_name>

myisamchk amfani

Lura: Kafin amfani da myisamchk, tabbatar cewa mysqld baya shiga teburin da za'a bincika.Gara tsayawa mysqld.

1. za'ayi

   myisamchk –update-state -s *.myi

   , kuma duba waɗanne fayilolin fihirisar ke da matsala (zai ɗauki lokaci mai tsawo).

2. Ana amfani da zaɓin ɗaukaka-jihar kawai lokacin dakatar da mysqld. -s yana nufin watsi da wasu bayanan jeri na tebur na al'ada da kurakurai kawai.
3. Ga kowane tebur da ya lalace, gwada

   myisamchk -r -q table_name

   Wannan shine yanayin gyare-gyare mai sauri, wanda zai bincika ta atomatik ko tebur mai ƙididdigewa da teburin bayanai na iya daidaitawa.Idan ya dace, ana iya gyara shi.

4. Idan yanayin saurin gyara ya gaza, la'akari:

   myisamchk -r table_name

   An share bayanai marasa daidaituwa da fihirisa, kuma an sake gina fihirisa.

5. Idan hakan ya gaza, yi la'akari:

   myisamchk –safe-recover table_name

Misalin aiki

Rashin nasarar aikin ba zai iya jurewa ba kuma dole ne a dakatar da bayanan bayanan:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Gyara duk takaddun bayanai:

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

Wannan yana da hankali fiye da -r, amma yana kula da yanayin da -r ba zai iya ba.

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

Anan ga umarnin don cikakken hanyar zuwa teburin bayanai:

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

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

Fara bayanan MYSQLD:

service mysqld start

service mysqld restart

Fara shirin sa ido na MONIT :

service monit restart

service monit start