[wp-hackers] Persistent connections

Matt Martz matt at sivel.net
Thu Mar 18 15:35:31 UTC 2010


Assuming for a minute that you are using cloud servers try downloading mysqltuner.pl and running it.  It could show you a number of settingss that you may be able to tweak to get better performance out of mysql.

"Andrew Gray" <andrew at graymerica.com> wrote:

>Does anyone have an opinion on using persistent DB connections (altering the DB.php to user mysql_pconnect instead)
>Has anyone with a high volume site seen an improvement by making this change.  
>
>I am looking for a way to stop getting limited by the max number of connections from my host.
>I get about 5 Million page views per month and have a lot of commentors (so the page level caching and DB caching is not alway appropriate.  My pages average 30 DB queries per page and under about .4 second query time)
>I am hosted at the Rackspace Cloud and have a max connection setting of 500.   
>
>thanks for the advice,
>
>Andrew
>_______________________________________________
>wp-hackers mailing list
>wp-hackers at lists.automattic.com
>http://lists.automattic.com/mailman/listinfo/wp-hackers

--
Matt Martz
matt at sivel.net


More information about the wp-hackers mailing list