Question On Server Load and Downtime | Bloggers Lair | Yakezie Forums

Try the WP-Optimize plugin. It did a lot the first time I ran it, but not much after that. If you run it every month or so, it can make a difference.

It couldn't hurt. That should only be an issue if there is some sort of memory leak in the program. An efficient server/software setup should take care of that.

Sam, did the optimize plugin cut your DB size down?

It only takes about 10 seconds to run once it is installed. Super automated.

I use a tool called P3 Plugin Profiler (from GoDaddy) to help me manage load times overall. I got it down about 50% getting rid of the worst offenders.

Post edited 1:59 pm – June 28, 2012 by Dividend Ninja

Hey Sam,

I haven't been around in a while. But I noticed Yakezie is loading much faster this morning, I haven't seen the site load this fast in ages. So whatever you did – good job :)

My web provider does indeed reset the cache regularily, this helps a lot, and I am not a high traffic site. MySQL is pretty tough and robust, it can handle thousands of requests. You can ask your web host to increase the "Number of MySQL Connections" available past the default since you are obviously exceeding it.

You could also upgrade your server to more RAM to handle the CPU load, and I assume if you are not already hosting on a VPS or better yet a dedicated server (so its only your site loading) etc.- the usual stuff.

 You can also optimize your WordPress code in your header file (header.php), by reducing the number of calls to the DB. This will help tremendously for a large traffic website like yours. See this article:

http://cleverwp.com/speed-up-w…..ader-php 

( /speed-up-wordpress-header-php )

For example, the header file repeatedly calls up this function <?php bloginfo('template_directory'); ?> a few times in the header file (about 4 or 5 times). That's fine for the average blogger, but multiply that by the number of users on your site = 100's of calls to the DB (if not thousands) at any time. Calling up the function once and replacing it with a hard-coded variable will help a lot.

Also WordPress wasn't really designed to handle something like a big community forum, that in itself will slow down the site. What I would suggest is splitting the site on two servers with two installs, one for the Yakezie Site  and one for the Forums. I have no idea how to do it, but big sites obvously split up the site on multiple servers (they also mirror servers but that is beyond any of us).

Cheers

Avrom

MoneyBeagle said:

OneCentAtatime said:

thanks for this, as per the report it just cleaned up 2.5GB space including removing post revisions. Great tool Wait for webmaster to report load time change.

I ran this but didn't remove post revisions because I had this awful feeling that it would remove all my posts.  What exactly does this do?

All those saves/updates you do while editing your posts, actually create a new revision entry. Suppose you write a post and hit 5 saves in between while it was in draft state, and then after publishing you found a mistake and updated once. WP would create 5+1+1 = 7 post revisions. Only the final one is in published status rest all occupy space.

In just 1 year and 3 months and 278 posts, I had 2100 revisions which the plugin removed, you can say I removed those many posts, that's a huge space. And my blog is running fine with 0 post loss. G ahead use this option.

I had a couple problems with plugins and I shut them all down and turned them on one by one – once I found the offender my site started to load quicker.  If you'd like some help doing it I'd be happy to help

OneCentAtatime said:

All those saves/updates you do while editing your posts, actually create a new revision entry. Suppose you write a post and hit 5 saves in between while it was in draft state, and then after publishing you found a mistake and updated once. WP would create 5+1+1 = 7 post revisions. Only the final one is in published status rest all occupy space.

 

In just 1 year and 3 months and 278 posts, I had 2100 revisions which the plugin removed, you can say I removed those many posts, that's a huge space. And my blog is running fine with 0 post loss. G ahead use this option.

Good info, thanks!  I'll probably run a backup first just to be sure.

Sam, your site loads real fast in the mornings. Right now its fast, and it was yesterday morning as well. Then during the day it completely slows down. Have a look at that info on optimizing the WordPress Header – it will help. ;)

Eric, thank you for the tip on WP-Optimize, this looks like a great plugin! I'm sure I have so many revisions I don't need anyore on the Dividend Ninja. Thanx for letting us know.

Cheers