Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
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. ???
0
Answers
So ... disable the plugin and see if it solves the problem?
There was an error rendering this rich post.
Or do a file search in your plugins folder for "AllLikes"
I reckon it is part of that plugin. The
DiscussionIDcolumn 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).My shop | About Me
@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.
@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
you could add the index and see if it helps
ALTER TABLE
GDN_AllLikesADD INDEX (DiscussionID)and drop it later if it doesn't work
ALTER TABLE
GDN_AllLikesDROP INDEXDiscussionIDI may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.