IDO老徐,坐标深圳,测试经理,干了十年测试,公号"简尚" ,个人博客isTester.com ,关注「软件测试从业者综合能力提升」,微信957863300

mysql报错Table is marked as crashed and should be repaired 的解决办法

上一篇 / 下一篇  2020-11-14 13:41:34 / 个人分类:linux

前几天,老徐的istester博客突然挂了;收到了用户的反馈才知道 ;

4rW.c(K3IBid0

折腾了几次没发现原因;

yi@3VyN ufy0

后面查了下数据库,才发现,是库出问题了;51Testing软件测试网!\!F \ DzW W.EZ+p


51Testing软件测试网9Yi)Py;u2U'z

如下是报错内容 和解决思路 ;

;f O0z4oH0


JU0v A2r0

51Testing软件测试网 J-q:Jq#T2u {&EGlW

mysql> select * from isTeter.com ;51Testing软件测试网_1m%Mk$}*^'v8M

ERROR 145 (HY000): Table './isTeter_Idoxu/isTeter.com' is marked as crashed and should be repaired51Testing软件测试网vZ(t4F)@


51Testing软件测试网Gba\2t"x*PB!a

mysql> check table isTeter.com ;51Testing软件测试网'P+E4}Fk]#U

+-----------------------------+-------+----------+------------------------------------------------------------+

7k6EEM-P j0

| Table                       | Op    | Msg_type | Msg_text                                                   |

4C)~Abuy j V0

+-----------------------------+-------+----------+------------------------------------------------------------+

7NC5aR8f%g+CI,hx0

| isTeter_Idoxu.isTeter.com | check | warning  | Table is marked as crashed                                 |

8C]8QKWUh.lm@2P0

| isTeter_Idoxu.isTeter.com | check | warning  | 102 clients are using or haven't closed the table properly |51Testing软件测试网 m Tb,A}t8o

| isTeter_Idoxu.isTeter.com | check | error    | Checksum for key:  4 doesn't match checksum for records    |51Testing软件测试网3b"Gb6\)D'm;`t

| isTeter_Idoxu.isTeter.com | check | error    | Corrupt                                                    |

f_7Fx8{%t$Lk0

+-----------------------------+-------+----------+------------------------------------------------------------+51Testing软件测试网4EH)ntut UNL

4 rows in set (0.31 sec)

PQo9?3t,}0


51Testing软件测试网"{n$H)d%H+aJ2P\~

mysql> repair table isTeter.com;51Testing软件测试网[7?J~u)Q4N

+-----------------------------+--------+----------+----------+51Testing软件测试网0wVn9P6k]6N$W#P*t

| Table                       | Op     | Msg_type | Msg_text |51Testing软件测试网(z{X1j"@D?,i

+-----------------------------+--------+----------+----------+51Testing软件测试网w+w vMu P H&j7d

| isTeter_Idoxu.isTeter.com | repair | status   | OK       |51Testing软件测试网1UH t+K2n;Nj;YS$x

+-----------------------------+--------+----------+----------+51Testing软件测试网|+?5i5pY }'e1Kb)Z&X0N

1 row in set (0.15 sec)

I Vb)Mx g(ql p0


y%KK0tS*TDY6T0

mysql> check table isTeter.com;

FP+X-c7^v Z^a-W0

+-----------------------------+-------+----------+----------+51Testing软件测试网^Ad!FJ(q

| Table                       | Op    | Msg_type | Msg_text |51Testing软件测试网Vh$S nTGv

+-----------------------------+-------+----------+----------+

$a3f4t6qd3B0

| isTeter_Idoxu.isTeter.com | check | status   | OK       |51Testing软件测试网I ~@7OE1ZH

+-----------------------------+-------+----------+----------+

F(`?T hbB0

1 row in set (0.01 sec)

B"g(e._Z%p+kk0


51Testing软件测试网8ncv+gK"\{!L


I?&N C'dgm D!zI,O0

搞定 51Testing软件测试网)y` jxZUG.mr


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

xuquan

xuquan

IDO老徐,坐标深圳,测试经理,干了十年测试,公号"简尚" ,个人博客isTester.com ,关注「软件测试从业者综合能力提升」,微信957863300

日历

« 2021-01-22  
     12
3456789
10111213141516
17181920212223
24252627282930
31      

数据统计

  • 访问量: 648473
  • 日志数: 380
  • 建立时间: 2012-06-04
  • 更新时间: 2021-01-04

RSS订阅

Open Toolbar