Not Solved MyISAM vs InnoDB for MyBB?
#4
Not Solved
@Nathan Malcolm - thank you, I will migrate to InnoDB

@dragonexpert - thank you, I will sent you a reply as soon as possible.

I will try to optimize my forum, loading times are not good Sad

So I followed this tutorial:
1) I added new DB name and credentials into my MyBB config file 
2) I run this php file
<?php

define("IN_MYBB", 1);
define("NO_ONLINE", 1);
define("NO_PLUGINS", 1);
require_once "global.php";
if(!$mybb->usergroup['cancp'])
{
error_no_permission();
}
$tablelist = $db->list_tables($config['database']['database'], TABLE_PREFIX);
foreach($tablelist as $table)
{
$db->write_query("ALTER TABLE "  . $table . " ENGINE=Innodb");
echo "Converted table $table to Innodb.<br />";
}
echo "Table conversion complete.<br />";
?>

3) I run these SQLs in phpMyAdmin
ALTER TABLE mybb_threads DROP INDEX subject;
ALTER TABLE mybb_posts DROP INDEX message;

4) I run these SQLs in phpMyAdmin
ALTER TABLE mybb_posts ENGINE=Innodb;
ALTER TABLE mybb_threads ENGINE=Innodb; 

Now I have few questions:
- What else, all tables are now migrated to InnoDB (is there any point to use MyISAM for some of them?)
- Can I use "similar threads" on InnoDB (the table shown below the thread)
- Is there anything how can I optimize my DB settings?

Thank you very much!
[MyBB 1.8 Czech translation] [MyBB 1.8 plugins]: Prune old PMs + optimize DB plugin --- Thank you/like system
Reply


Messages In This Thread
MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-11, 07:31 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-12, 01:03 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 04:15 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 06:48 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 06:50 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 07:12 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 07:21 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 04:56 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 05:05 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 07:37 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 08:08 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 09:20 PM
RE: MyISAM vs InnoDB for MyBB? - by Hewret - 2016-12-13, 08:19 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-14, 04:12 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-14, 10:08 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-15, 05:40 AM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2017-01-15, 02:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)