Mysqld:out of Memory solution (MySQL)

Self-configured Xwamp environment, the default is not detailed configuration of MySQL My.ini, on the one hand, different server configuration, on the other hand, the default is empty the way has not experienced problems. But recently the server hangs up, the symptom that appears is:

The website cannot be opened, dynamic. Static is possible.
Cannot remote Desktop.

To view the system log after forcing a restart of the server This error was found:

Mysqld:out of memory (Needed 129040 bytes)

So we found a few recommended profiles in the MARIADB root directory:

My-small.ini: Memory is less than 64M.

My-medium.ini: Memory is between 32m-64m.

My-large.ini: Memory is 512M.

My-huge.ini: Memory is between 1g-2g

My-innodb-heavy-4g.ini: Memory 4GB, use only InnoDB storage engine.

The suspended server is 2 cores (CPU) 2GB (memory), the recommended configuration for My-large.ini is selected, and the following configuration is added (placed under [Mysqld] ):

Skip-external-locking
Key_buffer_size = 256M
Max_allowed_packet = 1M
Table_open_cache = 256
Sort_buffer_size = 1M
Read_buffer_size = 1M
Read_rnd_buffer_size = 4M
Myisam_sort_buffer_size = 64M
Thread_cache_size = 8
Query_cache_size= 16M
Thread_concurrency = 4

There should be no problem. The front end prompts the user to upgrade the Internet Explorer code: Happy Browsing (http://browsehappy.osfipin.com/). win2008 Error Event (OK I'm using Windows as Server, embarrassing):

The above is to solve the mysqld:out of memory problem thinking.

Mysqld:out of Memory solution (MySQL)