W3C home > Mailing lists > Public > public-webplatform@w3.org > January 2014

Current blog performance problems

From: Renoir Boulanger <renoir@w3.org>
Date: Fri, 17 Jan 2014 01:17:44 -0300
Cc: Etienne Lachance <el@elcweb.ca>, Julee Burdekin <jburdeki@adobe.com>, Doug Schepers <schepers@w3.org>, Ryan Lane <rlane32@gmail.com>
Message-Id: <DF8C5C5D-6B91-4EDE-8CF7-C935ACB555A4@w3.org>
To: List WebPlatform public <public-webplatform@w3.org>
Hi all,

Regarding the blog performance problem. I have a few questions and some plan to improve the situation.

I have a question or two about the blog that concerns content authors and who installed plugins in the blog.

So, here is my questions:
1. Would it be OK that we purge article revisions? (See [1])
2. Do we still need ‘WebPlatform Authentication’ plugin at the moment? (I just disabled it)


Explanation

In the last days, we had to ‘flush hosts’ because the blog was using too many connections.

Simply increasing maximum connection can do for a while, but it is not a viable permanent solution.

This makes me wonder if something is left unfinished in the server installation.  A detail that did not get applied by salt… or got un-done.

Besides the fact that it fails with too many database connections, I am wondering what else we can do to improve the blog problems.

1. Upgrade from WordPress 3.6 to 3.8
2. Follow suggestions in [1]
3. Double check all W3 Total Cache installation steps

Most of the recommendations of things to improve responsiveness are already done (e.g. using W3 Total Cache, few plugins as possible, etc.).

What is left is to make sure all is running properly and possibly optimize the database indexes.

I might have to spend some time analyzing blog database queries from the complete log I collected months ago and see if I can create new indexes. This last step is suggested in [1] and also might help us

Questions, suggestions?

  [0]: http://stackoverflow.com/a/3898310/852395 and http://stackoverflow.com/a/11410734/852395
  [1]: http://codex.wordpress.org/High_Traffic_Tips_For_WordPress

Renoir 
~


Received on Friday, 17 January 2014 04:17:58 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 6 January 2015 21:20:57 UTC