Mysql number of connections

harrington

I am learning php and mysql the problem that i am having is how many possible connections mysql will allow using php acording to my textbooks mysql will only allow 100 connections at any one time This is causing me considerable worry as i would want thousands and even millions of people to be able to querie my database at anyone time The database that i have created is located on my isps server using mysql and the php code to interact with that database is located on my isp's cgi gateway

My question is as follows first and formost Is there any limitation on the number of connections to the database that i have created using mysql if so How do you overcome this problem ???

Two :Question two there are two different types of ways that you can connect to a database using php one is two open a conection using mysql_pconnect( "Server Ip or name ", "username","password"); which I understand as being a permanent connection that you have to close when finished with the second is to use mysql_connect( "Server Ip ", Username , password ); this apperently only lasts for the duration of the script. If there are any limitations what do you do can anyone explain this in more detail and how you resolve this problem if at all. I need all the help i can get many thanks

Mark Harrington mark@harrington.force9.co.uk

TheIceman5

whats the average script execution time? .05 seconds? i doubt that you would have 100 or more people querying at exactly the same 500th of a second, youll be fine, dont worry about it. probabaly at most youll have 10-20 people querying it a second on a good second.

superwormy

It is VERY unlikely that you'll ever hit this limit.

Usually you should use mysql_connect(), mysql_pconnect() simply doesn't close the connection, and the next time it's called the script looks for an already open connection before trying to establish a new one. I have not seen any benefit to it, and it actually eats up MORE connections many times, and can make the issue of MySQL not handling enough connections at once more of an issue.