Re: Out of Memory errors although MYSQL only uses 3% of RAM

[Peter Brawley]

> InnoDB: Fatal error: cannot allocate memory for the buffer pool

Max possible is about 70% of RAM available to MySQL. Try 16G?

Is https://stackoverflow.com/questions/15694616/mysql-error-cant-create-a-new-thread-errno-11 helpful? Or https://serverfault.com/questions/408845/what-value-of-thread-cache-size-should-i-use ?

If not, review results of ...

show variables like "%thread%";

show status like "%thread%";

and read about each item in the manual.



Edited 1 time(s). Last edit at 08/05/2018 12:59PM by Peter Brawley.