Which are the correct table engines for wpForo ver. 2.2.3 database tables? - How-to and Troubleshooting - wpForo 2.0 https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/ Discussion Board en-US Sat, 10 Oct 2026 23:19:27 +0000 wpForo 60 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106242 Sat, 18 Nov 2023 16:28:39 +0000 @martin 

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

]]> How-to and Troubleshooting - wpForo 2.0 JorgeW https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106242 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106241 Sat, 18 Nov 2023 16:27:14 +0000 How-to and Troubleshooting - wpForo 2.0 JorgeW https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106241 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106220 Sat, 18 Nov 2023 10:59:33 +0000 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.

]]> How-to and Troubleshooting - wpForo 2.0 Martin https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106220 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106189 Sat, 18 Nov 2023 04:07:25 +0000 Here are newer suggestions from @robert

https://wpforo.com/community/general-forums-bug-reports/wordpress-database-error-routing-query-to-backend-failed-urgent/#post-35103

]]> How-to and Troubleshooting - wpForo 2.0 dimalifragis https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106189 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106188 Sat, 18 Nov 2023 02:20:16 +0000 @dimalifragis 

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

Would you still recommend switching to innoDB?

]]> How-to and Troubleshooting - wpForo 2.0 JorgeW https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106188 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106187 Sat, 18 Nov 2023 02:09:52 +0000 Hi @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

 

 

]]> How-to and Troubleshooting - wpForo 2.0 JorgeW https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106187 RE: Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106172 Fri, 17 Nov 2023 19:49:56 +0000 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

 

]]> How-to and Troubleshooting - wpForo 2.0 dimalifragis https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106172 Which are the correct table engines for wpForo ver. 2.2.3 database tables? https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106169 Fri, 17 Nov 2023 18:58:00 +0000 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:

 

]]> How-to and Troubleshooting - wpForo 2.0 JorgeW https://wpforo.com/community/how-to-and-troubleshooting-2/which-are-the-correct-table-engines-for-wpforo-ver-2-2-3-database-tables/#post-106169