Cholakwika cha tebulo la mysqld chalembedwa kuti chawonongeka komanso chomaliza (chokha?) Kukonza njira

MySQLd zolakwa za pepala la data zimalembedwa kuti zawonongeka komanso zomaliza (zokha?) repair yankho

Nkhaniyi idzakudziwitsani za malangizo athu pokonza tebuloError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedyankho.

YAM'MBUYO YOTSATIRAPali vuto ndi pepala la data, mwachangu ▼

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

mysql_upgrade amatsatira malamulo otsatirawa kuti ayang'ane ndi kukonza matebulo ndikukweza matebulo adongosolo ▼

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

• Kulephera kwa ntchitoyi sikungasinthe ndipo nkhokwe iyenera kuyimitsidwa:

  service monit stop

  service mysqld stop

• Lowetsani chikwatu komwe database ili:

  cd /var/lib/mysql/db_name/

Zindikirani: Ntchito ya mysql iyenera kuyimitsidwa ntchitoyo isanakonzedwe.

• Konzani deta imodzi:

  myisamchk -r tablename.MYI

• Konzani zikalata zonse:

  myisamchk -r *.MYI

• Njira Yotetezedwa:

  myisamchk -r -v -o <table_name>

• Kukakamiza:

  myisamchk -r -v -f <table_name>

kugwiritsa ntchito myisamchk

Zindikirani: Musanagwiritse ntchito myisamchk, onetsetsani kuti mysqld sikulowa patebulo kuti awonedwe.Kulibwino kuyimitsa mysqld.

1. zidachitidwa

   myisamchk –update-state -s *.myi

   , ndikuwona kuti ndi mafayilo ati omwe ali ndi vuto (zitha kutenga nthawi yayitali).

2. Kusintha kwa state-state kumangogwiritsidwa ntchito poyimitsa mysqld -s kumatanthauza kunyalanyaza zidziwitso zodziwika bwino zama tebulo ndikungolemba zolakwika.
3. Pa tebulo lililonse lovunda, yesani

   myisamchk -r -q table_name

   Iyi ndiyo njira yokonzekera mwamsanga, yomwe idzayang'anitsitsa ngati tebulo la ndondomeko ndi tebulo la deta lingakhale lofanana.Ngati ikugwirizana, ikhoza kukonzedwa.

4. Ngati njira yokonza mwachangu ikulephera, ganizirani:

   myisamchk -r table_name

   Deta zosagwirizana ndi zolozera zimachotsedwa, ndipo ma index amamangidwanso.

5. Ngati izo sizikanika, ganizirani:

   myisamchk –safe-recover table_name

Chitsanzo cha ntchito

Kulephera kwa ntchitoyi sikungasinthe ndipo nkhokwe iyenera kuyimitsidwa:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Konzani zikalata zonse:

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

Izi ndizochedwa kwambiri kuposa -r, koma zimagwira ntchito zomwe -r sizingathe.

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

Nali lamulo la njira yonse yopita ku tebulo la database:

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

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

Yambitsani nkhokwe ya MYSQLD:

service mysqld start

service mysqld restart

YambitsaniMONIT Monitor:

service monit restart

service monit start