Re: [Fofredux-devel] Reduce cpu usage?

[Miles B. <mil...@gm...>]

Here is the log of the cpu utlization. Is there a way to find out
which feed is taking so long?

--------------------------------------------------------------------------------
CPU Exceeded Log For Thu Oct 26 11:30:55 2006

  Thu Oct 26 11:30:30 2006: used  0.19 seconds of cpu time for HTTP
Request: : GET /?feed=rss2 HTTP/1.0
  Thu Oct 26 11:30:50 2006: used  41.00 seconds of cpu time for [[mysql query]]
--------------------------------------------------------------------------------
CPU Exceeded Log For Thu Oct 26 11:31:16 2006

  Thu Oct 26 11:30:30 2006: used  0.19 seconds of cpu time for HTTP
Request: : GET /?feed=rss2 HTTP/1.0
  Thu Oct 26 11:30:50 2006: used  41.00 seconds of cpu time for [[mysql query]]
--------------------------------------------------------------------------------
CPU Exceeded Log For Thu Oct 26 11:31:32 2006

  Thu Oct 26 11:30:30 2006: used  0.19 seconds of cpu time for HTTP
Request: : GET /?feed=rss2 HTTP/1.0
  Thu Oct 26 11:30:50 2006: used  41.00 seconds of cpu time for [[mysql query]]

On 1/31/07, Evan Roth <eva...@gm...> wrote:
> i would start by checking the feeds more intermittently.
> you can set a cron for each feed to:
> http://yourhost/fofinstall/update.php?feed=XX
> (see the link if you mouseover the u (for update) in the frameview)

Thanks for the suggestion on spacing out the cron jobs. But having 48
seperate cron jobs kinda is overkill.

I did notice that when you click on the Edit link for a feed you can
set an update interval. I tried setting a feed to a one minute update
and it did not seem to work. Using this method (if it worked) I could
set up half my feeds to be every 30 minutes, and the other half to be
every 60 minutes. Though even this would not solve the problem as it
is an excessive mysql query which seems to be the culprit.