MySQL out of memory error

[Former Member]

Hi All,

We are getting below exception in our application most of the times recently and then servers average CPU fluctuates from normal to high (70%-90%). We are using MYSQL DB.

Caught throwable java.sql.SQLException: null, message from server: "Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug"

Does anybody encountered similar issue in your hybris application?

[geffchang]

What is the Hybris version - a.b.c.d? What is the mySQL version? What is the OS and version?

[Former Member]

Hybris 6.5 and the mysql version is 5.6 and OS is Ubuntu 16.04

[Former Member]

Can you please try putting

 [mysqld]
 innodb_file_per_table=OFF
 innodb_flush_log_at_trx_commit=0

in the my.cnf file and check.

thanks,

[Former Member]

Hi ,

Can you please let me know if the solution above worked for you .

thanks,