WeBWorK Main Forum

mariadb as mysql replacement on new install?

Re: mariadb as mysql replacement on new install?

by Michael Gage -
Number of replies: 2
Danny,

On a related note what is the latest on the relative speeds of MyISAM and InnoDB?  Moodle is forcing me to use InnoDB for its databases so I'm considering switching over the webwork courses as well. I know that InnoDB was slow initially but perhaps there have been performance improvements recently?

Thanks.

Take care,
Mike

In reply to Michael Gage

Re: mariadb as mysql replacement on new install?

by Heath Loder -

I realize this is an "ancient" thread, but I've recently come across this concern as well.  I maintain several small databases amongst several servers, and WeBWork is the only software that still "requires" (per the documentation at least) MyISAM tables.  I'm trying to unify backup solutions across the servers, but having these MyISAM tables is making this difficult.

Are there any "official" updates on the performance of InnoDB vs MyISAM with respect to serving a WeBWork database?  I'm on Ubuntu Server 18.04 with MySQL Server 5.7, running WeBWork 2.13.

Thanks,

Heath