Reactions to story from Senior MySQL DBA
MyISAM to InnoDB Conversion: Converting almost a billion records
http://mysqldatabaseadministration.blogspot.com/ 2008/ 01/ myisam-to-innodb-convers...
So my challenge last week was to convert almost a billion records in 37 databases and 74 tables. Oh, and I wanted to do it only during the night (between 12:30AM and 6AM) and in the least number of nights. This was not my first massive MyISAM to InnoDB migration, nonetheless, I still manged to learn a few things. We're at a stage where MyISAM just isn't the solution any more. Our plans are to go almost 100% InnoDB and this migration project completes yet another massive step towards that direction. The first night was depressing. I applied every trick up my sleeve but only ended up getting 9.48% complete.
More rising blog posts
-
Entertainment »
And again... -
Business »
New Yorker cover spotlights McCains houses, foreclosure crisis. -
Lifestyle »
Are Americans Losing Their DIY Skills? -
Politics »
Balloting Process for President -
Sports »
US Open September 6 Schedule of Play -
Technology »
Leaked Photo of 4th Generation iPod Nano in Packaging?
Recent posts from Senior MySQL DBA
-
Notes from Structure 08, Velocity and Graphing Social Patterns East
13 days ago -
S3 suffers major outage
47 days ago -
Web Developer / Graphic Designer Job Openings
47 days ago
