We got the Too many connections error issues in Shopware, It may be someone try to access the database continuously. Please provide the solution to fix this issue. Thanks.
Hi,
this is not a general shopware issue. Usually the error indicates, that either your number of connections on your MySQL server is not high enough or you are having a lot of traffic, that cannot be handled by MySQL any more. If I remember correctly, the default connection limit of MySQL is around 1000 which should be sufficient for most typical shops.
You need to be aware, however, that depending of your Shopware version, Shopware will create up to two DB connections per request (one for the stack, one for the session). For that reason, we recommend to make use of session handlers such as redis or memcached (Shopware Session handling). This will generelly reduce the number of requests hitting the database.
Of course you should also make sure, that the database cannot be accessed from outside of your network.
Best regards
Daniel
1 „Gefällt mir“