Khaladka miiska xogta mysqld waxa loo calaamadeeyay sidii shil dhacay iyo kii u dambeeyay (otomaatig ah?) xalinta dayactirka

Khaladka miiska MySQL waxaa lagu calaamadeeyay inuu burburay oo uu yahay xalka ugu dambeeya (otomaatig?).

Maqaalkani wuxuu ku bari doonaa talooyinkeena marka la hagaajinayo miiskaError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedXalka.

Waxaa jira dhibaato ku saabsan jadwalka MySQL , sida ku cad fariinta soo socota: ▼

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

mysql_upgrade waxay fulisaa amarradan soo socda si loo hubiyo loona dayactiro miisaska loona cusboonaysiiyo miisaska nidaamka ▼

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

• Guuldarada hawlgalku waa mid aan laga noqon karin, waana in la joojiyo kaydka xogta:

  service monit stop

  service mysqld stop

• Geli hagaha halka xogtu ku taal:

  cd /var/lib/mysql/db_name/

Xusuusin: Adeegga mysql waa in la joojiyaa ka hor inta aan la hagaajin.

• Dayactir xaashida xogta kaliya:

  myisamchk -r tablename.MYI

• Hagaaji dhammaan xaashiyaha xogta:

  myisamchk -r *.MYI

• Qaab nabdoon:

  myisamchk -r -v -o <table_name>

• Habka xooga:

  myisamchk -r -v -f <table_name>

myisamchk isticmaalka

Fiiro gaar ah: Kahor intaadan isticmaalin myisamchk, iska hubi in mysqld aanu galeynin miiska si loo hubiyo.Jooji mysqld ka fiican.

1. fuliyay

   myisamchk –update-state -s *.myi

   , oo hubi faylalka tusaha leh ee dhibka haysta (waxay qaadan kartaa waqti dheer).

2. Ikhtiyaarka cusboonaysiinta gobolka waxa kaliya oo la adeegsadaa marka la joojinayo mysqld. -s macnaheedu waa in la iska indho tiro macluumaadka liiska caadiga ah ee liiska oo kaliya liiska khaladaadka.
3. Miis kasta oo xumaaday, isku day

   myisamchk -r -q table_name

   Tani waa habka dayactirka degdega ah, kaas oo si toos ah u hubin doona in miiska tusaha iyo miiska xogtu ay ahaan karaan kuwo joogto ah.Haddii ay joogto tahay, waa la hagaajin karaa.

4. Haddii habka degdega ah u hagaajin waayo, tixgeli:

   myisamchk -r table_name

   Xogta iyo tusmooyinka iswaafaqsan waa la tirtiray, tusmooyinkuna dib ayaa loo dhisay.

5. Haddii taasi ay ku guuldareysato, tixgeli:

   myisamchk –safe-recover table_name

Tusaalaha hawlgalka

Guuldarada hawlgalku waa mid aan laga noqon karin, waana in la joojiyo kaydka xogta:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Hagaaji dhammaan xaashiyaha xogta:

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

Tani aad bay uga gaabis tahay -r, laakiin waxay qabataa xaalado aan -r awoodin.

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

Halkan waxaa ah amarka dariiqa buuxda ee loo maro miiska xogta:

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

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

Bilow xogta MYSQLD:

service mysqld start

service mysqld restart

Bilow barnaamijka kormeerka MONIT :

service monit restart

service monit start