mysql innodb log buffer size和 innodb buffer pool size设置

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

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)

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow