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

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] MyISAM Engine?

13 Posts
4 Users
3 Reactions
6,531 Views
Robert
Posts: 10753
Admin
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
(@robert)
Support Team
Joined: 3 months 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.


Posts: 10
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
(@moisb)
Active Member
Joined: 8 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?

 wpforo table test

4 Replies
Robert
Admin
(@robert)
Joined: 3 months ago

Support Team
Posts: 10753
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

@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%.

 


(@anonymous20)
Joined: 10 years ago

Noble Member
Posts: 1593
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
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.

 

 


Robert
Admin
(@robert)
Joined: 3 months ago

Support Team
Posts: 10753
Robert
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

@anonymous20,

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

 


(@anonymous20)
Joined: 10 years ago

Noble Member
Posts: 1593
Robert
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
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/

 


Posts: 10
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
(@moisb)
Active Member
Joined: 8 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!


1 Reply
Robert
Admin
(@robert)
Joined: 3 months ago

Support Team
Posts: 10753
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

@moisb,

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

 


Page 2 / 2
Share: