AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant
Notifications
Clear all

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

4 Posts
2 Users
1 Reactions
3,318 Views
Posts: 15
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@stevenkwok)
Eminent Member
Joined: 4 years ago
[#24892]

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
wpForo Version
2.0.9
WordPress Version
6.0.2

3 Replies
Chris
Posts: 3610
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@chris)
Famed Member
Joined: 5 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: 4 years ago

Eminent Member
Posts: 15
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

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

Famed Member
Posts: 3610
Chris
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

@stevenkwok,

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


Share: