0
Good evening, everyone.
Dude I hate this mistake and I have no idea how to fix it. I’m closing the connection with the bank after every request but still.
I am using PHP.
Someone knows how to fix this?
exceeded the 'max_user_connections' Resource (Current value: 3)
There may be some query taking too long, thus reaching the maximum of simultaneous connections. Check on
my.cnfand then give aSHOW PROCESSLIST. If the number of processes is equal to or close to that defined in my.cnf, this is the reason. Something that can solve, besides expanding the limit and changing theISOLATION LEVEL, this way perhaps more querys can be executed "at a time" among other things.– Inkeliz
Where do I access this my.cnf? Because this happens when I access online, in the normal access place.
– Pedro Soares
This depends on your server. You need access to
root, first. It is usually/etc/my.cnfor/etc/mysql/my.cnf. Edit themax_user_connections.– Inkeliz
I’m at a free Hostinger Lodge to test the project
– Pedro Soares
Shared hosting (and some VPS) does not allow you to change this. In this case I recommend you migrate to smaller cloud servers such as Digitalocean and also Linode. They cost $5 and $10 per month, respectively, and are charged per hour, canceling before paying only what you used. Easily find discount coupons and references that still guarantee a balance of 10 dollars. Linode still offers a refund if you can’t use it. There are other options like Rackspace (being more expensive, at least 75 dollars per month), as well as Amazon and Google Cloud. I think the best option.
– Inkeliz
Yeah, it’s really a problem where you host your site, etc. It’s not even a matter of closing the connection. Aff kkkk. Thanks man
– Pedro Soares