Tusaha Maqaalka
MySQLd qaladka xaashida xogta waxa loo calaamadeeyay sidii shil iyo kii u danbeeyay (otomaatig ah?) repair xal
Maqaalkani wuxuu ku bari doonaa talooyinkeena marka la hagaajinayo miiskaError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failed
Xalka.
MYSQLDhib baa ka jirta xaashida xogta, degdeg ▼
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.
- fuliyay
myisamchk –update-state -s *.myi
, oo hubi faylalka tusaha leh ee dhibka haysta (waxay qaadan kartaa waqti dheer).
- 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.
- 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.
- Haddii habka degdega ah u hagaajin waayo, tixgeli:
myisamchk -r table_name
Xogta iyo tusmooyinka iswaafaqsan waa la tirtiray, tusmooyinkuna dib ayaa loo dhisay.
- 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
bilowMONIT Monitor:
service monit restart
service monit start
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) "Cillada miiska xogta mysqld waxa loo calaamadeeyay sidii shil oo u dambeeyay (otomaatig ah?) xalinta dayactirka" ee aad wadaagto ayaa ku caawin doona.
Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-176.html
Ku soo dhawoow kanaalka Telegramka ee Chen Weiliang's blog si aad u hesho wararkii ugu dambeeyay!
📚 Hagahan waxa uu ka kooban yahay qiimo aad u weyn, 🌟Tani waa fursad naadir ah, ha seegin! ⏰⌛💨
Share iyo like saar hadaad jeceshahay!
Wadaagistaada iyo jeceylkaaga ayaa ah dhiirigelintayada joogtada ah!