If you need fulltext and InnoDB, checkout XtraDB from Percona. I think MariaDB has an alternative as well.EricOn Tue, Apr 8, 2014 at 10:49 AM, Matt Graham <mhgraham@crow202.org> wrote:
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