Saha Posted August 12, 2018 Share Posted August 12, 2018 i am facing a mysql issue which says status code 1040 too many connections Do we really need to disconnect the database connections manually. Or is it handled by prestashop ? Link to comment Share on other sites More sharing options...
Traumflug Posted August 12, 2018 Share Posted August 12, 2018 Or is it handled by prestashop ? This is thirty bees :-) AFAIK, thirty bees uses exactly one database connection per web request. Code writers know this as "singleton instance". If you see multiple requests open, you apparently have multiple web requests running. Even if a web request connection hangs, PHP times out after 30 seconds, closing the DB connection as well. Reasons you see this error include: PHP is configured to never time out. This way, DB connections can stay open for a long time. MySQL doesn't allow as many users as you get web requests. For help, see https://www.rathishkumar.in/2017/07/how-to-fix-mysql-too-many-connections.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now