Home > Backend Development > PHP Tutorial > 优化表后出现了is marked as crashed and last (automatic?) repair failed解决办法

优化表后出现了is marked as crashed and last (automatic?) repair failed解决办法

WBOY
Release: 2016-06-13 13:24:30
Original
2362 people have browsed it

优化表后出现了is marked as crashed and last (automatic?) repair failed
今天想优化一下表,优化之后出现了如下问题:

SQL code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
mysql> OPTIMIZE TABLE jo_mailqueue;
+---------------------+----------+----------+-------------------------------------------------------------+
| Table               | Op       | Msg_type | Msg_text                                                                                        |
+---------------------+----------+----------+-------------------------------------------------------------+
| jobour.jo_mailqueue | optimize | error    | 1 when fixing table                                                                             |
| jobour.jo_mailqueue | optimize | Error    | Can't change ownership of the file '/usr/local/mysql/data/jobour/jo_mailqueue.MYD' (Errcode: 1) |
| jobour.jo_mailqueue | optimize | status   | Operation failed                                                                                |
+---------------------+----------+----------+---------------------------------------------------

Copy after login


从phpmyadmin打开之后,发现表正在使用中。


OPTIMIZE 优化表怎么会出现这种问题啊。是什么导致的啊。? 谢谢!






------解决方案--------------------
索引坏了 myisam经常这么烂 用命令修复 REPAIR TABLE
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template