MySQL: dont use InnoDB
Keywords: mysql innodb myisam
Newly created databases use the innodb engine on newer mysql versions. But if you dont need transactions, innodb only means pain. Especially if you are used to being able to simply copy tables on the file system level.
Add the following line in /etc/my.cnf to the [mysqld] section to turn innodb of: