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