Database connections

[Saha]

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 ?

[Traumflug]

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