Will mySQL runout

unixmiah

I am working on a site that was fairly good traffic. My concern is when will mySQL freeze or runout of request if you get a lot of people connecting to the database?

Can any 1 please tell me if that's possible. Or what I can do to increase the power to the database for more traffic.

unixmiah

does PHP/mySQL scale well when you get a lot of traffic on your site.

Question 1: How many connection can mySQL withstand. Will it ever freeze or give error because of too many connection?

Question 2: Will php stop working when you have massive traffic?

Question 3: Do you have to configure php/mysql to handle a lot of traffic??

somebody please assist me with this.

zalath

I recently ran into the too many connections problem. The site I was working on was administrated with a Delphi application - or actually, two apps. At worst, there were 30 ppl using the apps, which effectively grabbed 60 connections out of the default 100, which was when PHP started shouting MySQL-error: too many connections.

Normally this wouldn't happen, unless you use persistent connections. Make sure you close all connections to the database when your script is done with it.

Also if you're really worried, you could ask your server admin to increase the max_connections-variable in mySQL.

-L-