Hi Reindl, I'm sorry if I ask wrong question here?
I'm new to this and people before me did the terrible mistake of using myISAM even though they decided to move to Innodb many times. Data grows like hell and now requirements came in where we have to use transactions. At this stage we have to migrate to innodb but as a new guy they assigned me to get the risks document ready for migration. Thanks, Girish Talluru On Fri, Sep 21, 2012 at 6:44 AM, Reindl Harald <h.rei...@thelounge.net>wrote: > > > Am 21.09.2012 15:26, schrieb Girish Talluru: > > I have requirement to change my production database tables which are > using > > myISAM and now bcoz of some changes we have to move to Innodb. > > > > Can anyone suggest how the plan should be and risks involve? > > no because this depends hardly on your data and what the application > does - many things may be faster, some like "select count(*) from" > are unacceptable slow if they are called often > > however, it is the wrong way to ask foreign people such questions > > * try the migration on a staging server > * test your application under load on the staging server > > if no staging server exists you have done something terrible wrong > > > > > >
