Notifications
Clear all

wpForo 1.x.x MyISAM Engine?

13 Posts
4 Users
3 Likes
3,769 Views
Robert
Posts: 9696
Admin
(@robert)
Support Team
Joined: 6 years ago

We also recommend the innoDB. wpForo always tries to create InnoDB tables, it depends on server MySQL version. Some version of MySQL doesn't support Full Text index for InnoDB so wpForo have to create MyISAM tables.

Reply
moisb
Posts: 10
(@moisb)
Active Member
Joined: 4 years ago

hello Robert. Thanks for answering. I doing a test in a new Mariadb environment 10.4.12 with galera cluster. But I was confused, because some WPforo tables were created as InnoDB and others as MyISAM. See attached image

how to solve this?

Reply
4 Replies
Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 9696

@moisb,

Yes, this is already changed in upcoming version. Those tables are not under the high processing, so they can be MyISAM. However, we decided to change to InnoDB even if it helps to improve performance for just 1%.

 

Reply
Anonymous20
(@anonymous20)
Joined: 6 years ago

Noble Member
Posts: 1602
Posted by: @robert

@moisb,

Yes, this is already changed in upcoming version. Those tables are not under the high processing, so they can be MyISAM. However, we decided to change to InnoDB even if it helps to improve performance for just 1%.

 

Not sure how you will do that in existing installations.

I tried to manually do that a while back but failed because of the MariaDB i used (10.1).

The errors were "error 1071 (key too long)".

That was solved in later versions of MariaDB but didn't tried again.

 

 

Reply
Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 9696

@anonymous20,

We'll not do that for update. It'll only be added for new installation.

 

Reply
Anonymous20
(@anonymous20)
Joined: 6 years ago

Noble Member
Posts: 1602
Posted by: @robert

@anonymous20,

We'll not do that for update. It'll only be added for new installation.

 

No problem.

A BACKUP first (or two backups) and then manually:

https://kinsta.com/knowledgebase/convert-myisam-to-innodb/

 

Reply
moisb
Posts: 10
(@moisb)
Active Member
Joined: 4 years ago

great news @Robert  😀 Please don't forget to add this change to the changelog, as soon as I see it I will test it again.

 

thank you very much for understanding!

Reply
1 Reply
Robert
Admin
(@robert)
Joined: 6 years ago

Support Team
Posts: 9696

@moisb,

The change will not affect your database. The update process can't update your table engines. It's only for new installations.

 

Reply
Page 2 / 2
Share: