- 论坛徽章:
- 0
|
现在有一台数据库宕机了,现在无法启动,通过‘service mysqld start’ ,启动日志如下:
20508 17:33:18 mysqld_safe Starting mysqld daemon with databases from /Databases/mysql/
120508 17:33:18 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
120508 17:33:18 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
120508 17:33:18 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
120508 17:33:18 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release.
120508 17:33:18 [Note] Plugin 'FEDERATED' is disabled.
120508 17:33:18 InnoDB: Initializing buffer pool, size = 9.0G
120508 17:33:18 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 145 4107726386
120508 17:33:19 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 doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 145 4112969216
InnoDB: Doing recovery: scanned up to log sequence number 145 4118212096
InnoDB: Doing recovery: scanned up to log sequence number 145 4123454976
InnoDB: Doing recovery: scanned up to log sequence number 145 4128697856
InnoDB: Doing recovery: scanned up to log sequence number 145 4133940736
InnoDB: Doing recovery: scanned up to log sequence number 145 4139183616
InnoDB: Doing recovery: scanned up to log sequence number 145 4144426496
InnoDB: Doing recovery: scanned up to log sequence number 145 4149669376
InnoDB: Doing recovery: scanned up to log sequence number 145 4154912256
InnoDB: Doing recovery: scanned up to log sequence number 145 4160155136
InnoDB: Doing recovery: scanned up to log sequence number 145 4165398016
InnoDB: Doing recovery: scanned up to log sequence number 145 4170640896
InnoDB: Doing recovery: scanned up to log sequence number 145 4175883776
InnoDB: Doing recovery: scanned up to log sequence number 145 4181126656
InnoDB: Doing recovery: scanned up to log sequence number 145 4186369536
InnoDB: Doing recovery: scanned up to log sequence number 145 4191612416
InnoDB: Doing recovery: scanned up to log sequence number 145 4196855296
InnoDB: Doing recovery: scanned up to log sequence number 145 4202098176
InnoDB: Doing recovery: scanned up to log sequence number 145 4207341056
InnoDB: Doing recovery: scanned up to log sequence number 145 4212583936
InnoDB: Doing recovery: scanned up to log sequence number 145 4217826816
InnoDB: Doing recovery: scanned up to log sequence number 145 4223069696
InnoDB: Doing recovery: scanned up to log sequence number 145 4228312576
InnoDB: Doing recovery: scanned up to log sequence number 145 4233555456
InnoDB: Doing recovery: scanned up to log sequence number 145 4238798336
InnoDB: Doing recovery: scanned up to log sequence number 145 4238798336
InnoDB: Doing recovery: scanned up to log sequence number 145 4244041216
InnoDB: Doing recovery: scanned up to log sequence number 145 4249284096
InnoDB: Doing recovery: scanned up to log sequence number 145 4254526976
InnoDB: Doing recovery: scanned up to log sequence number 145 4259769856
InnoDB: Doing recovery: scanned up to log sequence number 145 4265012736
InnoDB: Doing recovery: scanned up to log sequence number 145 4270255616
InnoDB: Doing recovery: scanned up to log sequence number 145 4275498496
InnoDB: Doing recovery: scanned up to log sequence number 145 4280741376
InnoDB: Doing recovery: scanned up to log sequence number 145 4285984256
InnoDB: Doing recovery: scanned up to log sequence number 145 4291227136
InnoDB: Doing recovery: scanned up to log sequence number 146 1502720
InnoDB: Doing recovery: scanned up to log sequence number 146 6745600
InnoDB: Doing recovery: scanned up to log sequence number 146 11988480
InnoDB: Doing recovery: scanned up to log sequence number 146 17231360
InnoDB: Doing recovery: scanned up to log sequence number 146 22474240
InnoDB: Doing recovery: scanned up to log sequence number 146 27717120
InnoDB: Doing recovery: scanned up to log sequence number 146 32960000
InnoDB: Doing recovery: scanned up to log sequence number 146 38202880
InnoDB: Doing recovery: scanned up to log sequence number 146 43445760
InnoDB: Doing recovery: scanned up to log sequence number 146 48684557
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 167436 row operations to undo
InnoDB: Trx id counter is 0 1655435264
120508 17:33:42 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
到了这里,启动失败:
[root@Hawx-02 mysql]# /etc/init.d/mysqld start
Starting MySQL................................................................................................................................................................................................................................................................................[failed].............
请教大家了,我该怎么做??? |
|