Even though WordPress works pretty well out of the box, there is still a number of optimization tips that can be accomplished to make WordPress function that much better. Vladimir Prelovac has done an excellent job describing ten optimization tips that you can use on your own WordPress installation. The tips and techniques range from optimizing database tables to implementing caching. There should be at least one or two tips within this article that everyone can implement on their own blog.
Here is a sample for you to chew on:
Tip #1: If you are expecting a Digg Front Page you are likely to exceed your current limit of maximum concurrent MySQL connections which is among the prime reasons a site failing a Digg traffic spike.
You can prepare by increasing this number to about 250 using this line in the config file.
max_connections = 250
Check out the full list here (10 Best Tips For WordPress Optimization)
I do not recommend increasing the MySQL connection as this actually can crash the server. If you minimize the connection amount the server can handle all connections and simply delays all additional connections. This may slow down the server and the response time, however it does not crash the server.
I complete agree Thomas, I would never do this either.
Instead, I would use the Super Cache plugin by Donncha to cache static HTML files. Would save a lot of mysql cpu usage using the static html files.
Hi and thanks for the post. I will have to check the tips and see which ones I would actually do.
Yes, I agree with #1 & #2. A lot of servers (specially the cheaper ones) may crash with too many connections, even can ban the customer using big resources. It’s tricky.
Regards!
Nope, increasing your MYSQL connections ain’t such a good idea.
The discussion here reminds me about MySQL connection allowed by web hosts – in fact if you’re hosting your blog on a shared hosting, changing the connection to 250 is impossible as many of them limit the connection to 100 or less.
Of course, there are bunch hosting companies that allow unlimited MySQL connection but we’all knew what does ‘unlimited’ means in hosting business, right? 🙂
Regards, Jerry
I totally agree with Thomas on the comment he made regarding increasing MySQL to 250. It could render you hopeless and trafficless while sleeping and not knowing about it.
As Jonathan Dingman mentioned, caching is the best thing to prevent MySQL from wasting system resources. Naturally, if your blog sits on a dedicated server, then there is no problem at all.
In the past (maybe a two years ago) I wasn’t using caching on my site (not WP) and average loading time got 2-3 times shorter after implementing the caching thing into the core.
Even though it’s now hosted on a dedicated server, it’s still using caching.
those were some nice optimization tips.. we got great SEO plugins nowadays for WP
saw the main post. few really good points.