First things first, you have to work out why your sites are being such a mysql hog. Try minimizing sql calls in your theme (hardcode stuff where possible) and install a caching plugin.

Yes you could have a separate VPS or server for mysql that's separate from your http server but it would be kind of pointless, you may as well just get a decent server for the whole shebang. With 60 blogs, you should be earning enough to get decent hosting for them.

If you put your stuff on a VPS, then you are guaranteed a certain share of resources. Your mysql processes wouldn't be shared with the rest of the users of the server because you have your own mysql instance running on the OS on your VPS; your VPS can't exceed the resource limits assigned to it.

Even with a few wp blog you can get suspended if wp is poorly implemented. Some tips to make your wp install more stable.

1. above mentioned super cache plugin. Wordpress super cache plugin is an extensive modification of the WP-Cache plugin. The wordpress super cache plugin serializes your posts to a
file on disk and later spits them back. It also knows how to update itself when comments are received, etc, so your site is always the most up to date. Note: to use this plugin you must have Mod_Rewrite enabled. Add the following to your .htaccess file: Options +FollowSymLinks RewriteEngine On

2. WP Built-in object cache - The default installation of wordpress can be used to cache database queries. Less database queries = less resources being used . Just add the following line to your
wp-config.php file: // Enable the WordPress Object Cache: define(ENABLE_CACHE, true);

3. Review your plugins - You should go though the plugins you have installed and see if there is a way to make them faster. Any way in which you can make them stop creating database queries and use flat files, or even better, cache
things will help out greatly. If you find that a particurelar plugin is slowing down your wordpress install you should uninstall the plugin or consult the author.

4. If you are doing media-rich applications and serving large files you may want to consider hosting on a vps or dedicated server.

I was actually using it. I think the problem I was having is that there were 60 sites al running the plugin plus xml sitemaps plus duplicate erazer. Every time it ran I was using 75% of their server resources. Other customers complained.

I'd say that if you are using too much MySQL resources, you are trying to load too many articles into your web site, try focusing your keywords and better target your content.

Click to expand...

My keywords almost match my domain on every blog and I generally just use bllog search combined with an RSS feed delivery of Google alerts. I don't think this is in any way a bad reflection on any one plugin or combination of plugins I was using. It was just a matter of slamming a shared host with 60 autoblogs. When I switched to IX I made it clear what I was going to do and they said " it shouldn't be a problem but if it becomes one it will be an easy fix" This was far from an easy fix experience.

The only reason I chose to stay with shared hosting and not go to a VPS before going to IX was they gave away 15 unique Ips and 3 domains.

Ill get a Hostgotor VPS as soon as I am able and swap a load of my sites over there and keep 15 with ix to keep the 15 free ip's. I just tried switching one of my blogs from Wp super cache to hyper cache and I got a notice to edit my wp-config file that I never got with any other cacheing plugin. Could it be that I wasn't actually caching before?

Maybe I should just give up on Wordpress and go back to simple static page sites?

I think I actually have this figured out now. I think my cacheing is broken.

I just tried to change Cacheing plugin from WP supercache to w3 total cache and when I went to enable w3 I get this..

The path found in the database (/home/users/web/b1769/moo.southiecab/bostoncabtaxi//wp-content/uploads) is inconsistent with the current paths found on your server. Please manually adjust the upload path either in miscellaneous settings or in the site's edit page if in network mode.

I don't suppose you can give me some hint how to fix it? I think that Moo bullshit is left over from when I was hosting with FATCOW

Sounds like you just need to edit the path variable in that file to whatever the correct path is.

The error message, "WP Super Cache is installed but broken. The path to wp-cache-phase1.php in wp-content/advanced-cache.php must be fixed!" appears at the end of every page. Open the file wp-content/advanced-cache.php in your favourite editor. Is the path to wp-cache-phase1.php correct? This file will normally be in wp-content/plugins/wp-super-cache/. If it is not correct the caching engine will not load.

Slightly tricky. Basically you just have to open advanced-cache.php and wp-cache-config.php in wp-content/plugins/wp-super-cache and edit the value of WPCACHEHOME and possibly CACHEHOME. Probably easiest just to put in a support ticket and let the techs sort it out.

Also check the admin panel for super cache and see if it tells you anything informative.

Note that adblockers might block our captcha, and other functionality on BHW so if you don't see the captcha or see reduced functionality please disable adblockers to ensure full functionality, note we only allow relevant management verified ads on BHW.