1030从存储引擎收到错误28 [英] 1030 Got error 28 from storage engine

问题描述

我正在一个项目中，我需要为每个想要查看演示应用程序的用户创建一个包含300个表的数据库.一切正常，但是今天当我与新用户进行测试以查看演示时，它向我显示了此错误消息

1030 Got error 28 from storage engine

花了一些时间在谷歌搜索后，我发现这是一个与数据库或临时文件的空间有关的错误.我试图修复它，但失败了.现在我什至不能启动mysql.我该如何解决这个问题，我也想将大小增加到最大，这样我就不会一次又一次地遇到相同的问题.

解决方案

Mysql错误来自存储引擎的 28 "-表示"没有足够的磁盘空间".

要在下面显示光盘空间，请使用命令.

myServer# df -h

结果必须是这样的.

Filesystem    Size    Used   Avail Capacity  Mounted on
/dev/vdisk     13G     13G     46M   100%    /
devfs         1.0k    1.0k      0B   100%    /dev

I am working on a project where i need to create a database with 300 tables for each user who wants to see the demo application. it was working fine but today when i was testing with a new user to see a demo it showed me this error message

1030 Got error 28 from storage engine

After spending some time googling i found it is an error that is related to space of database or temporary files. I tried to fix it but i failed. now i am not even able to start mysql. How can i fix this and i would also like to increase the size to maximum so that i won't face the same issue again and again.

解决方案

Mysql error "28 from storage engine" - means "not enough disk space".

To show disc space use command below.

myServer# df -h

Results must be like this.

Filesystem    Size    Used   Avail Capacity  Mounted on
/dev/vdisk     13G     13G     46M   100%    /
devfs         1.0k    1.0k      0B   100%    /dev

这篇关于1030从存储引擎收到错误28的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！