磁盘挂载不正确导致的主库启动不起来:
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文件