do NOT top-post which makes threads unreadable Am 21.09.2012 15:55, schrieb Girish Talluru: > On Fri, Sep 21, 2012 at 6:44 AM, Reindl Harald <h.rei...@thelounge.net > <mailto: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
> I'm sorry if I ask wrong question here? you did not ask any question because without knowing what type of queries on what type of data the application makes no answer is possible > 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 and that is why i said "try the migration on a staging server" setup a virtual machine for testing and look with snapshots how it behaves - any "paper" before is useless since MyISAM has no foreign keys it should be easy to change the table types, the other direction would be more painful
signature.asc
Description: OpenPGP digital signature
