[wp-hackers] Persistent connections

[Potkanski, Jason]

Are other plugins in use, such as WP Super Cache?

Is Squid (Caching proxy) in front of your Apache server an option?

Can the cloud site make external MySQL calls? You can create a VPS or dedicated/managed server at Rackspace to get around the 500 connection limit and point the wp-config to a server elsewhere.

--

Jason Potkanski
Tribune Technology

On 3/18/10 11:59 AM, "Andrew Gray" <andrew at graymerica.com> wrote:

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

_______________________________________________
wp-hackers mailing list
wp-hackers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-hackers