Kalozera wa Nkhani
Cholakwika cha tebulo la MySQL chalembedwa kuti chasweka ndipo chomaliza (chokha?) - yankho.
Nkhaniyi idzakudziwitsani za malangizo athu pokonza tebuloError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedyankho.
Pali vuto ndi tebulo la MySQL , monga momwe uthenga wotsatirawu ukusonyezera: ▼
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.
- zidachitidwa
myisamchk –update-state -s *.myi
, ndikuwona kuti ndi mafayilo ati omwe ali ndi vuto (zitha kutenga nthawi yayitali).
- Kusintha kwa state-state kumangogwiritsidwa ntchito poyimitsa mysqld -s kumatanthauza kunyalanyaza zidziwitso zodziwika bwino zama tebulo ndikungolemba zolakwika.
- 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.
- Ngati njira yokonza mwachangu ikulephera, ganizirani:
myisamchk -r table_name
Deta zosagwirizana ndi zolozera zimachotsedwa, ndipo ma index amamangidwanso.
- 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
Yambitsani pulogalamu yowunikira ya MONIT :
service monit restart
service monit start
Tikukhulupirira kuti nkhani yakuti "Yankho la vuto la tebulo la MySQL 'yalembedwa kuti yawonongeka ndipo yatha (yokha?)'" yomwe yagawidwa pa blog ya Chen Weiliang ( https://www.chenweiliang.com/ ) idzakuthandizani.
Khalani omasuka kugawana ulalo wa nkhaniyi: https://www.chenweiliang.com/cwl-176.html