Limited Support
Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.
We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!
Merry Christmas and Happy Holidays! 🎄
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?
