Hey!
We are using K2 with Joomla 2.5.7 on our rock-webportal
www.legacy.de
Our website sometimes runs out of service while we are editing items with K2.
The server log shows some slow queries caused by K2 that push our MySQL-Server to 100% which kills our website for some minutes. The queries often last for about 2-3 minutes.
Any ideas, what can cause this slow queries and how to avoid these embarrassing downtimes?
Thank you for your support in advance!
Regards
Ingo
Here's the server-log for that slow queries:
# Time: 120815 10:21:26
# User@Host: legacy[legacy] @ localhost []
# Query_time: 112.302907 Lock_time: 108.990503 Rows_sent: 10 Rows_examined: 15645
SET timestamp=1345018886;
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM legacy_k2_items as i LEFT JOIN legacy_k2_categories AS c ON FIND_IN_SET( c.id , i.catid ) WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-08-15 08:19:34' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-08-15 08:19:34' ) AND MATCH(i.title, i.introtext, i.`fulltext`,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.extra_fields_search,i.metadesc,i.metakey) AGAINST ('secrets* of* the* m*' IN BOOLEAN MODE) AND i.catid IN (20) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 10;
