The Ultimate Guide to High Availability with MariaDB

Red Hat 6 Process Limit a Errors

When upgrading from MySQL 5.1 to MariaDB 5.5 you may encounter a process limit problem with your MariaDB installation. This is not MariaDB at fault. The issue is likely triggered with high connection counts to the database and possibly exacerbated by not using Thread pooling.

You might encounter the following error message if you are not out of available memory:

##SQLSTATE[HY000] [1135] Can't create a new thread (errno 11);##

You can consult the manual for a possible OS-dependent bug when trying to connect. There is a very good explanation and troubleshooting with a work around on the Percona MySQL Performance Blog

Review your connections and thread consumption usage prior to doing an upgrade to avoid this being a problem.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.