[root@localhost var]# tail -f localhost.localdomain.err
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-10 16:32:31 1842 [Note] Shutting down plugin 'InnoDB'
2016-05-10 16:32:31 1842 [Note] InnoDB: FTS optimize thread exiting.
2016-05-10 16:32:31 1842 [Note] InnoDB: Starting shutdown...
2016-05-10 16:33:31 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:34:31 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:35:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:36:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:37:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:38:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:39:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:40:32 1842 [Note] InnoDB: Waiting for purge thread to be suspended
2016-05-10 16:41:33 1842 [Note] InnoDB: Waiting for purge thread to be suspended
###一直停在这里，大概有10分钟还多，这时候lsof -i:3306 发现端口已经不在监听了，网上搜了下，仿佛是一个bug
没办法了，只好ps aux | grep mysql 找到pid kill 掉，发现kill不了，启动的时候，有下面的报错！
160510 16:41:58 mysqld_safe A mysqld process already exists
2016-05-10 16:42:33 1842 [Note] InnoDB: Waiting for purge thread to be suspended
##不得已只好kill -9 了，虽然我清楚不能使用-9 ，现在万不得已了，kill -9 后，发现mysql相关进程真的没有了，于是/etc/init.d/mysql start
160510 16:43:19 mysqld_safe Starting mysqld daemon with databases from /data/mysql/var
2016-05-10 16:43:20 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-05-10 16:43:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-05-10 16:43:20 0 [Note] /data/mysql/bin/mysqld (mysqld 5.6.24-log) starting as process 18706 ...
2016-05-10 16:43:20 18706 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-05-10 16:43:20 18706 [Note] Plugin 'FEDERATED' is disabled.
2016-05-10 16:43:20 7f97327377e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-05-10 16:43:20 18706 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-10 16:43:20 18706 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-10 16:43:20 18706 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-10 16:43:20 18706 [Note] InnoDB: Memory barrier is not used
2016-05-10 16:43:20 18706 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-10 16:43:20 18706 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-10 16:43:20 18706 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2016-05-10 16:43:21 18706 [Note] InnoDB: Completed initialization of buffer pool
2016-05-10 16:43:21 18706 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-10 16:43:21 18706 [Note] InnoDB: Log scan progressed past the checkpoint lsn 431065305061
2016-05-10 16:43:21 18706 [Note] InnoDB: Database was not shutdown normally!
2016-05-10 16:43:21 18706 [Note] InnoDB: Starting crash recovery.
2016-05-10 16:43:21 18706 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-05-10 16:43:21 18706 [Note] InnoDB: Restoring possible half-written data pages
2016-05-10 16:43:21 18706 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 431070547456
InnoDB: Doing recovery: scanned up to log sequence number 431075790336
InnoDB: Doing recovery: scanned up to log sequence number 431081033216
InnoDB: Doing recovery: scanned up to log sequence number 431086276096
InnoDB: Doing recovery: scanned up to log sequence number 431091518976
InnoDB: Doing recovery: scanned up to log sequence number 431096761856
InnoDB: Doing recovery: scanned up to log sequence number 431102004736
InnoDB: Doing recovery: scanned up to log sequence number 431107247616
InnoDB: Doing recovery: scanned up to log sequence number 431112490496
InnoDB: Doing recovery: scanned up to log sequence number 431117733376
InnoDB: Doing recovery: scanned up to log sequence number 431122976256
InnoDB: Doing recovery: scanned up to log sequence number 431128219136
InnoDB: Doing recovery: scanned up to log sequence number 431133462016
InnoDB: Doing recovery: scanned up to log sequence number 431138704896
InnoDB: Doing recovery: scanned up to log sequence number 431143947776
InnoDB: Doing recovery: scanned up to log sequence number 431146136153
2016-05-10 16:43:30 18706 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
###这里从0 开始到99 ，整个的数据库恢复过程，需要些时间，和库的大小和硬件性能有关系！
InnoDB: Apply batch completed
2016-05-10 16:54:59 18706 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-10 16:54:59 18706 [Note] InnoDB: Waiting for purge to start
2016-05-10 16:54:59 18706 [Note] InnoDB: 5.6.24 started; log sequence number 431146136153
2016-05-10 16:55:00 18706 [Note] RSA private key file not found: /data/mysql/var//private_key.pem. Some authentication plugins will not work.
2016-05-10 16:55:00 18706 [Note] RSA public key file not found: /data/mysql/var//public_key.pem. Some authentication plugins will not work.
2016-05-10 16:55:00 18706 [Note] Server hostname (bind-address): '*'; port: 3306
2016-05-10 16:55:00 18706 [Note] IPv6 is available.
2016-05-10 16:55:00 18706 [Note] - '::' resolves to '::';
2016-05-10 16:55:00 18706 [Note] Server socket created on IP: '::'.
2016-05-10 16:55:00 18706 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
2016-05-10 16:55:00 18706 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.
2016-05-10 16:55:00 18706 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode.
2016-05-10 16:55:02 18706 [Note] Event Scheduler: Loaded 0 events
2016-05-10 16:55:02 18706 [Note] /data/mysql/bin/mysqld: ready for connections.
Version: '5.6.24-log' socket: '/data/mysql/mysql.sock' port: 3306 Source distribution
到了这里，lsof -i:3306 已经在监听了，可以连接了！
##简单记录下！
