List:General Discussion« Previous MessageNext Message »
From:Alec.Cawley Date:September 15 2005 9:53am
Subject:Re: Myisam or innodb
View as plain text  
Scott Haneda <lists@stripped> wrote on 15/09/2005 10:31:48:

> I have moved my data from mysql 3 to 4, across various updates, over the
> past few years. I use phpmyadmin generally, and it defaults to making 
tables
> myisam.
> 
> I can not seem to find a really clear answer as to why I want to use one
> over the other.  Generally, I use myisam and change it only when I need 
to
> do a rollback or something like that.
> 
> Since I seem to be able to toggle from myisam to innodb without any 
adverse
> affects, why would one chose one over the other?
> 
> Is there a way to prevent the use of myisam if it is old and slowly 
being
> deprecated?  I am a host and do not control the table structure of 
clients
> databases.


Innodb does not yet support FullText.
While I believe that there are circumstances in which InnodDB is faster, I 
think that many applications will find MyIsam faster.\\
I don't thing InnoDB supports Load Data From Master, making adding a 
replication slave harder.

        Alec
Thread
Myisam or innodbScott Haneda15 Sep
  • Re: Myisam or innodbAlec.Cawley15 Sep
  • Re: Myisam or innodbBruce Dembecki16 Sep