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?
