进行性能测试是发现大量报错:
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