Converting from InnoDB to MyISAM - ether/etherpad-lite GitHub Wiki

Up to the June the 1st 2014 Etherpad ran InnoDB by default on MySQL. MyISAM will give you ~10x more performance than InnoDB so we recommend using that for your MySQL enabled Etherpad instance.

Existing sites can change their database format to MyISAM by following the instructions below

## stop Etherpad-lite instance.
sudo /etc/init.d/etherpad-lite stop

## optional backup etherpad-lite db before changes.
mysqldump -uetherpad-lite -pYourSecretPassword etherpad-lite > /somelocation/etherpad.sql

## change table structure on mysql server
mysql -uetherpad-lite -pYourSecretPassword
USE etherpad-lite;
ALTER TABLE store ENGINE = MyISAM;
quit

## update etherpad (ideally doing a git pull)

## Start etherpad-lite
sudo /etc/init.d/etherpad-lite start