Re: How long does it take to change engine from innodb to myisam?

2005-12-15 Thread Gleb Paharenko
Hello. In my opinion, a lot of depends on your table structure and InnoDB settings. You can get a number of rows proceed during conversion using 'SHOW INNODB STATUS'. In such a way you determine an average speed. Nathan Gross wrote: > Hi; > Is there a formula I can go by in order to

How long does it take to change engine from innodb to myisam?

2005-12-15 Thread Nathan Gross
Hi; Is there a formula I can go by in order to estimate how long it would take to change over from innodb to myisam. Say for a 100meg file, a 5 gig table, etc. Thank you; -nat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[