This queries have taken more than 99% of the CPU and it makes the website offline

Chanux

616854 MYDB localhost MYDB Query 0 Writing to net select * from GDN_AllLikes AllLikes where DiscussionID = '22179'

The above queries have taken more than 99% of the CPU and it makes the website offline. is this a part of "LIKE THIS" plugin. ???

UnderDog

So ... disable the plugin and see if it solves the problem?

R_J

Or do a file search in your plugins folder for "AllLikes"

businessdad

@Chanux said:
The above queries have taken more than 99% of the CPU and it makes the website offline. is this a part of "LIKE THIS" plugin. ???

I reckon it is part of that plugin. The DiscussionID column is not indexed, and this may cause some issues if the table grows too much (although it should be unlikely, unless the forum is very large).

phreak

@Chanux: Interesting catch, my forum experience downtimes as well. I couldn't see anything in my server logs, i'll have a look at Al Likes as well.

R_J

@phreak: have you checked the slow query log? http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
You can even define what is "slow". Documentation says that by default 10 seconds are considered as slow, but that could be set to any value you like

peregrine

you could add the index and see if it helps

ALTER TABLE GDN_AllLikes ADD INDEX ( DiscussionID )

and drop it later if it doesn't work

ALTER TABLE GDN_AllLikes DROP INDEX DiscussionID