mysql错误+126_MySQL，错误126：表的密钥文件不正确

我阅读了以下具有相关性的问题，但答复并未使我满意：MySQL：＃126-表的密钥文件不正确

问题

运行查询时出现此错误

错误126(HY000)：表的密钥文件不正确`

问题

当我试图找到问题时，我找不到问题，所以我不知道如何使用repair命令修复它。在我已经尝试过之后，是否有其他任何方法可以指示我如何找到导致此问题的问题呢？

查询

mysql> SELECT

-> Process.processId,

-> Domain.id AS domainId,

-> Domain.host,

-> Process.started,

-> COUNT(DISTINCT Joppli.id) AS countedObjects,

-> COUNT(DISTINCT Page.id) AS countedPages,

-> COUNT(DISTINCT Rule.id) AS countedRules

-> FROM Domain

-> JOIN CustomScrapingRule

-> AS Rule

-> ON Rule.Domain_id = Domain.id

-> LEFT JOIN StructuredData_Joppli

-> AS Joppli

-> ON Joppli.CustomScrapingRule_id = Rule.id

-> LEFT JOIN Domain_Page

-> AS Page

-> ON Page.Domain_id = Domain.id

-> LEFT JOIN Domain_Process

-> AS Process

-> ON Process.Domain_id = Domain.id

-> WHERE Rule.CustomScrapingRule_id IS NULL

-> GROUP BY Domain.id

-> ORDER BY Domain.host;

ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_2b5_4.MYI'; try to repair it

mysqlcheck

root@scraper:~# mysqlcheck -p scraper

Enter password:

scraper.CustomScrapingRule OK

scraper.Domain OK

scraper.Domain_Page OK

scraper.Domain_Page_Rank OK

scraper.Domain_Process OK

scraper.Log OK

scraper.StructuredData_Joppli OK

scraper.StructuredData_Joppli_Product OK

计算行

mysql> select count(*) from CustomScrapingRule;

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

| count(*) |

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

| 26 |

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

1 row in set (0.04 sec)

mysql> select count(*) from Domain;

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

| count(*) |

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

| 2 |

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

1 row in set (0.01 sec)

mysql> select count(*) from Domain_Page;

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

| count(*) |

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

| 134288 |

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

1 row in set (0.17 sec)

mysql> select count(*) from Domain_Page_Rank;

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

| count(*) |

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

| 4671111 |

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

1 row in set (11.69 sec)

mysql> select count(*) from Domain_Process;

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

| count(*) |

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

| 2 |

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

1 row in set (0.02 sec)

mysql> select count(*) from Log;

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

| count(*) |

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

| 41 |

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

1 row in set (0.00 sec)

mysql> select count(*) from StructuredData_Joppli;

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

| count(*) |

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

| 11433 |

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

1 row in set (0.16 sec)

mysql> select count(*) from StructuredData_Joppli_Product;

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

| count(*) |

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

| 130784 |

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

1 row in set (0.20 sec)

更新资料

磁盘使用情况

root@scraper:/tmp# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/xvda1 20G 4.7G 15G 26% /

none 4.0K 0 4.0K 0% /sys/fs/cgroup

udev 237M 4.0K 237M 1% /dev

tmpfs 49M 188K 49M 1% /run

none 5.0M 0 5.0M 0% /run/lock

none 245M 0 245M 0% /run/shm

none 100M 0 100M 0% /run/user