Shulou(Shulou.com)05/31 Report--

This article shows you how to dynamically modify innodb_buffer_pool_size online in MySQL5.7. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

In previous versions of MySQL5.7, innodb_buffer_pool_size could not be modified online and could only be modified by restarting the MySQL process. MySQL5.7 begins to be able to dynamically modify its size online.

In the MySQL5.6 test environment:

Click (here) to collapse or open

Mysql > select version ()

| | version () |

| | 5.6.36 |

View innodb_buffer_pool_size size

Click (here) to collapse or open

Mysql > show variables like 'innodb_buffer_pool_size'

| | Variable_name | Value |

| | innodb_buffer_pool_size | 134217728 | |

Modify innodb_buffer_pool_size size

Click (here) to collapse or open

In the MySQL5.7 test environment:

Mysql > set global innodb_buffer_pool_size=500*1024*1024

ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable

Click (here) to collapse or open

Mysql > show variables like 'innodb_buffer_pool_size'

+-+ +

| | Variable_name | Value |

+-+ +

| | innodb_buffer_pool_size | 536870912 | |

+-+ +

Modify the innodb_buffer_pool_size size:

Click (here) to collapse or open

View the innodb_buffer_pool_size size:

Click (here) to collapse or open

Mysql > set global innodb_buffer_pool_size=800*1024*1024

Query OK, 0 rows affected, 1 warning (0.00 sec)

Mysql > show variables like 'innodb_buffer_pool_size'

+-+ +

| | Variable_name | Value |

+-+ +

| | innodb_buffer_pool_size | 939524096 | |

+-+ +

Mysql > select version ()

+-+

| | version () |

+-+

| | 5.7.18-log |

+-+

View the current innodb_buffer_pool_size size.

The above is how to dynamically modify innodb_buffer_pool_size online in MySQL5.7. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.