因意外导致服务器断电,重启后发现mysql起不来了
[root@cacti ~]# service mysqld restart停止 mysqld: [确定]mysql daemon failed to start.正在启动 mysqld: [失败]
查看日志:
[root@cacti ~]# tail -100 /var/log/mysqld.log 150520 12:21:12 mysqld_safe starting mysqld daemon with databases from /var/lib/mysql150520 12:21:12 innodb: initializing buffer pool, size = 8.0m150520 12:21:12 innodb: completed initialization of buffer poolinnodb: log scan progressed past the checkpoint lsn 2 1552263436150520 12:21:12 innodb: database was not shut down normally!innodb: starting crash recovery.innodb: reading tablespace information from the .ibd files...innodb: restoring possible half-written data pages from the doublewriteinnodb: buffer...150520 12:21:12 innodb: starting an apply batch of log records to the database...innodb: progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 innodb: database page corruption on disk or a failedinnodb: file read of page 206.innodb: you may have to recover from a backup.150520 12:21:12 innodb: page dump in ascii and hex (16384 bytes):len 16384; hex cc507667000000ce0000000000000000000000025cabb0bc000200000000000000000000000000021e751eb0ffffffff0000ffffffff000000021dbb0000000000000002123200000001000000ce002c000000ce002c000000000304a196000000000304a1970001011000000000000000000000014...................odb: end of page dump150520 12:21:12 innodb: page checksum 3392922109, prior-to-4.0.14-form checksum 1831220034innodb: stored checksum 3427825255, prior-to-4.0.14-form stored checksum 2455963898innodb: page lsn 2 1554755772, low 4 bytes of lsn at page end 1556408857innodb: page number (if stored to page already) 206,innodb: space id (if created with >= mysql-4.1.1 and stored already) 0innodb: page may be an update undo log pageinnodb: database page corruption on disk or a failedinnodb: file read of page 206.innodb: you may have to recover from a backup.innodb: it is also possible that your operatinginnodb: system has corrupted its own file cacheinnodb: and rebooting your computer removes theinnodb: error.innodb: if the corrupt page is an index pageinnodb: you can also try to fix the corruptioninnodb: by dumping, dropping, and reimportinginnodb: the corrupt table. you can use checkinnodb: table to scan your table for corruption.innodb: see also http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.htmlinnodb: about forcing recovery.innodb: ending processing because of a corrupt database page.150520 12:21:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
mysql新手一个,希望大家能帮帮忙分析下,谢谢!
