mysqld faʻamatalaga laulau faʻailoga ua faʻailogaina o le paʻu ma mulimuli (ototometi?) fofo toe faaleleia

Ua fa'ailogaina le fa'aletonu o le laulau MySQL o se fa'aletonu ma mulimuli (otometi?) - fofo.

O lenei tusiga o le a faʻafeiloaia oe ia matou fautuaga pe a toe faʻaleleia le laulauError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedfofo.

O loʻo iai se faʻafitauli i le laulau MySQL , e pei ona faʻaalia i le savali lenei: ▼

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

mysql_upgrade e faʻatino tulafono nei e siaki ma toe faʻaleleia laulau ma faʻaleleia laulau faʻaoga ▼

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

• O le toilalo o le taotoga e le mafai ona toe faʻaaogaina ma e tatau ona taofi le faʻamaumauga:

  service monit stop

  service mysqld stop

• Ulufale i le lisi o loʻo i ai le database:

  cd /var/lib/mysql/db_name/

Manatua: E tatau ona taofi le auaunaga mysql aʻo leʻi toe faʻaleleia le taʻaloga.

• Toe fa'aleleia se fa'amaumauga e tasi:

  myisamchk -r tablename.MYI

• Fa'amau uma fa'amaumauga:

  myisamchk -r *.MYI

• Faiga Saogalemu:

  myisamchk -r -v -o <table_name>

• Faiga fa'amalosi:

  myisamchk -r -v -f <table_name>

fa'aoga myisamchk

Manatua: Aʻo leʻi faʻaogaina myisamchk, ia mautinoa e le o maua e mysqld le laulau e siaki.Sili ona taofi mysqld.

1. faatino

   myisamchk –update-state -s *.myi

   , ma siaki po'o fea faila fa'asino igoa e iai fa'afitauli (atonu e umi se taimi).

2. O le fa'afou-setete filifiliga e na'o le fa'aoga pe a taofi mysqld -s o lona uiga e le amana'ia nisi fa'amatalaga masani lisi lisi ae na'o lisi mea sese.
3. Mo laulau leaga taitasi, taumafai

   myisamchk -r -q table_name

   Ole faiga vave lea ole toe fa'aleleia, lea ole a otometi lava ona siaki pe mafai ona tutusa le laulau fa'asino ma le laulau fa'amaumauga.Afai e tumau, e mafai ona faaleleia.

4. Afai e le manuia le faiga vave-fix, mafaufau:

   myisamchk -r table_name

   O faʻamaumauga ma faʻamatalaga e le tutusa e tape, ma faʻamaufaʻailoga e toe fausia.

5. Afai e le manuia, mafaufau:

   myisamchk –safe-recover table_name

Fa'ata'ita'iga fa'atinoga

O le toilalo o le taotoga e le mafai ona toe faʻaaogaina ma e tatau ona taofi le faʻamaumauga:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Fa'amau uma fa'amaumauga:

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

E sili atu le lemu nai lo le -r, ae faʻatautaia tulaga e le mafai e -r.

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

Ole fa'atonuga lea mo le ala atoa ile laulau fa'amaumauga:

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

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

Amata le MYSQLD database:

service mysqld start

service mysqld restart

Amata le polokalame mata'ituina o le MONIT :

service monit restart

service monit start