Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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?
