tag:blogger.com,1999:blog-18337119.post115285413562574001..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: MyISAM to InnoDBUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18337119.post-87379873183505683112010-01-25T23:11:25.792-05:002010-01-25T23:11:25.792-05:00May I document it at my blog?
it's a useful tr...May I document it at my blog?<br />it's a useful trick<br /><br />ykzir.wordpress.com<br /><br />thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-73343822144269167442007-09-15T08:36:00.000-04:002007-09-15T08:36:00.000-04:00I'm converting a 1 table that's 1.5 GB in size as ...I'm converting a 1 table that's 1.5 GB in size as a MyISAM table to Innodb. <BR/><BR/>I'm doing this conversion on a dedicated server by dumping the db, copying to the new server, and doing a mysql db < file.<BR/><BR/>I've used the optimizations you've mentioned (set innodb buffer pool to 3GB, set autocommit=0, set unique_checks=0).<BR/><BR/>But it's been >8 hours and the conversion is still underway.<BR/><BR/>What am I doing wrong?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1153148089986620572006-07-17T10:54:00.000-04:002006-07-17T10:54:00.000-04:00Peter,Of course you're right. My bad for not payin...Peter,<BR/><BR/>Of course you're right. My bad for not paying attention. DISABLE KEYS would only help with MyISAM.<BR/><BR/>Thank you for the tips. They are greatly appreciated.<BR/><BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1153122609811408812006-07-17T03:50:00.000-04:002006-07-17T03:50:00.000-04:00Frank,Couple of things which can help to speed up ...Frank,<BR/><BR/>Couple of things which can help to speed up conversion, if data size is significant.<BR/><BR/>1) disable keys do not work for Innodb tables. So it is not needed.<BR/><BR/>2) SET UNIQUE_CHECKS=0 is handy if loading data with unique keys - can speed up things dramatically.<BR/><BR/>3) Make sure you load data in primary key order. MyISAM is frequently unsorted which may make load 10+ time slower than it can be.Anonymousnoreply@blogger.com