130305 17:09: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 doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 18163911680
InnoDB: Doing recovery: scanned up to log sequence number 18169154560
InnoDB: Doing recovery: scanned up to log sequence number 18174397440
InnoDB: Doing recovery: scanned up to log sequence number 18179640320
InnoDB: Doing recovery: scanned up to log sequence number 18184883200
InnoDB: Doing recovery: scanned up to log sequence number 18190126080
......
InnoDB: Doing recovery: scanned up to log sequence number 18588584960
InnoDB: Doing recovery: scanned up to log sequence number 18593827840
InnoDB: Doing recovery: scanned up to log sequence number 18596304961
InnoDB: 65 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 167 row operations to undo
InnoDB: Trx id counter is A19B00
130305 17:09:58 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: Apply batch completed
InnoDB: Last MySQL binlog file position 0 83569404, file name /home/mysql/mysql-5.5.20/data.000031
InnoDB: Starting in background the rollback of uncommitted transactions
130305 17:10:26 InnoDB: Rolling back trx with id A19952, 1 rows to undo
130305 17:10:26 InnoDB: Waiting for the background threads to start
InnoDB: Rolling back of trx id A19952 completed
130305 17:10:26 InnoDB: Rolling back trx with id A19941, 1 rows to undo
InnoDB: Rolling back of trx id A19941 completed
130305 17:10:26 InnoDB: Rolling back trx with id A1993A, 4 rows to undo
InnoDB: Rolling back of trx id A1993A completed
130305 17:10:26 InnoDB: Rolling back trx with id A19938, 4 rows to undo
InnoDB: Rolling back of trx id A19938 completed
130305 17:10:26 InnoDB: Rolling back trx with id A19935, 1 rows to undo
......
InnoDB: Rolling back of trx id A19737 completed
130305 17:10:27 InnoDB: Rolling back trx with id A19729, 1 rows to undo
InnoDB: Rolling back of trx id A19729 completed
130305 17:10:27 InnoDB: Rolling back trx with id A19719, 5 rows to undo
InnoDB: Rolling back of trx id A19719 completed
130305 17:10:27 InnoDB: Rolling back trx with id A1970D, 1 rows to undo
InnoDB: Rolling back of trx id A1970D completed
130305 17:10:27 InnoDB: Rollback of non-prepared transactions completed
130305 17:10:27 InnoDB: 1.1.8 started; log sequence number 18596304961
130305 17:10:27 [Note] Recovering after a crash using /home/mysql/mysql-5.5.20/data
130305 17:10:29 [Note] Starting crash recovery...
130305 17:10:29 [Note] Crash recovery finished.
130305 17:10:29 [Warning] 'user' entry 'root@TestMonServer' ignored in --skip-name-resolve mode.
130305 17:10:29 [Warning] 'user' entry '@TestMonServer' ignored in --skip-name-resolve mode.
130305 17:10:29 [Warning] 'proxies_priv' entry '@ root@TestMonServer' ignored in --skip-name-resolve mode.
130305 17:10:29 [Note] Event Scheduler: Loaded 0 events
130305 17:10:29 [Note] /home/mysql/mysql-5.5.20/bin/mysqld: ready for connections.
Version: '5.5.20-enterprise-commercial-advanced-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
130305 17:10:29 [Note] Event Scheduler: scheduler thread started with id 1