[EventCalendar] Re: ec3 consuming memory and cpu time?

Wed Jan 16 17:36:13 UTC 2008

to solve the issue of memory and cpu time consuming i've installed the
plugin wp-cache following the instructions of this article for optimizing
wordpress:
http://vallery.net/2007/03/26/optimizing-wordpress-and-lamp-to-survive-the-digg-effect/
lets see if it works.

anyways, here's the mysql log for today, wed 16 jan. i replaced the actual
user name with "dbuser".

2008-01-16 00:36:38 dbuser 1 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2006') OR ((YEAR(start)='2006') OR (start<='2006-0-0
0:0:0' AND end>='2006-0-0 0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date
DESC LIMIT 0, 5

2008-01-16 01:12:42 dbuser 1.2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
ec3_sch.post_id IS NULL  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT
15, 5

2008-01-16 01:58:32 dbuser 1 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
ec3_sch.post_id IS NULL  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT
40, 5

2008-01-16 01:59:06 dbuser 1 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
ec3_sch.post_id IS NULL  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT
45, 5

2008-01-16 02:07:21 dbuser 1.2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2005' AND MONTH(post_date)='8') OR ((YEAR(start)='2005'
AND MONTH(start)='8') OR (start<='2005-8-0 0:0:0' AND end>='2005-8-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 02:24:27 dbuser 1 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
ec3_sch.post_id IS NULL  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT
10, 5

2008-01-16 02:35:23 dbuser 1.2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2005' AND MONTH(post_date)='2') OR ((YEAR(start)='2005'
AND MONTH(start)='2') OR (start<='2005-2-0 0:0:0' AND end>='2005-2-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 5, 5

2008-01-16 05:15:38 dbuser 1.6 SELECT t.*, tt.*, tr.object_id FROM wp_terms
AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN
wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_idWHERE
tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (35) ORDER BY
t.name ASC

2008-01-16 06:22:52 dbuser 1.9 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2007' AND MONTH(post_date)='7' AND
DAYOFMONTH(post_date)='19') OR ((YEAR(start)='2007' AND MONTH(start)='7' AND
DAYOFMONTH(start)='19') OR (start<='2007-7-19 0:0:0' AND end>='2007-7-19
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 07:40:10 dbuser 1.4 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2008') OR ((YEAR(start)='2008') OR (start<='2008-0-0
0:0:0' AND end>='2008-0-0 0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date
DESC LIMIT 0, 5

2008-01-16 08:52:18 dbuser 1.3 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2007' AND MONTH(post_date)='9' AND
DAYOFMONTH(post_date)='1') OR ((YEAR(start)='2007' AND MONTH(start)='9' AND
DAYOFMONTH(start)='1') OR (start<='2007-9-1 0:0:0' AND end>='2007-9-1
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 09:21:16 dbuser 1.3 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2004' AND MONTH(post_date)='12') OR ((YEAR(start)='2004'
AND MONTH(start)='12') OR (start<='2004-12-0 0:0:0' AND end>='2004-12-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 5, 5

2008-01-16 09:54:45 dbuser 1.3 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2007' AND MONTH(post_date)='4') OR ((YEAR(start)='2007'
AND MONTH(start)='4') OR (start<='2007-4-0 0:0:0' AND end>='2007-4-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 10:04:08 dbuser 1.2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2007' AND MONTH(post_date)='4' AND
DAYOFMONTH(post_date)='29') OR ((YEAR(start)='2007' AND MONTH(start)='4' AND
DAYOFMONTH(start)='29') OR (start<='2007-4-29 0:0:0' AND end>='2007-4-29
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 10:27:43 dbuser 2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2007' AND MONTH(post_date)='12') OR ((YEAR(start)='2007'
AND MONTH(start)='12') OR (start<='2007-12-0 0:0:0' AND end>='2007-12-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 10:31:41 dbuser 1.3 SELECT t.*, tt.*, tr.object_id FROM wp_terms
AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN
wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_idWHERE
tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (471) ORDER BY
t.name ASC

2008-01-16 11:15:16 dbuser 2.7 SELECT comment_date_gmt FROM wp_comments
WHERE comment_date_gmt <= '2008-01-16 16:15:14' AND comment_approved = '1'
ORDER BY comment_date_gmt DESC LIMIT 1

2008-01-16 11:22:17 dbuser 3.9 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish') AND
((YEAR(post_date)='2008' AND MONTH(post_date)='1') OR ((YEAR(start)='2008'
AND MONTH(start)='1') OR (start<='2008-1-0 0:0:0' AND end>='2008-1-0
0:0:0')))  GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

2008-01-16 12:01:03 dbuser 1.1 SELECT t.*, tt.*, tr.object_id FROM wp_terms
AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN
wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_idWHERE
tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (500, 497, 480,
481, 462, 461, 458, 459, 487, 454, 455, 489, 456, 406) ORDER BY t.name ASC

2008-01-16 12:04:38 dbuser 2.2 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id  WHERE
1=1  AND post_type = 'post' AND (post_status = 'publish' OR post_status =
'private') AND ec3_sch.post_id IS NULL  GROUP BY wp_posts.ID ORDER BY
post_date DESC LIMIT 0, 5

On Jan 15, 2008 4:28 PM, issa villarreal <noviembres at gmail.com> wrote:

> my website has been suspended several times in these days because of high
> use of memory and cpu time. this is according to my hosting's level,
> something around 25% of the cpu in 60 seconds (http://www.hosticananswers.com/questions/190/).
>
>
> my most visited blog has less than thousand visitors per day. in the mysql
> log, event calendar 3 get_schedule appears as the most consuming and called
> process. my hosting recommends to shut down all extra plugins to release the
> load of memory. but of course, ec3 is essential for my event-oriented blog.
> been using it for year now and i have stayed in previous versions of
> wordpress only to ensure the functionality of ec3.
>
> the question is: could ec3 cause all this memory consuming madness and
> hosting suspensions? and how can i fix this?
>
> --
> issa villarreal
>   hiperkarma at gmail.com
>   musica.nmty.org
>
> in the sun and in the rain
> and in the day and in the night
> pain is a flower
> pain is flowers
> blooming all the time.

-- 
issa villarreal
  hiperkarma at gmail.com
  musica.nmty.org

in the sun and in the rain
and in the day and in the night
pain is a flower
pain is flowers
blooming all the time.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20080116/566acb65/attachment.html