List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:September 3 2010 8:58am
Subject:Re: Storage engine
View as plain text  
No, don't worry. Default values are only applied when you create a new
object without specifying a value for that setting.

All your MyISAM tables will keep working fine - although finding a good
tuning balance between the two engines might be some work - but every new
table you create, also in the databases that now contain only MyISAM, will
be InnoDB tables unless you explicitly specify otherwise.


On Fri, Sep 3, 2010 at 10:13 AM, Vikram A <vikkiatbipl@stripped> wrote:

> Hi,
>
> I have one doubt; Please can any one give your view?
>
> I have MYSQL version 5.1.x.
>
> I have some existing Databases in which the tables are created using
> MYISSAM
> storage engine.
>
>
> Now i have another database which will use INNODB engine.
>
> My question is, If i set default engine as INNODB Whether it will make any
> misconduct on other MYISSAM databases?
>
> Thank you!
>
> Vikram A
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Storage engineVikram A3 Sep
  • Re: Storage engineJohan De Meersman3 Sep