MyBB Tutorials

Upgrading Tables To Innodb

Submitted by Oxygen, , Thread ID: 2521

Thread Closed
Oxygen
<div class="postbit-usertitle">
Prime
Level:
0
Reputation:
35
Posts:
608
Likes:
63
Credits:
1.47K
05-04-2015, 05:12 PM
This post was last modified: 16-04-2015, 05:28 PM by Oxygen
#1
This script will convert all your tables to the much better Innodb storage engine than MyISAM. This is very helpful for larger forums with many users online. If you do not have MySQL version 5.6 or higher you have three choices to make:
1) Upgrade to MySQL 5.6 or higher ( you may need to contact your host for this. )
2) Keep Full Text Index searches and let the mybb_posts and mybb_threads tables stay as MyISAM
3) Drop the index on message for the mybb_posts table and the index subject on the mybb_threads table.
Content locked
This content has been locked. Please login or register in order to unlock it.


Once the file is executed, you should delete it off your server.
[Image: UeTXrZ5.png]

Users browsing this thread: 1 Guest(s)