And also:
SELECT count(*)
FROM `wp_3cy42zznwz_wpforo_posts`
WHERE `wp_3cy42zznwz_wpforo_posts`.`postid` > 33230
And Wpforo activites seems to be a common problem:
SELECT *
FROM wp_3cy42zznwz_wpforo_activity
WHERE `itemtype` = 'alert'
AND `userid` = 167
AND `type` NOT IN('new_like')
ORDER BY id ASC
LIMIT 100
I think i may have sorted this. There was a spike in database queries or something causing the memory to spike. Im still not sure what caused it but i think everythingis working fine now....
Any ideas?
No, this hasn't worked, I am still having issues with slow queries, mainly from the likes and posts databases i think??
It seems as if something is sending alot of database queiries to the server causing hi CPU.
I use most of the add ons for wpforo, could it be something wrong with one of those?
wpForoPost->get_post_likes_count()
This is a common one, does this help at all?
I'd recommend change the wp_wpforo_likes table engine to MyISAM.
Also, I'd recommend delete all rows (truncate table) in wp_wpforo_activity table, it'll remove all bell notifications and topic/post editing logs. So It's a good idea to refresh that table. It seems it has become very large. You can backup both tables before the manipulation.
@robert Awesome, thanks Robert, do you have a guide any where on how to do this mate?
Ok, I found that table, what exacltey should i do when im in there mate?