[wp-hackers] Persistent connections

[Andrew Gray]

Thanks for the idea, but Rackspace Cloud Sites does not let me make changes to the mysql.   Rackspace Sites is a shared LAMP stack with minimal options, but no support requirement on my end.

it is a different option then the Rackspace cloud sites, which gives you a virtual server.  All I get is FTP access and .htaccess for Apache and no real changes to MySQL.  

Andrew


On Mar 18, 2010, at 11:35 AM, Matt Martz wrote:

> 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_______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers