Notifications
Clear all

[Closed] Which are the correct table engines for wpForo ver. 2.2.3 database tables?

8 Posts
3 Users
4 Likes
365 Views
JorgeW
Posts: 105
Topic starter
(@jorgew)
Estimable Member
Joined: 5 years ago

Hi @robert, @chris,

I'm trying to set the correct table engines in wpForo database but cannot find updated info for wpForo ver. 2.2.3

Will appreciate any help on this.

Thanks

 

These are my current tables and settings:

 

7 Replies
dimalifragis
Posts: 2539
(@dimalifragis)
Famed Member
Joined: 4 years ago

While yours seems ok, personally i have set all WP tables to InnoDB.

Some say that for some types of tables old isam is faster. But in 2023 i don't think so.

https://blogs.oracle.com/mysql/post/still-using-myisam-it-is-time-to-switch-to-innodb

 

2 Replies
JorgeW
(@jorgew)
Joined: 5 years ago

Estimable Member
Posts: 105

Hi @dimalifragis,

Posted by: @dimalifragis

While yours seems ok, personally i have set all WP tables to InnoDB

Well, in this post by @robert

https://wpforo.com/community/postid/11391/
On: 08/10/2017

... he recommends the following tables as innoDB

  • wp_wpforo_forums (mine is MyISAM)
  • wp_wpforo_posts (mine is MyISAM)
  • wp_wpforo_topics (mine is MyISAM)
  • wp_wpforo_profiles (mine is MyISAM)
  • wp_wpforo_views  (mine is already InnoDB)

 

... and 

'And make sure the following tables Engines are still MyISAM:'

  • wp_wpforo_likes (in ver. 2.2.3 = reactions) (mine is InnoDB)
  • wp_wpforo_visits  (mine is InnoDB)

 

So, I don't know if I should keep them this way.

 


 

I wonder what's recommended by the developers for wpForo 2.2.3

 

 

JorgeW
(@jorgew)
Joined: 5 years ago

Estimable Member
Posts: 105

@dimalifragis 

I'm working with MySQL Version 5.7.44-log-cll-lve

Would you still recommend switching to innoDB?

dimalifragis
Posts: 2539
(@dimalifragis)
Famed Member
Joined: 4 years ago
1 Reply
JorgeW
(@jorgew)
Joined: 5 years ago

Estimable Member
Posts: 105
Posts: 986
Moderator
(@martin)
Support Team
Joined: 8 years ago

Hi @jorgew,

It's better to set all tables as InnoDB, you ken keep _reactions as MyISAM. All changes should be done in phpMyAdmin database manager. We recommend backup the database before any manipulation.

1 Reply
JorgeW
(@jorgew)
Joined: 5 years ago

Estimable Member
Posts: 105

@martin 

Thx for the info, I'll make the changes you suggest.