设为首页 加入收藏

TOP

MySQL启动失败,磁盘挂载不正确导致的主库启动不起来怎么解决?
2017-12-14 14:32:20 】 浏览:167
Tags:MySQL 启动 失败 磁盘 正确 导致 起来 怎么 解决

磁盘挂载不正确导致的主库启动不起来:

Recovery process statistics

Checked pages by doublewrite buffer: 128

Overwritten pages from doublewrite: 0

Recovered pages by io_thread: 143

Recovered pages by main thread: 0

Parsed log records to apply: 139463

Sum of the length: 964413

Applied log records: 135257

Sum of the length: 940059

Pages which are already new enough: 128 (It may not be accurate, if turns > 1)

Oldest page's LSN: 39274

Newest page's LSN: 1597908

============================================================

171205 10:04:01 InnoDB: Operating system error number 2 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: cannot open ib_lru_dump

171205 10:04:01 InnoDB: Waiting for the background threads to start

171205 10:04:02 Percona XtraDB (https://www.percona.com) 1.1.8-rel24.1 started; log sequence number 1597915

171205 10:04:02 [Note] Recovering after a crash using /home/mysql/binlog

171205 10:04:02 [Note] Starting crash recovery...

171205 10:04:02 [Note] Crash recovery finished.

171205 10:04:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

171205 10:04:02 mysqld_safe mysqld from pid file /home/mysql/mysql.pid ended

解决: 1、查看分区UUID blkid 2、查看/etc/fstatb文件挂盘文件是否正确 3、重新挂载分区,写入fstab文件

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇MySQL多实例从库经常show slave s.. 下一篇如何配置mysql的连接数?

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目