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.
MyBB Tutorials
Upgrading Tables To Innodb
Submitted by Oxygen, 05-04-2015, 05:12 PM, Thread ID: 2521
Thread Closed
RE: Upgrading Tables To Innodb 10-04-2015, 12:57 AM #2 So, if my host have MySQL 5.6 I just have to create a .php file, execute it and when done, just delete it?
10-04-2015, 12:57 AM
#2 So, if my host have MySQL 5.6 I just have to create a .php file, execute it and when done, just delete it?
RE: Upgrading Tables To Innodb 16-04-2015, 01:21 AM #3 If I remember correctly, InnoDB is TERRIBLE.
eats all your ram and shit
16-04-2015, 01:21 AM
#3 If I remember correctly, InnoDB is TERRIBLE.
eats all your ram and shit
eats all your ram and shit
RE: Upgrading Tables To Innodb 16-04-2015, 02:04 AM #5 16-04-2015, 02:02 AMPulseeey Wrote: 16-04-2015, 01:21 AMHug 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
#5 16-04-2015, 02:02 AMPulseeey Wrote:16-04-2015, 01:21 AMHug 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?
RE: Upgrading Tables To Innodb 16-04-2015, 02:04 AMAndresXZ09 Wrote: 16-04-2015, 02:02 AMPulseeey Wrote: 16-04-2015, 01:21 AMHug 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, 02:04 AMAndresXZ09 Wrote:16-04-2015, 02:02 AMPulseeey Wrote:16-04-2015, 01:21 AMHug 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.
RE: Upgrading Tables To Innodb 16-04-2015, 01:15 AMPing Wrote: 10-04-2015, 12:57 AMAndresXZ09 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. ![[Image: UeTXrZ5.png]](//i.imgur.com/UeTXrZ5.png)
16-04-2015, 01:15 AMPing Wrote:10-04-2015, 12:57 AMAndresXZ09 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.
![[Image: UeTXrZ5.png]](http://i.imgur.com/UeTXrZ5.png)
RE: Upgrading Tables To Innodb 25-04-2015, 10:36 PM #8 16-04-2015, 02:04 AMAndresXZ09 Wrote: 16-04-2015, 02:02 AMPulseeey Wrote: 16-04-2015, 01:21 AMHug 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.
25-04-2015, 10:36 PM
#8 16-04-2015, 02:04 AMAndresXZ09 Wrote:16-04-2015, 02:02 AMPulseeey Wrote:16-04-2015, 01:21 AMHug 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.
RE: Upgrading Tables To Innodb 25-04-2015, 10:38 PM #9 @Kewl is it better than InnoDB or MySQL?
25-04-2015, 10:38 PM
#9 @Kewl is it better than InnoDB or MySQL?