MySQL:表'/tmp/#sql_185e_0.MYI'的键文件不正确;尝试修复它

时间:2022-09-16 10:00:14
Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it

What does this error mean?

这个错误是什么意思?

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

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.

我在命令行中使用PHP将400k记录插入到表中,每批25k次。如果我只插入1k条记录,那么它不会产生MySQL错误。

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

这个错误是否意味着我的服务器没有更多的磁盘空间?

Thanks.

谢谢。

1 个解决方案

#1


2  

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

据谷歌相关——这个错误经常没有足够的空间让你临时目录位于。

#1


2  

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

据谷歌相关——这个错误经常没有足够的空间让你临时目录位于。