MySQL报错:Got error 28 from storage engine
mysql 报错 Error from Engine 28 Storage Got
2023-09-14 08:57:26 时间
今天碰到数据库出错:
Got error 28 from storage engine
查了一下,数据库文件所在的盘应该没事,应该是数据库用的临时目录空间不够
问题原因:
磁盘临时空间不够导致。
解决办法:
清空 /tmp 目录,或者修改 my.cnf 中的 tmpdir 参数,指向具有足够空间目录。
实战经验:
购买的 阿里云 空间,第一块磁盘已用完,而 MySQL 又放在了 第一块磁盘上,所以出现了上面的问题,后来把 MySQL 的数据文件配置到了 第二块新挂载的磁盘上,问题解决!
延伸阅读:
相关文章
- 用Navicat连接mysql报错:2003-Can't connect to MySql server on '10.100.0.109'(10039)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)--续
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on linux
- [root@master mysql]# mysql -uroot -pjsb ERROR 2002 (HY000): Can't connect to local MySQL server thro
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- Mysql 如果有多个可选条件怎么加索引_MySQL|mysql-索引
- MySQL普通索引与唯一索引__mysql中唯一索引和普通索引的用途及区别
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
- [mysqldumpslow 报错] Died at /usr/local/mysql/bin/mysqldumpslow line 161, <> chunk 236.
- MySQL Study之--Mysql无法启动“mysql.host”
- 【MySQL笔记】mysql来源安装/配置步骤和支持中国gbk/gb2312编码配置
- mysql sql语句大全(MySQL语句 整理一)
- mysql_10 _ MySQL为什么有时候会选错索引?
- win7 64下安装mysql-python报错的解决办法
- 程序报错`com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure`
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)
- Mysql之修改mysql的视图定义者
- Mysql之安全清理mysql-slow.log
- 【MySQL】mysql查询语句大总结_Unit04
- 【taro react】---- 编译微信小程序后报错:Error: Minified React error #321;
- Mysql报错:Got fatal error 1236 from master when reading data from binary log: ‘Could not find first lo
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server