Another problem I'm having is, with "Compiled" installation of MariaDB, aaPanel will auto calculate the resource my server has and suggest the corresponding "optimized" plan/configs.
But the problem is, the calculation might be wrong.
My server only has 4Gb RAM, and aaPanel suggested a plan for 1Gb RAM, but the actual configuration lead to:
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 290238 K bytes of memory
3Gb, and it caused MySQL service to die continuously for lack of RAM (3Gb for MySQL and 1Gb for the rest, include system)
I think we should take a look at this problem, I have like 15 VPS so we can take a look for the difference/investigate if you guys need.
@aaPanel_Jose @aapanel_sniper
