缓冲池大小设置,不易设置,过大,可能会引起oom现象,另外5.7已经支持innodb_buffer_pool在线修改大小,
show variables like ‘innodb_buffer_pool_size’;
±------------------------±----------+
| Variable_name | Value |
±------------------------±----------+
| innodb_buffer_pool_size | 134217728 |
±------------------------±----------+
1 row in set (0.03 sec)
该参数在5.6版本后可以调整为多个,可以理解为将buffer pool划分为多个,可以提高并发,避免在高并发情况下出现内存的争用情况,生产配置56.
show variables like ‘innodb_buffer_pool_instances’;
±-----------------------------±------+
| Variable_name | Value |
±-----------------------------±------+
| innodb_buffer_pool_instances | 56 |
±-----------------------------±------+
1 row in set (0.00 sec)
使用show engine innodb status页可以看到相关情况。
innodb_thread_concurrency
innodb内核最大并发线程数,默认值为0,代表不受限制。
show variables like ‘innodb_thread_concurrency’;
±--------------------------±------+
| Variable_name | Value |
±--------------------------±------+
| innodb_thread_concurrency | 0 |
±--------------------------±------+
1 row in set (0.00 sec)