MySQL takes up too much memory to solve the problem

MySQL has changed so much, the memory is still around 40MB software.

Now to the official website to download more than 300 MB ... ... what is Oracle doing?

After installation, a direct memory alarm is started.

Open Task Manager See, Mysqld.exe unexpectedly occupies more than 400 MB of memory, my eclipse is more than 300 MB ...

Well, find out why, in order to better performance of the database itself, in the boot time pre-"occupy" a lot of memory.

According to Baidu's results, it can be optimized by modifying the MySQL configuration file.

Where is the ①my.ini file?

If it's like me, Windows is installed by default and can be found under the C:\ProgramData\MySQL\ directory.

② only need to modify the two of these articles.

table_open_cache=2000 instead

table_open_cache=256

table_definition_cache=1400 instead

table_definition_cache=400

③ restart MySQL, and then open Task Manager, Mysqld.exe only accounted for 40M of memory.

MySQL takes up too much memory to solve the problem