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

Just ran the WP-Optimize plugin for Financial Samurai at 11pm PST and as soon as I executed the draft post purge, the site went down for about 8 minutes.  Cleared 26,000 posts.  

Hence, if you plan to run WP-Optimize, do so late at night when your traffic is lowest.  Your site may go down, and you will wonder how the plug-in works if the site is down, but it is working.  

I'll run the plug-in once a month from now on.  Thanks for the tip Eric.  Hope it helps speed and prevents sites from crashing!

My guess is that the first time run will do the most, and so if there is a downtime, you'd probably have much less on subsequent runs.

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.

Hence, if you plan to run WP-Optimize, do so late at night when your traffic is lowest.  Your site may go down, and you will wonder how the plug-in works if the site is down, but it is working.  

I'll run the plug-in once a month from now on.  Thanks for the tip Eric.  Hope it helps speed and prevents sites from crashing!

My host upped my MySQL connection from 30 to 200.  When I asked for them to raise it more, they said that was it.  Do they have the ability to do so, but just don't want to?  Or is it a technical limitation?  How many do you have?

I just ran the WP-Optimize plug-in and it worked, then Yakezie.com went down for 5 minutes.

Has this happened to anybody?  Or is this just coincidence.

I better run the plug-in for Financial Samurai way late into the night just in case the site goes down again.  

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.

What I meant to say was

You could also upgrade your server's PROCESSOR to more RAM to handle the CPU load,

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

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?

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

Donno.  I'll have to take a look later.  Just activated it.  Swamped.  Hope it does!