Littafin Adireshi
MySQLd kuskuren takardar bayanan an yi masa alama azaman rushewa kuma na ƙarshe (atomatik?) mai wakiltarair mafita
Wannan labarin zai gabatar muku da shawarwarinmu lokacin gyaran teburError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failed
mafita.
MYSQLAkwai matsala tare da takardar bayanan, mai sauri ▼
Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed
mysql_upgrade yana aiwatar da waɗannan umarni don dubawa da gyara tebur da haɓaka teburin tsarin ▼
mysqlcheck --all-databases --check-upgrade --auto-repair
- Rashin nasarar aikin ba zai iya jurewa ba kuma dole ne a dakatar da bayanan bayanan:
service monit stop
service mysqld stop
- Shigar da kundin adireshi inda bayanan bayanai yake:
cd /var/lib/mysql/db_name/
Lura: Dole ne a dakatar da sabis na mysql kafin a gyara aikin.
- Gyara takaddun bayanai guda ɗaya:
myisamchk -r tablename.MYI
- Gyara duk takaddun bayanai:
myisamchk -r *.MYI
- Yanayin aminci:
myisamchk -r -v -o <table_name>
- Yanayin tilastawa:
myisamchk -r -v -f <table_name>
myisamchk amfani
Lura: Kafin amfani da myisamchk, tabbatar cewa mysqld baya shiga teburin da za'a bincika.Gara tsayawa mysqld.
- za'ayi
myisamchk –update-state -s *.myi
, kuma duba waɗanne fayilolin fihirisar ke da matsala (zai ɗauki lokaci mai tsawo).
- Ana amfani da zaɓin ɗaukaka-jihar kawai lokacin dakatar da mysqld. -s yana nufin watsi da wasu bayanan jeri na tebur na al'ada da kurakurai kawai.
- Ga kowane tebur da ya lalace, gwada
myisamchk -r -q table_name
Wannan shine yanayin gyare-gyare mai sauri, wanda zai bincika ta atomatik ko tebur mai ƙididdigewa da teburin bayanai na iya daidaitawa.Idan ya dace, ana iya gyara shi.
- Idan yanayin saurin gyara ya gaza, la'akari:
myisamchk -r table_name
An share bayanai marasa daidaituwa da fihirisa, kuma an sake gina fihirisa.
- Idan hakan ya gaza, yi la'akari:
myisamchk –safe-recover table_name
Misalin aiki
Rashin nasarar aikin ba zai iya jurewa ba kuma dole ne a dakatar da bayanan bayanan:
service monit stop
service mysqld stop
cd /var/lib/mysql/eloha_ufo
cd /var/lib/mysql/eloha_cwl
Gyara duk takaddun bayanai:
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
Wannan yana da hankali fiye da -r, amma yana kula da yanayin da -r ba zai iya ba.
myisamchk -r -f -o /var/lib/mysql/eloha_ufo/wp_postmeta.MYI
Anan ga umarnin don cikakken hanyar zuwa teburin bayanai:
myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_postmeta.MYI
myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_posts.MYI
Fara bayanan MYSQLD:
service mysqld start
service mysqld restart
faraMONIT Monitor:
service monit restart
service monit start
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "Mysqld data table error is marked as rupted and last (atomatik?) maganin gyara", wanda zai taimaka muku.
Barka da zuwa raba hanyar haɗin wannan labarin:https://www.chenweiliang.com/cwl-176.html
Barka da zuwa tashar Telegram na Chen Weiliang's blog don samun sabbin abubuwa!
📚 Wannan jagorar ya ƙunshi ƙima mai yawa, 🌟Wannan dama ce da ba kasafai ba, kar a rasa ta! ⏰⌛💨
Share da like idan kuna so!
Rarraba ku da abubuwan so sune ci gaba da ƙarfafa mu!