I'm trying to find a weird performance problem in a MySQL database. I
use MySQL v5.0 but the db was migrated forward from a v4.1(?) system.
Looking at the schema in a recent backup, I was surprised to find
different engines used for different tables:
...
CREATE TABLE `comment` (
`id`
MySQL has a pluggable storage engine architecture which means that you
can use multiple storage engines within your databases. What you need
to do is investigate the different features of the engines and devide
which one best fits your system i.e. level of locking required,
InnoDB=row level