Iphutha lethebula ledatha le-mysqld limakwe njengeliphahlazekile futhi elokugcina (okuzenzakalelayo?) isisombululo sokulungisa

mysqld iphutha leshidi ledatha limakwe njengeliphahlazekile futhi elokugcina (okuzenzakalelayo?) repair isixazululo

Lesi sihloko sizokwethula amathiphu ethu lapho ulungisa itafulaError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedisisombululo.

I-MYSQLKunenkinga ngeshidi ledatha, ukwaziswa ▼

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

mysql_upgrade ikhipha imiyalo elandelayo ukuhlola nokulungisa amatafula kanye nokuthuthukisa amatafula esistimu ▼

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

• Ukwehluleka komsebenzi akunakuhlehliswa futhi isizindalwazi kufanele simiswe:

  service monit stop

  service mysqld stop

• Faka uhla lwemibhalo lapho isizindalwazi sikhona:

  cd /var/lib/mysql/db_name/

Qaphela: Isevisi ye-mysql kufanele imiswe ngaphambi kokuthi umsebenzi ulungiswe.

• Lungisa idatha eyodwa:

  myisamchk -r tablename.MYI

• Lungisa wonke ama-database:

  myisamchk -r *.MYI

• Imodi ephephile:

  myisamchk -r -v -o <table_name>

• Imodi yokuphoqelela:

  myisamchk -r -v -f <table_name>

ukusetshenziswa kwe-myisamchk

Qaphela: Ngaphambi kokusebenzisa i-myisamchk, qiniseka ukuthi i-mysqld ayifinyeleli ithebula elizobhekwa.Kungcono uyeke i-mysqld.

1. sebenzisa

   myisamchk –update-state -s *.myi

   , futhi uhlole ukuthi yimaphi amafayela enkomba anezinkinga (kungase kuthathe isikhathi eside).

2. Inketho ye-update-state isetshenziswa kuphela uma umisa i-mysqld -s isho ukungaziba ulwazi oluthile oluvamile lohlu lwethebula futhi lufake amaphutha kuphela.
3. Kuthebula ngalinye elonakele, zama

   myisamchk -r -q table_name

   Lena imodi yokulungisa ngokushesha, ezohlola ngokuzenzakalelayo ukuthi ithebula lenkomba nethebula ledatha kungahambisana yini.Uma ihambisana, ingalungiswa.

4. Uma imodi yokulungisa ngokushesha yehluleka, cabanga:

   myisamchk -r table_name

   Idatha engahambisani nezinkomba ziyasuswa, futhi izinkomba ziyakhiwa kabusha.

5. Uma lokho kwehluleka, cabanga:

   myisamchk –safe-recover table_name

Isibonelo sokusebenza

Ukwehluleka komsebenzi akunakuhlehliswa futhi isizindalwazi kufanele simiswe:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Lungisa wonke ama-database:

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

Lokhu kuhamba kancane kakhulu kuno-r, kodwa kusingatha izimo -r ezingakwazi.

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

Nawu umyalo wendlela egcwele yetafula lesizindalwazi:

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

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

Qala isizindalwazi se-MYSQLD:

service mysqld start

service mysqld restart

QalisaI-MONIT Monitor:

service monit restart

service monit start