Forums / Install & configuration / Persistent connections
Ivo Lukac
Thursday 07 May 2009 12:46:40 am
Does anybody have experience with persistent connections with mysql database?What about using it in cluster setup (files in database)?
http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac
Tuesday 12 May 2009 4:56:03 am
Nobody?
André R.
Tuesday 12 May 2009 6:16:47 am
Not strictly on topic, but fyi persistent connections are not supported by mysqli.It is added to PHP 5.3, but there is no direct support for it in eZ Publish yet ( will probably add support in 4.2).
Some nice reading on php, mysql and persistent connections:
http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/http://blog.ulf-wendel.de/?p=211
eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Łukasz Serwatka
Tuesday 12 May 2009 6:20:58 am
The setting in eZ Publish decide how the application connect to the database. Basically it is mysql_connect or mysql_pconnect for persistent connections (while using MySQL driver).
In PHP realm you can learn more about it from:
http://pl2.php.net/manual/en/features.persistent-connections.phphttp://pl2.php.net/mysql_pconnect
Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Tuesday 12 May 2009 8:53:13 am
Thanks guys but I know what p-connections are, just want to know does anybody use it on production server, are they stable enough in eZ.
Friday 03 July 2009 2:23:11 am
Ok, one more time :)
persistent connections with mysql. Any experience?
Thursday 09 July 2009 5:20:54 am
Finally got an information on this.There is no persistent connection support in eZ :(
Thursday 09 July 2009 5:59:47 am
False alarm, persistent connection are implemented for mysql and postgres. Not for mysqli.
Thursday 09 July 2009 7:00:02 am
i wonder about other dbs too like Oracle; do they offer this?
Gaetano Giunta
Thursday 09 July 2009 10:47:57 am
Sure enough. On oracle, the connection handshake is much heavier than it is in mysql, so persistent connections are usually faster/recommended. They also have a lot of benefit in internal memory structures reusage and sharing.Otoh you will have to be careful tuning your resource allocation, as it is hard to put a clear limit on max persistent connections open from php to the db (apache max processes + cronjobs + cli scripts run on the spot +maybe more in cluster mode?), and all the connections will usually stay open eating your resources even if there are no users connected to the db, and you will have to be careful of connection state if there is a db restart while apache is running (all of this has been alleviated in recent php versions with some extra params in php.ini dedicated to tuning those aspects).
Principal Consultant International Business Member of the Community Project Board
Friday 10 July 2009 12:29:41 am
Gaetano,
Do you use somewhere pconns on live sites?
Friday 10 July 2009 5:06:47 am
At least two clients do - of those running oracle. Maybe more: those are the ones I worked for personally...
Friday 10 July 2009 6:50:09 am
What about mysql?
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs