InnoDB is not your default storage engine,
you can determine if your database server or applications work
InnoDB by restarting the server
defined on the command line or with
defined in the
[mysqld] section of the
my.cnf configuration file.
Since changing the default storage engine only affects new tables
as they are created, run all your application installation and
setup steps to confirm that everything installs properly. Then
exercise all the application features to make sure all the data
loading, editing, and querying features work. If a table relies on
MyISAM-specific feature, you'll receive an
error; add the
ENGINE=MyISAM clause to the
CREATE TABLE statement to avoid the
If you did not make a deliberate decision about the storage
engine, and you just want to preview how certain tables work when
they're created under
InnoDB, issue the command
table_name ENGINE=InnoDB; for each table. Or, to run
test queries and other statements without disturbing the original
table, make a copy like so:
CREATE TABLE InnoDB_Table (...) ENGINE=InnoDB AS SELECT * FROM MyISAM_Table;
To get a true idea of the performance with a full application under a realistic workload, install the latest MySQL server and run benchmarks.
Test the full application lifecycle, from installation, through heavy usage, and server restart. Kill the server process while the database is busy to simulate a power failure, and verify that the data is recovered successfully when you restart the server.
Test any replication configurations, especially if you use different MySQL versions and options on the master and the slaves.