Hi!

  php manual...

        http://www.php.net/manual/features.persistent-connections.php

regards
Marcelo Gulin

Kayra Otaner escribió:
> 
> Hi,
> 
> I am searching for detailed information about persistent connection. I've
> looked at all the web sites just for "persistent" word but always I found
> the same information. All the time people are saying "persistent connection
> is good if you are dealing with lots of small queries".
> 
> Here is my case: This week I've upgraded necessary server software to the
> latest versions of Php and Apache (Php 4.04 and Apache 1.3.14) As I did
> before upgrade I've compiled Php as an Apache Static Module ( mod_so is not
> necessary ) And check MySQL for persistent connection. My site is focused on
> free web services like graphic counter, polls, url redirection, webring and
> news syndication to personal web sites. (www.kelalaka.net, it is Turkish
> only). Only for graphic counter services, it counts 180.000+ hits per day.
> It means 350.000+ queries per day. Day average is 250 query , 60 connection
> per minute, but in popular hours it is very high and MySQL server gives "Too
> many connections" errors. MySQL server is default and set to 100 connection
> at most.
> 
> Yesterday I ordered more ram in order to increase connection number of MySQL
> from 100 to 200+ connection. But today I realized that my server wasn't work
> with persistent connection.
> All the Php code contains mysql_pconnect for MySQL connections. Apache and
> Php works in module type not in cgi mode. I've looked at phpinfo() in order
> to see anything that can indicate status of persistent connection.  It says
> "mysql.allow_persistent is On". But again in phpinfo it says "Active
> Persistent Links 1" . It is sometime changes to "0". In MySQL I am looking
> for active processess by using "mysql" and "show processlist" commands it
> shows me 100 active links but most of them are in sleep state. In php.ini
> there is a line in order to set maximum number of persistent connection and
> I set it to just 25.
> If somebody uses mysql_pconnect's instead of mysql_connect in Php cgi mode,
> he doesn't see any error messages. All mysql_pconnects work like
> mysql_connect.
> 
> My questions :
> 1 - How can users exactly determine whether they are using Php as a module
> or cgi mode? (from phpinfo or ..?)
> 2 - Is it sufficient Php and Apache compiled in static or dynamic module
> version in order to use mysql_pconnects in Php code? Anything to do with
> MySQL?
> 3 - In a Apache + Php module compiled system is it normal to reach more than
> predefined connection number in php.ini? (100 active connection but 25
> defined in php.ini. In phpinfo shows same settings in the php.ini file (it
> shows 25 max persistent connection))
> 4 - Is there any web page containing a real how-to and tutorial about
> persistent connection? (If not I will certainly prepare one in a few weeks
> :-))
> 
> Any kind of help will be appreciated...
> 
> Kayra Otaner
> www.kelalaka.net
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to