17 mysql物理结构-日志文件-inodb恢复日志

操作：


1. 查看 有关 innode

mysql> show variables like 'innodb_log%';
+---------------------------+---------+
| Variable_name             | Value   |
+---------------------------+---------+
| innodb_log_buffer_size    | 1048576 |  缓冲区大小
| innodb_log_file_size      | 5242880 |  日志的大小5MB
| innodb_log_files_in_group | 2       |
| innodb_log_group_home_dir | ./      |
+---------------------------+---------+
4 rows in set (0.00 sec)

2.查看 innode_log_fize_size 位置

mysql> show variables like '%datadir';
+---------------+----------------------+
| Variable_name | Value                |
+---------------+----------------------+
| datadir       | /opt/mysql5151/data/ |
+---------------+----------------------+
1 row in set (0.00 sec)
mysql>

3.在 /opt/mysql5151/data/下 ，lb_logfile0 大小5MB

ywx@ywx:/opt/mysql5151/data$ ls -lh
-rw-rw---- 1 ywx ywx  5.0M 2011-08-04 21:18 ib_logfile0
-rw-rw---- 1 ywx ywx  5.0M 2011-08-03 16:56 ib_logfile1