Topic: Postviews causing CPU overload?

[multiplex77]

Hi,

My website recently got suspended because my web host claims I overloaded their CPU.

mysql_slow_queries log kept showing a line like this:

# Tue Aug 19 00:07:45 2008
# Query_time: 10  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use theonlj8_DB01;
UPDATE wp_postmeta SET `meta_value` = '1219126055' WHERE meta_key = '_edit_lock' AND post_id = '1016' LIMIT 1

Is this anything to do with WP-Postviews? If so, what can I do to fix it? (I"ve already upgraded to the latest version.)

[GaMerZ]

That has nothing to do with wp-postviews, but I would say time to change your host. They are basically squeezing thousand over sites into 1 server and overselling.

[multiplex77]

Ok thanks much, Lester.

[GaMerZ]

No problem, there are quite a few topics on it, http://wordpress.org/search/slow+queries?forums=1

[drawab]

I too have been having this CPU overload problem -

This month my site http://teeth.com.pk/blog being hosted on a MediaTemple Grid Server package clocked in 122 GPU minutes for the month - accounting for 11.3% of all usage. 

Though I cant blame it entirely for my overload but it sure is significant. 

Sharing with you this months GPU report  'name' '%-age' & 'Total GPU minutes'

GET teeth.com.pk/blog/wp-content/plugins/wp-postviews/wp-postviews.php 11.34%    122.9833
GET    teeth.com.pk/blog/feed  10.24%    111.0115
GET    teeth.com.pk/blog/     4.23%    45.8763
GET    teeth.com.pk/blog/feed/   2.45%    26.5168

[GaMerZ]

Are you using WP-SuperCache? Because by default, WP-PostViews will not be called, WP-SuperCache requires the updating of post views count to be done by AJAX and hence the load.

[iceq]

Hey GamerZ .

Are u saying that we shouldnt use WP-SuperCashe with Wp Post views ?

I am using Ajaxed Wordpress and WP SuperCashe with Wp Post Views... is there a problem in that 

btw, I didnt notice any change afer installing super cashe .. did I misconfigure it or maybe expect too much from it ?
will I lose anything if I uninstall it ?

THANX !

[GaMerZ]

Technically, if you are on high traffic site that requires caching, I would not recommend you using any front end plugins at all. Because either they don't work or they need to use AJAX and JS to keep the site updated with the latest information from the plugin.

Perhaps you can consider virtual private server (VPS) if you are on high traffic site, it will be much better.

[iceq]

Excuse my slow comprehension;

So is cashing better for high traffic sites and not good for low traffic sites ? And what do u mean by front end plugins ? Is psotviews a front end plugin, or is Ajaxed WP a front end plugin ?

And what if "they need to use AJAX and JS to keep the site updated with the latest information from the plugin" ?? And what plugin are you referring to here ?

I know that my questions can be irritative, but am really confused and I wish you answer my Questions the simplest way U can..
 do I benefit from WP supercashe ?
Does Supercashe conflict with Ajaxed WP ?
And does Post views work okay if these two are installed and activated, or should I disable one of them , and which one of them ?

THANX

[GaMerZ]

1. PostViews is a frontend plugin.
2. Plugins like my WP-Polls, Wp-PostRatings and WP-PostViews
3. I have no idea
4. You need to test it yourself. I don't normally test my plugins against others because of the lack of time and they are just too many plugins out there.

[iceq]

Okay Thanx for everything ..