Forums

How to avoid 'max_user_connections' resource (current value: 3) in MySQL

I was working with mysql in my web app. When I was testing it, I got 'max_user_connections' resource (current value: 3) error. So I am worried that if four or more users visit a web page which need mysql connection at same time, my web app may halt up and I need to reload it. So how do you guys deal with it? Do you make a queue(I think it is difficult as WSGI runs in multiprocessing)?Or any better idea?

We give you enough connections that each of your workers can get a connection, so as long as you ensure that your connections are being closed or properly managed, you don't need to worry.

Oh, that's great, thanks for your explain.