The VPS provider told me that mysql executes very slow query like:
select count(a.ActivityID) as
from GDN_Activity a
join GDN_ActivityType t on a.ActivityTypeID = t.ActivityTypeID
where a.CommentActivityID is null
and (a.ActivityUserID = '4436'
or a.RegardingUserID = '4436')
and t.Public = '1';
First, I've added an index on GDN_Activity.ActivityType then my questions are:
What are these activities exactly? Why mysql executes over 50 of these queries in a second? Can i delete old records (years ago)? Can i disable them? (many questions....)
Keep in mind that this forum has over of 4 millions of impressions a month.
Thanks in advance for any tips.