innodb 体系结构--------内存结构

innodb 的内存结构

    

innodb的内存结构分为3部分，分别是：buffer pool ，red log buffer，additional  memory pool。这三个缓冲池由：innodb_buffer_pool_size,innodb_log_buffer_size,

innodb_additional_mem_size决定。

mysql> show variables like 'innodb_buffer_pool_size';

+-------------------------+----------+

| Variable_name           | Value    |

+-------------------------+----------+

| innodb_buffer_pool_size | 46137344 |

+-------------------------+----------+

1 row in set (0.00 sec)

mysql> show variables like 'innodb_log_buffer_size';

+------------------------+---------+

| Variable_name          | Value   |

+------------------------+---------+

| innodb_log_buffer_size | 1048576 |

+------------------------+---------+

1 row in set (0.00 sec)

mysql> show variables like 'innodb_additional_mem_pool_size';

+---------------------------------+---------+

| Variable_name                   | Value   |

+---------------------------------+---------+

| innodb_additional_mem_pool_size | 2097152 |

+---------------------------------+---------+

1 row in set (0.00 sec)

\

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24003562/viewspace-706629/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24003562/viewspace-706629/