MySQL 5.5 Default Storage Engine
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
Another option is
I'm going to drop all the data bases and recreate them (well, one anyway) to check with
Any advice on going backwards or if it's worth the effort (a lot of effort, methinks) to deal with InnoDB?
OK, blew away data bases, reinstalled one application, loaded one not-so-large table set into the data base, thing flies instead of crawls; appears that the default-storage-engine=myisam does that trick (at least for that and I don't have to edit every create table statement in the application).
So, older LAMP applications that relied on MyISAM (the old default) may not work so hot if you just drop and recreate a database without incorporating the default-storage-engine syntax in /etc/mysql/my.cnf or, possibly, skip-innodb and altering all your create table statements (with the proviso that "tables that rely on full-text search must be MyISAM tables rather than InnoDB ones."
Anyway, life is better.
|All times are GMT -5. The time now is 02:20 AM.|