Notifications

Clear all

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

How-to and Troubleshooting

Last Post by Chris 2 years ago

4 Posts

2 Users

1 Reactions

828 Views

RSS

Posts: 15

stevenkwok

Topic starter

Sep 30, 2022 7:42 am

(@stevenkwok)

Eminent Member

Joined: 2 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

db-tables-screenshot.png

Topic Tags

3 Replies

Posts: 3627

Chris

Sep 30, 2022 10:46 am

(@chris)

Famed Member

Joined: 3 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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

2 Replies

stevenkwok

(@stevenkwok)

Joined: 2 years ago

Eminent Member

Posts: 15

Sep 30, 2022 12:06 pm

Reply to

Chris

@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: 3 years ago

Famed Member

Posts: 3627

Sep 30, 2022 3:30 pm

Reply to

stevenkwok

@stevenkwok,

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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.