Re:

If you need fulltext and InnoDB, checkout XtraDB from Percona. I think
MariaDB has an alternative as well.

Eric


On 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
>
---------------------------------------------------
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