阿里巴巴DBA，原去哪儿网DBA。专注于MySQL源码研究、DBA运维、CGroup虚拟化及Linux Kernel源码研究等。 github:https://github.com/HengWang/ Email：king_wangheng@163.com 微博 ：@王恒-Henry QQ ：506437736
分类： Mysql/postgreSQL
2012-04-27 12:08:11
5、innodb_additional_mem_pool_size测试
参数设置
其他参数的设置为：
|
innodb_log_file_size=4G innodb_log_buffer_size = 512M innodb_buffer_pool_size = 32G innodb_max_dirty_pages_pct=75 innodb_thread_concurrency=16 |
测试结果及分析
测试innodb_additional_mem_pool_size分别为64M、256M、512M时，percona server的性能。
（1）innodb_additional_mem_pool_size为64M情况下得出的TPmC结果：
|
[transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 100.00% [OK] Payment: 100.00% [OK] Order-Status: 100.00% [OK] Delivery: 100.00% [OK] Stock-Level: 100.00% [OK]
18565.732 TpmC |
性能分析如图：
（2）innodb_additional_mem_pool_size为256M情况下得出的TPmC结果：
|
[transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 100.00% [OK] Payment: 100.00% [OK] Order-Status: 100.00% [OK] Delivery: 100.00% [OK] Stock-Level: 100.00% [OK]
18810.717 TpmC |
性能分析如图：
（3）innodb_additional_mem_pool_size为512M情况下得出的TPmC结果：
|
[transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 100.00% [OK] Payment: 100.00% [OK] Order-Status: 100.00% [OK] Delivery: 100.00% [OK] Stock-Level: 100.00% [OK]
18365.900 TpmC |
性能分析如图：
测试结论
通过以上测试，当innodb_additional_mem_pool_size增大时，性能有明显提高，innodb_additional_mem_pool_size主要用于每个缓冲池中的帧缓冲、缓冲控制对象等，都需要从中申请，当innodb_buffer_pool_size很大时，该值也应该相应的增大。但该值不建议过大，在过大的情况下，性能并没有明显增大，反而会因为数据对象变脏而导致缓存命中率降低。
