MySQL:表'/tmp/#sql_185e_0.MYI'的密钥文件不正确；尝试修复它 [英] MySQL: Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it

问题描述

Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it

此错误是什么意思?

"Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it"

我正在命令行中使用PHP在表中插入40万条记录(每批25k). 如果我仅插入1k条记录，则不会产生MySQL错误.

I'm inserting 400k records in a table by 25k per batch using PHP in command line. If I inserted only 1k records then it will not produce the MySQL error.

该错误是否表示我的服务器没有更多的磁盘空间?

Does the error mean that my server has no more disk space?

谢谢.

推荐答案

根据google-此错误通常与临时目录所在的驱动器空间不足有关.

According to google - this error often related to not enough space for the drive your temporary directory is located at.

这篇关于MySQL:表'/tmp/#sql_185e_0.MYI'的密钥文件不正确；尝试修复它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！