Converting from InnoDB to MyISAM

John McLear edited this page May 22, 2014 · 1 revision

General

Resources

For Developers

How to's

Set up

Advanced steps

Integrating Etherpad in your web app

for Developers

Clone this wiki locally

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