mysql innodb_log_buffer_size和 innodb_buffer_pool_size设置

来源：互联网发布：网络水军公司企推网编辑：程序博客网时间：2024/05/17 08:28

mysql>  show variables like '%binlog_cache_size%';+-----------------------+----------------------+| Variable_name         | Value                |+-----------------------+----------------------+| binlog_cache_size     | 131072               |  | max_binlog_cache_size | 18446744073709547520 |+-----------------------+----------------------+binlog_cache_size  128K:mysql> show variables like '%log_buffer_size%';+------------------------+---------+| Variable_name          | Value   |+------------------------+---------+| innodb_log_buffer_size | 8388608 |  +------------------------+---------+1 row in set (0.00 sec)innodb_log_buffer_size  =8Mmysql> show variables like '%buffer_pool_size%';+-------------------------+-----------+| Variable_name           | Value     |+-------------------------+-----------+| innodb_buffer_pool_size | 134217728 |+-------------------------+-----------+1 row in set (0.00 sec)调整这两个参数大小:innodb_log_buffer_size=8M 用默认值就行innodb_buffer_pool_size=1280Mmysql> show variables like '%innodb_log_buffer_size%';+------------------------+----------+| Variable_name          | Value    |+------------------------+----------+| innodb_log_buffer_size | 83886080 |+------------------------+----------+1 row in set (0.00 sec)mysql> show variables like '%innodb_buffer_pool_size%';+-------------------------+------------+| Variable_name           | Value      |+-------------------------+------------+| innodb_buffer_pool_size | 1342177280 |+-------------------------+------------+1 row in set (0.00 sec)

0 0