Detailed explanation of how to reduce memory usage in MySql

Preface

By default, MySQL will initialize a large memory block to cache database query data.

But my small host only has 640MB of memory, and top query found that it ate up 30% of my total memory, almost 200MB.

But there are only a few MB of data in this database, and this setting feels unreasonable.

After searching the article, I finally reduced the memory usage to 128MB

Implementation

Modify /etc/mysql/mysql.conf.d/mysqld.cnf directly

Add the following configuration at the end of the configuration

performance_schema_max_table_instances=150
table_definition_cache=150
table_open_cache=64

Then restart the service with service mysql restart

Effect

Before optimization

After optimization

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.