Upgrading Tables To Innodb

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.


Once the file is executed, you should delete it off your server.

So, if my host have MySQL 5.6 I just have to create a .php file, execute it and when done, just delete it?

If I remember correctly, InnoDB is TERRIBLE.

eats all your ram and shit

16-04-2015, 01:21 AM

Hug Wrote: If I remember correctly, InnoDB is TERRIBLE.

eats all your ram and shit

InnoDB is better for larger forums, which execute more queries etc.

Although if you're that big, chances are you use MariaDB or an alternative.

16-04-2015, 02:02 AM

Pulseeey Wrote:

16-04-2015, 01:21 AM

Hug Wrote: If I remember correctly, InnoDB is TERRIBLE.

eats all your ram and shit

InnoDB is better for larger forums, which execute more queries etc.

Although if you're that big, chances are you use MariaDB or an alternative.

Is it possible to change from the default one to MariaDB?

16-04-2015, 02:04 AM

AndresXZ09 Wrote:

16-04-2015, 02:02 AM

Pulseeey Wrote:

16-04-2015, 01:21 AM

Hug Wrote: If I remember correctly, InnoDB is TERRIBLE.

eats all your ram and shit

InnoDB is better for larger forums, which execute more queries etc.

Although if you're that big, chances are you use MariaDB or an alternative.

Is it possible to change from the default one to MariaDB?

I've not really used MariaDB, I believe the table structures remain as MyISAM or InnoDB but I am not sure. I think it's just a quicker process? I don't even know. I just know it's quicker in some way.

MyBB can be used with, pretty sure HF used it at one point.

16-04-2015, 01:15 AM

Ping Wrote:

10-04-2015, 12:57 AM

AndresXZ09 Wrote: So, if my host have MySQL 5.6 I just have to create a .php file, execute it and when done, just delete it?

Yep, also thanks for this. I tried it and it worked great. Also, you might want to add "hide" tags to your post so it doesn't get leeched.

Added Hide Tags.

16-04-2015, 02:04 AM

AndresXZ09 Wrote:

16-04-2015, 02:02 AM

Pulseeey Wrote:

16-04-2015, 01:21 AM

Hug Wrote: If I remember correctly, InnoDB is TERRIBLE.

eats all your ram and shit

InnoDB is better for larger forums, which execute more queries etc.

Although if you're that big, chances are you use MariaDB or an alternative.

Is it possible to change from the default one to MariaDB?

Yeah you can use MariaDB instead of MySQL.

@Kewl is it better than InnoDB or MySQL?

25-04-2015, 10:38 PM

AndresXZ09 Wrote: @Kewl is it better than InnoDB or MySQL?

I prefer MariaDB than InnoDB and MySQL.