General Discussions
7
Posts
3
Users
0
Reactions
995
Views
Aug 30, 2020 3:35 pm
WPFORO is overloading MYSQL. I have followed your tutorial on database tables to no effect.
6 Replies
Aug 30, 2020 6:38 pm
wpForo doesn't overload anything.
This could be related to your hosting, errors in your DB (check it within wpForo admin options and tools) or you use a caching with wpForo. Caching doesn't work with wpForo and some caching plugins create problems with wpForo sessions (users get mixed login/logout statuses).
Aug 31, 2020 5:01 am
I have a very powerful dedicated server so I doubt it is my host.
I am using w3 total cache with all of the exclusions required to prevent caching on wpforo
I ran a database check of my tables and DID get some issues showing up....
"
The indexes parentid and parentid_2 seem to be equal and one of them could possibly be removed.
The indexes status and status_2 seem to be equal and one of them could possibly be removed.
The indexes order and order_2 seem to be equal and one of them could possibly be removed.
The indexes is_cat and is_cat_2 seem to be equal and one of them could possibly be removed.
Problems with indexes of table `wp_wpforo_posts`
The indexes email and email_2 seem to be equal and one of them could possibly be removed.
The indexes status and status_2 seem to be equal and one of them could possibly be removed.
The indexes is_first_post and is_first_post_2 seem to be equal and one of them could possibly be removed.
The indexes is_answer and is_answer_2 seem to be equal and one of them could possibly be removed.
The indexes created and created_2 seem to be equal and one of them could possibly be removed.
The indexes userid and userid_2 seem to be equal and one of them could possibly be removed.
The indexes forumid and forumid_2 seem to be equal and one of them could possibly be removed.
The indexes topicid and topicid_2 seem to be equal and one of them could possibly be removed.
Problems with indexes of table `wp_wpforo_topics`
The indexes type and type_2 seem to be equal and one of them could possibly be removed.
The indexes modified and modified_2 seem to be equal and one of them could possibly be removed.
The indexes created and created_2 seem to be equal and one of them could possibly be removed.
The indexes first_postid and first_postid_2 seem to be equal and one of them could possibly be removed.
The indexes forumid and forumid_2 seem to be equal and one of them could possibly be removed."
looks like some duplicate indexes? How do I fix this? Could this cause my slowdown and load issues?
I HAVE ATTACHED A SCREENSHOT OF THE WPFORO_FORUMS TABLE STRUCTURE SO YOU CAN SEE THE DUPLICATE INDEXES. SHOULD i DROP THE DUPLICATES?