mysql删除数据库文件ibdata1后引发的故障

最新推荐文章于 2024-04-25 09:59:26 发布

reblue520

最新推荐文章于 2024-04-25 09:59:26 发布

阅读量677

点赞数

本文链接：https://blog.csdn.net/reblue520/article/details/80553073

版权

进行性能测试是发现大量报错：

Duplicate entry主键重复

可以看到mysql数据库中已经没有innodb引擎启动信息了

之前发现ibdata1占用了大量硬盘，为了省出空间删除了数据库ibdata1文件
此时，删除ibdata1和ib_logfile0，ib_logfile1...再次重启即可恢复正常
需要注意的是，其中innodb引擎的表被破坏掉了，需要重新导入

mysql> show engines;


+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

数据库日志报错部分：