Thread Rating:
  • 375 Votes - 3.02 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Featurific Caused Server Overload
04-25-2009, 01:03 AM
Post: #1
Featurific Caused Server Overload
First of all, I love this plugin! However, I was forced to disable it after my hosting service shut my site down. I was using the latest version of Featurific (which I believe is when the problems started) on Wordpress 2.7.1. Apparently, the plugin was causing an overload on the database and CPU. I narrowed it down to Featurific by disabling all other plugins. Once Featurific was enable, the server resources spiked. Unfortunately, I don't have any specific errors to report other than the SQL query that was happening when the server overloaded:

SELECT wp_posts.ID, wp_posts.post_title FROM wp_posts LEFT JOIN wp_pageviews ON wp_posts.ID = wp_pa

Hopefully this can be fix, cuz I LOVE this plugin! Thanks!
Find all posts by this user
04-30-2009, 03:45 AM
Post: #2
RE: Featurific Caused Server Overload
Hi Kevin,

Sorry to hear that you're having problems with Featurific. Can you tell me how many posts you have on your Wordpress installation?

-Rich
Find all posts by this user
04-30-2009, 04:03 AM
Post: #3
RE: Featurific Caused Server Overload
thanks for the reply! To answer your question, I have approx. 2,200 posts on my installation. I've recently tried various settings in Featurific, such as the database vs. file setting and plugging in my own article numbers vs. having it return the most popular. All of them cause my hosting's servers to crash. Once I disable the plugin, server stability is fine. I'm halfway tempted to set up my own test server so I can try to replicate the problem and see what's going on. Any suggestions on what could be causing this would be great... thanks!

(04-30-2009 03:45 AM)rinogo Wrote:  Hi Kevin,

Sorry to hear that you're having problems with Featurific. Can you tell me how many posts you have on your Wordpress installation?

-Rich
Find all posts by this user
05-06-2009, 03:28 AM
Post: #4
RE: Featurific Caused Server Overload
Hi again Kevin,

We've have noticed some performance issues related to using Featurific on a site with a large number of posts. An SQL 'left join' is known to be a performance bottleneck, but even for 2,200 rows, it shouldn't be causing this much of a problem. However, until we can figure out what the problem is, there seems to be a workaround. Please read the following post, experiment a bit, and let me know if it works for you.

http://featurific.com/support/thread-68-...tml#pid222

Talk to you soon,
-Rich
Find all posts by this user
05-08-2009, 11:00 PM
Post: #5
RE: Featurific Caused Server Overload
Thanks Rich, I'll give this a try!
Find all posts by this user
06-16-2009, 11:02 AM
Post: #6
RE: Featurific Caused Server Overload
Kevin,

Did the workaround help?

-Rich
Find all posts by this user
06-20-2009, 05:46 AM
Post: #7
RE: Featurific Caused Server Overload
No, actually it didn't and I've had to give up working on this and just not use the plugin. Whenever I simply enable the plugin, it crashes my hosts' server and they shut my site down. So until I can get a test server to play with, I won't be able to use this plugin. thanks though!

(06-16-2009 11:02 AM)rinogo Wrote:  Kevin,

Did the workaround help?

-Rich
Find all posts by this user
06-23-2009, 05:54 AM
Post: #8
RE: Featurific Caused Server Overload
I understand, Kevin. When you'd like to look into it again, let me know. Smile

Happy blogging!
-Rich
Find all posts by this user
06-23-2009, 08:39 AM
Post: #9
RE: Featurific Caused Server Overload
Kevin,

Just one last thought - I'm trying to fix this issue, but I need a bit more info. Can you post a link to your website so I can investigate? And just to make sure I understand what you've tried, you did try changing "'numberposts' => FEATURIFIC_MAX_INT," to "'numberposts' => 500," (etc) as described in the other post I linked to, correct? And Featurific still causes the overload? Or, it just doesn't work?

Thanks! Smile
-Rich
Find all posts by this user


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  {solved}featurific stop showing my new articles sidegrev 3 4,353 04-06-2011 02:11 AM
Last Post: rinogo
  Featurific for WordPress 3.0? jmek66 1 5,569 01-27-2011 05:12 AM
Last Post: rinogo
  Featurific not working after I installed its latest version Empress_of_Drac 3 4,190 06-30-2010 07:27 AM
Last Post: rinogo
Tongue Can't use featurific with this theme: Stuka 4 5,722 03-03-2010 03:56 AM
Last Post: rinogo
Sad Featurific FATAL ERROR Guest 1 12,676 08-27-2009 01:32 AM
Last Post: rinogo
  CANT USE FEATURIFIC - NEED HELP geek459 1 3,363 08-25-2009 02:34 AM
Last Post: rinogo
  incorrect path in featurific template Guest 1 2,759 04-01-2009 08:30 AM
Last Post: rinogo
  Error message in Server-Logfiles Guest 1 3,197 03-03-2009 04:11 AM
Last Post: rinogo
  Site Errors happening with Featurific leedman 5 6,486 02-19-2009 04:04 AM
Last Post: rinogo
  Featurific on Explorer vinyltoupee 6 6,003 02-10-2009 04:42 AM
Last Post: rinogo

Forum Jump:


User(s) browsing this thread: