innodb跟oracle差不多,也是用buffer pool来缓存innodb表的信息,以达到降低磁盘IO的目的。
innodb_buffer_pool_size:指定buffer_pool_size的总大小。
innodb_additional_mem_pool_size:指定用来存储数据字典信息以及其它内存数据结构的信息,不需要太大。
innodb_max_dirty_pages_pct:指定buffer pool中脏数据的百分比,达于是这个值后会自动将脏数据写到磁盘。
其它还有一些参数:
mysql> show variables like 'innodb_buffer%';
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| innodb_buffer_pool_dump_at_shutdown | OFF |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_buffer_pool_instances | 8 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | OFF |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 134217728 |
+-------------------------------------+----------------+
8 rows in set (0.00 sec)
mysql> show variables like 'innodb_max%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_dirty_pages_pct_lwm | 0 |
| innodb_max_purge_lag | 0 |
| innodb_max_purge_lag_delay | 0 |
+--------------------------------+-------+
4 rows in set (0.01 sec)