Cov txheej txheem:

Vim li cas MySQL rooj sib tsoo?
Vim li cas MySQL rooj sib tsoo?

Video: Vim li cas MySQL rooj sib tsoo?

Video: Vim li cas MySQL rooj sib tsoo?
Video: Yuav ncaim lawm es koj xav li cas?. 9/23/2017 2024, Kaum ib hlis
Anonim

Ntau server tsoo yog tshwm sim los ntawm corrupted cov ntaub ntawv los yog cov ntaub ntawv index. MySQL hloov kho cov ntaub ntawv ntawm disk nrog sau () system hu tom qab txhua nqe lus SQL thiab ua ntej tus neeg siv tau ceeb toom txog qhov tshwm sim.

Tsuas yog li ntawd, kuv yuav kho li cas lub rooj sib tsoo MySQL?

Kho cov rooj sib tsoo nrog phpMyAdmin

  1. Nkag mus rau hauv koj tus account SiteWorx.
  2. Ntawm sab laug, xaiv Hosting Nta> MySQL> PhpMyAdmin.
  3. Xaiv qhov tseeb database los ntawm cov npe ntawm sab laug.
  4. Xaiv lub checkbox sib raug rau lub rooj corrupted, thiab los ntawm cov npe xaiv, nyem Kho lub rooj.

Tsis tas li ntawd, kuv yuav kho InnoDB li cas? Rov qab los ntawm corrupted InnoDB rooj

  1. Kauj ruam 1 - Nqa koj cov ntaub ntawv hauv hom rov qab.
  2. Kauj Ruam 2 - Tshawb xyuas cov ntxhuav twg puas raug thiab ua ib daim ntawv teev npe.
  3. Kauj ruam 3 - Thaub qab thiab tso koj cov rooj corrupted.
  4. Kauj Ruam 4 - Rov pib MySQL hauv hom qub.
  5. Kauj ruam 5 – Ntshuam thaub qab.sql.
  6. Kauj Ruam 6 - Hloov chaw nres nkoj thiab tuav lub npias.

Ib yam li ib tug yuav nug, dab tsi kho lub rooj ua MySQL?

Yog tias koj siv qhov kev xaiv QUICK, Kho rooj sim ua kho tsuas yog cov ntaub ntawv index, thiab tsis yog cov ntaub ntawv. Yog tias koj siv EXTENDED kev xaiv, MySQL tsim cov index kab los ntawm kab es tsis txhob tsim ib qhov Performance index ntawm ib lub sij hawm nrog sorting. Hom no kho yog zoo li uas ua los ntawm myisamchk --safe-rov qab.

Mysqlcheck yog dab tsi?

mysqlcheck yog ib lub cuab yeej tu uas tso cai rau koj los xyuas, kho, txheeb xyuas thiab ua kom zoo rau ntau lub rooj los ntawm kab hais kom ua. Nws yog qhov tseem ceeb yog ib qho kev sib txuas lus rau CHECK TABLE, Kho TABLE, SAIB XYUAS TABLE thiab OPTIMIZE TABLE cov lus txib, thiab yog li, tsis zoo li myisamchk thiab aria_chk, xav kom lub server ua haujlwm.

Pom zoo: