Check your space left on the device
解决方案 »
- mysql横排变竖排
- MYSQL 取出字段 怎么强制成整型
- sql查询 同一个字段 同时满足多个条件
- Postgresqls数据库管理员用户密码忘记了
- mysql创建自定义函数有个问题请教
- 修改数据库名的语法是怎样的
- 请问怎样从一个数据库中读取所有表名?谢谢!
- 我在phpMyAdmin-2.2.6删了所有使用者,现在用不了数据库
- Mysql如何实现查询语句有小计合计
- mysql + myodbc + pb 的客户/服务器开发的讨论!如何保证datawindow的出错后的rollback
- 在mysql里增加一列,列的值为行号
- access数据库怎么转化为mysql数据库!!!!!!!!!!!!!!!!!!!!!!!
Error code 28: No space left on deviceIf you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL.You can check out, that environment variables for MySQL are properly set.Check the value of tmp_table_size:mysql> show variables like "tmp_table_size";
+----------------+----------+
| Variable_name | Value |
+----------------+----------+
| tmp_table_size | 33554432 |
+----------------+----------+This tells, what is the limit, when reached, in-memory temporary tables will automatically be converted to a disk-based MyISAM table.Then you need to find out, where the 'tmpdir' pointsmysql> show variables like "tmpdir";
+---------------+-------------+
| Variable_name | Value |
+---------------+-------------+
| tmpdir | /tmp/mysql/ |
+---------------+-------------+And check, that there is plenty of space available in that device.