In MySQL 5.5, InnoDB is the default storage engine; previous editions were MyISAM by default.
I have a couple of FOSS LAMP applications that build lots of tables with no engine=
directives yet they do full-text searches and
If a table relies on some MyISAM-specific feature, you'll receive an error; add the ENGINE=MyISAM clause to the CREATE TABLE statement to avoid the error. (For example, tables that rely on full-text search must be MyISAM tables rather than InnoDB ones.)
(from the MySQL 5.5 Reference Manual, 14.3.1).
to the mysqld
section of /etc/mysql/my.cnf
(which is a copy of the my-huge.cnf
file), stopped the MySQL daemon and started (no errors).
Another option is
but I'm not real sure which is the better; the default-storage
-- if anybody has any thoughts I'd appreciate knowing them.
I'm going to drop all the data bases and recreate them (well, one anyway) to check with
SHOW VARIABLES LIKE 'have_innodb';
hoping for a NO but haven't gotten that far as yet.
Any advice on going backwards or if it's worth the effort (a lot of effort, methinks) to deal with InnoDB?