[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: InnoDB vs MyISAM
From:       "DenBaguse MasRodjie" <roji () mail15 ! com>
Date:       2003-08-29 11:54:53
[Download RAW message or body]

I have converted from MyISAM to InnoDB with PHPMyAdmin.
But, it cannot copy InnoDB file to other machine with simple transfer, not
like MyISAM
Is it a normal case?
Should i reconfigure my.ini? How?

Thanks
Roji

----- Original Message -----
From: <MDaheim@krohne.de>
To: <myodbc@lists.mysql.com>
Sent: Tuesday, August 26, 2003 5:29 PM
Subject: RE: InnoDB vs MyISAM


> Hi Roji,
>
> there is no simple answer to your question, like "choose MyISAM". If my
> hints
> do not enable you to decide yourself, you' have to read the manual:
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#T
> able_types
>
> > Which one is better between InnoDB and MyISAM?
> Depends on your application.
> > And what is the differences?
> InnoDB provides MySQL with a transaction-safe (ACID compliant) storage
> engine with commit, rollback, and crash recovery capabilities. InnoDB does
> locking on row level and also provides an Oracle-style consistent
> non-locking read in SELECTs. These features increase multiuser concurrency
> and performance. .... InnoDB is the first storage manager in MySQL to
> support FOREIGN KEY constraints.  (from the manual)
> > And is there any problems if i change from MyISAM to InnoDB?
> That depends on the data you already have, but it is even possible to mix
> the table types in one database.
>
> MyISAM is the default table type, most applications use it. As the engine
is
> not checking foreign keys, your application has to.
> If you need special InnoDB-features (Transactions, foreign KEY
> constraints,...), you have to use InnoDB.
>
> regards
>
> Michael Daheim
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:    http://lists.mysql.com/myodbc?unsub=roji@mail15.com
>
>
>


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]