Website is Extremely Slow
Hello all, recently we migrated from mybb. I am content with the development of wpforo, especially its integration with wordpress was the main reason why we migrated to wpforo. However our website in general is extremely slow. Database cpu is somehow overloading and cannot handle when there is heavy traffic.
I deactivated all plugins, although we have very few plugins and deactivated them on forum page with plugin load filter. Default cache settings that comes with wpforo are activated and we have no other cache plugins. Currently we are using Godaddy Deluxe Web Hosting.
All in all, I've made lots of research and none of them worked. So here I am, desperately looking for a solution. Here is the forum link in case you want to test or take a look at it: link.
Thanks in advance, and wish you happy Christmas!
If your Wordpress installation is clear from errors (enabled the debug and your debug log is empty) then it should be a poor hosting plan.
I see you use CF already.
What i would suggest is to update to PHP 7.x since you still use 5.6. That will speed things a lot.
1. make sure all database table engines for wpForo (wp_wpforo_ prefix) are InnoDB not MyISAM.
2. Make sure all table indexes exist. Navigate to Dashboard > Forums > Tools > Debug Tab > Tables sub-tab, copy the table list in some txt file and attach it here.
3. Make sure wpForo Object, Memory and Members Caches are enabled in Dashboard > Forums > Settings > Features admin page.
Thank you both for the answers. As @anonymous20 suggested I upgraded to php 7.
@robert I checked the database and not all tables are InnoDB. There is still a considerable number of MyISAM tables. Should I convert them all? And the table list you asked for is in the attachments, hope it is not too confusing.
Have a nice day.
Edit: I am not allowed to attach files so I uploaded it to Google Drive.