Storage engine

--0-203461519-1283501623=:80965
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi, I have one doubt; Please can any one give your view? I have M=
YSQL version 5.1.x. I have some existing Databases in which the table=
s are created using MYISSAM =0Astorage engine. =0ANow i have another =
database which will use INNODB engine. My question is, If i set defau=
lt engine as INNODB Whether it will make any =0Amisconduct on other MYISSAM=
databases? Thank you! Vikram A
--0-203461519-1283501623=:80965--

Re: Storage engine

--00032557578a1097ca048f5722fd
Content-Type: text/plain; charset=ISO-8859-1

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 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

--00032557578a1097ca048f5722fd--