Re:

Also,
I wrote a quick article to get Sphinx running with MySQL.
http://blog.voltampmedia.com/2012/04/07/centos-5-8-mysql-php-and-sphinx-install-and-configure/

Eric


On Tue, Apr 8, 2014 at 10:48 AM, Eric Cope <eric.cope@gmail.com> wrote:

> 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