Notifications
Clear all

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! 🎄

[Solved] How to configure the table engine for my wpForo database tables correctly?

4 Posts
2 Users
1 Reactions
1,764 Views
Posts: 15
Topic starter
(@stevenkwok)
Eminent Member
Joined: 3 years ago

Hi folk,

I'm trying to optimize my wpForo forum and just came across a previous post in this community: https://wpforo.com/community/faq/forum-is-slow/

Setting the table engine properly is a means to speed up the forum. While the post mentioned above discussed 17 tables, my current version has 20 tables (including one for the Prefixes addon). A screenshot is attached to this post for your reference.

In my case, how to set the table engine for them for better performance?

Thanks in advance,

Steven


3 Replies
Chris
Posts: 3610
(@chris)
Famed Member
Joined: 4 years ago

@stevenkwok,

Set them all to InnoDB, but make sure that these two tables are set to MyISAM:

  • wp_wpforo_likes
  • wp_wpforo_visits

2 Replies
(@stevenkwok)
Joined: 3 years ago

Eminent Member
Posts: 15

@chris Hi Chris,

Thanks for the info. But I cannot find the wp_wpforo_likes table in my database. Does the plugin save the like data into the wp_wpforo_activity table?

P.S. My current wpForo version is 2.0.9


Chris
(@chris)
Joined: 4 years ago

Famed Member
Posts: 3610

@stevenkwok,

Sorry, the like table has been changed to reaction and it's better to let it InnoDB.