mysql innodbuffer修改_mysql修改 innodb_buffer_pool 大小笔记

mysql> show global variables like 'innodb_buffer_pool_size';

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

| Variable_name | Value |

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

| innodb_buffer_pool_size | 134217728 |

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

1 row in set (0.00 sec)

mysql> show global status like 'Innodb_buffer_pool_pages_data';

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

| Variable_name | Value |

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

| Innodb_buffer_pool_pages_data | 1728 |

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

1 row in set (0.00 sec)

mysql> show global status like 'Innodb_buffer_pool_pages_total';

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

| Variable_name | Value |

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

| Innodb_buffer_pool_pages_total | 8191 |

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

1 row in set (0.00 sec)

mysql> show global status like 'Innodb_page_size';

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

| Variable_name | Value |

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

| Innodb_page_size | 16384 |

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

1 row in set (0.00 sec)

mysql> SET GLOBAL innodb_buffer_pool_size=1073741824;

Query OK, 0 rows affected (0.01 sec)

或vim /etc/my.cnf

[mysqld]

innodb_buffer_pool_size = 1073741824