httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Haase-Thomas <...@meome-ag.de>
Subject Re: Need help with connection to sql server
Date Mon, 04 Feb 2002 08:00:29 GMT
Hi,

using mod_perl could help you, because in the startup script you may 
establish persistent db connections. Just put the handles onto an 
Apache::SharedMem segment, write some lock()s and unlock()s around each 
access - and that's it. Hopefully ;)

Regards
Martin

Matt Juszczak wrote:

> Hi,
>
>  
>
> I have a very database intensive site, and lately, the site is getting 
> so popular that our database is beginning to write this to the log files:
>
>  
>
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
> Warning: MySQL Connection Failed: Too many connections in 
> */usr/home/web/shared/global/missing.php* on line *12*
>
> ....and our site is not looking so hot.  It seems that SQL can't 
> handle all the requests at once?  Is there a solution to this 
> problem?  Since our site is always getting pounded, is there a module 
> I can put into apache to speed this up or always keep an SQL 
> connection open?  Or is there a way to open up more connections on the 
> SQL side (I know thats not an apache thing, but if this isn't 
> something I can install into apache, I can contact the mysql mailing 
> list)...could someone let me know?  Thx!
>
>  
>
> -Matt
>
>


Mime
View raw message