There was a web-portal i made for a developer and the page-view is really high, and it is showing the error- resolved now sha.

So webhosting guys :: What is the way forward? Upgrading the server?

Server log:

[14-Oct-2011 12:41:50] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /home/xoxo/public_html/dbase/mysql.php on line 4

Lest i forget, another relevant thread is http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

dhtml .:

Lest i forget, another relevant thread is http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

this is good. but i will also recommend using APC extension http://php.net/manual/en/book.apc.php
its a great means to avoid some much connections to your DB.
u can test it on your local server with ZWAMP. it's cool http://zwamp.sourceforge.net/

APC doesn't come bundled with PHP so this may not work well for dudes on shared hosting if their hosts don't already have this installed or r not willing to have it installed.

You don't need a server upgrade. If you have root access to the server you can either follow the APC suggestion above or increase the max_connection.

I have a question though. The default value is 150 (+1 for super users). So in a scenario where 300 people visit my web application all within the same period of time and are making extensive use of it. . . I will get this error at some point where all the 150 connections are in use? #stupidQuestion

Dual Core:

APC doesn't come bundled with PHP so this may not work well for dudes on shared hosting if their hosts don't already have this installed or r not willing to have it installed.

You don't need a server upgrade. If you have root access to the server you can either follow the APC suggestion above or increase the max_connection.

I have a question though. The default value is 150 (+1 for super users). So in a scenario where 300 people visit my web application all within the same period of time and are making extensive use of it. . . I will get this error at some point where all the 150 connections are in use? #stupidQuestion

the funny ans is "YES" but on one condition (if all they users are querying the db at the same time. look a the db connection as a meal ticket that your issue to hungry client if the meal tickets are all issued out, the rest client will have to wait for some tickets to be return . at that time you tell the people on the queue that mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>" and mind you is a warning not error).

i know that APC is not part of the core PHP package and that is why i referred to the zwamp server(for testing purpose).
the solutions is for VPS.
if in any situation you have a critical application then shared hosting is not a good option to you.
a quick solution is to use php sessions too.

Yea if they querying at the same millisecond (depending on the length of the query), right?
That's a relief.


BTW, I get clients asking for SSL or dedicated IP allocation for their shared hosting account and in my head I just wonder. I still have to politely tell them how its not logical to have SSL (which requires a dedi IP) on a shared server and how it doesnt make much sense to put anything that secured on a shared account. . . VPSes are the way forward for those.

Dual Core:

Yea if they querying at the same millisecond (depending on the length of the query), right? 
That's a relief.


BTW, I get clients asking for SSL or dedicated IP allocation for their shared hosting account and in my head I just wonder. I still have to politely tell them how its not logical to have SSL (which requires a dedi IP) on a shared server and how it doesnt make much sense to put anything that secured on a shared account. . . VPSes are the way forward for those.

i recently found out that is cheater to have your own vps than putting different apps on little shared hosting packages.
one of the benefit is centralization of all clients apps another is that when u install extensions that optimize application and user bandwidth your small client can have the bonus and we promote your company consciously or sub-consciously

Thanks guys for your contributions.

This is the handi-work of the spam bot again. . .

Hmmmm am guessing, if the information is common to all users then the information can be cached, but if its specific to each user, then a sort of dynamic caching using session that way second hit reads from File,

I dont quite understand what you are trying to say (scratching my head) - which information are you talking about here?

i made a wrong assumption.

I presumed so, because that your post does not seem to match this thread at all

dhtml or gori-mapa ? isnt that ur signature. nairaland bot again.

I used to face this problem when i was developing my db wrapper class. What i did was to optimize my codes so that only one connection is open per page load no matter how many files were included. I kept the first connection alive and made sure i did not reconnect to mysql throughout a page.

It worked for me because there were too many connection calls while processing a page. This error was in my class though, not that 150 people were visiting my page simultaneously.

If you are using a framework and including so many files to generate a page, make sure you are not starting a new connection on every included file.

This is exactly how i work - but the site is a high-traffick site - because a lot of money transaction goes on simultaneously.