On 2014-04-08 09:44, keith smith wrote:
> I have a MySql database that is about 10 years old. The tables are
> using the MyISAM data engine.  As I look around it seems the
> InnoDB data engine is such a better deal.  I am thinking that a
> switch to InnoDB might be the way to go

If you're using fulltext search in any of your columns, you'll probably 
have to find another way of doing that, like sphinx.  You can't really 
do fulltext search with InnoDB.  If you're not doing fulltext search, 
then the row-level locking that InnoDB provides makes inserts and 
updates a lot faster.

> Is there anything I should be aware of or any potential problems in
> using InnoDB with MySql versions prior to 5.5.5?

I've used a bunch of InnoDB tables on a bunch of mysql DBs going back 
to 5.0.51, and never had any problems with InnoDB in and of itself.  
(Disks dying, clusters split-braining, running out of disk space, people 
doing DROP DATABASE on production data, and so forth caused far more 
pain than anything InnoDB.)  The main thing I'd worry about is that it 
can take hours to convert huge tables from MyISAM to InnoDB if your 
machine's got any sort of CPU or I/O bottleneck, and while that 
conversion's going on, the table's unusable.  If you can schedule enough 
downtime, you'll probably be just fine.

-- 
Crow202 Blog: http://crow202.org/wordpress
There is no Darkness in Eternity
But only Light too dim for us to see.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss