Re: InnoDB vs MyISAM

[Christian Hammers]

On 2007-01-04 Octavian Rasnita wrote:
> I have seen that by default some tables are created as InnoDB and some as 
> MyISAM.
>
> I guess the table type is not chosen randomly. How is it chosen the table 
> engine used?
You can set a global and IIRC a database specific default for the database
type.
 
> And is InnoDB recommended now?
It depends.. :)

> Does it support full text indexes?
> Or if not, is there a way of using full text indexes and foreign keys in MySQL?
No fulltext indexes in InnoDB and 
no foreign keys in MyISAM as of 5.0.

bye,

-christian-