Re: Service Keeps Crashing - Got An Error Reading Communication Packets

[Rick James]

Out of memory (Needed 524254 bytes)' -->
The Operating system limits how much RAM it will give to any one process. MySQL is trying to exceed that.

Plan A: Change the setting in the OS.

Plan B: Decrease the biggest setting in MySQL so that it will fit:

These are probably excessive:
query_cache_limit=128M -- 10M
query_cache_size=128M -- 10M
max_connections=500 -- 30

This could be decreased:
key_buffer_size=256M -- 50M