Ko te hapa o te ripanga raraunga mysqld kua tohua kua pakaru me te otinga whakatikatika whakamutunga (aunoa?).

mysqld kua tohuhia te hapa o te pepa raraunga kua tukituki me te whakahoki whakamutunga (aunoa?).air otinga

Ma tenei tuhinga e whakaatu ki a koe a maatau tohutohu i te wa e whakatika ana i te tepuError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedotinga.

MySQLHe raru kei te pepa raraunga, tohu ▼

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

Ka mahia e mysql_upgrade nga whakahau e whai ake nei hei tirotiro me te whakatika i nga ripanga me te whakahou i nga ripanga punaha ▼

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

• Ko te korenga o te mahi e kore e taea te huri, me aukati te patengi raraunga:

  service monit stop

  service mysqld stop

• Whakauruhia te whaiaronga kei reira te putunga raraunga:

  cd /var/lib/mysql/db_name/

Tuhipoka: Me mutu te ratonga mysql i mua i te whakatikatika i te mahi.

• Tapia te rauraraunga kotahi:

  myisamchk -r tablename.MYI

• Whakatikahia nga rauraraunga katoa:

  myisamchk -r *.MYI

• Aratau Haumaru:

  myisamchk -r -v -o <table_name>

• Aratau kaha:

  myisamchk -r -v -f <table_name>

whakamahi myisamchk

Tuhipoka: I mua i te whakamahi i te myisamchk, kia mohio kaore a mysqld e uru ki te ripanga kia tirohia.He pai ake kia mutu taku mysqld.

1. kawea

   myisamchk –update-state -s *.myi

   , ka tirohia ko wai nga konae taurangi he raru (he roa pea te waa).

2. Ka whakamahia te kowhiringa-whakahou i te wa e whakamutua ana te mysqld. -s te tikanga kia warewarehia etahi korero rarangi ripanga noa me te rarangi hapa anake.
3. Mo ia ripanga kua kino, ngana

   myisamchk -r -q table_name

   Koinei te aratau whakatikatika tere, ka tirohia aunoa mena ka rite te ripanga taurangi me te ripanga raraunga.Mena he rite tonu, ka taea te whakatika.

4. Mena ka rahua te aratau whakatika tere, whakaarohia:

   myisamchk -r table_name

   Ko nga raraunga koretake me nga tohu ka mukua, ka hangaia ano nga tohu.

5. Mena ka rahua, whakaarohia:

   myisamchk –safe-recover table_name

Tauira mahi

Ko te korenga o te mahi e kore e taea te huri, me aukati te patengi raraunga:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Whakatikahia nga rauraraunga katoa:

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

He puhoi ake tenei i te -r, engari ka whakahaere i nga ahuatanga kaore e taea e -r.

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

Anei te whakahau mo te ara katoa ki te ripanga papaa raraunga:

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

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

Tīmatahia te pātengi raraunga MYSQLD:

service mysqld start

service mysqld restart

tiimataMONIT Aroturuki:

service monit restart

service monit start