A blog post on the handling of huge relational database tables. Specifically how to handle MySQL InnoDB table with more than one billion of rows.
For instance creating indexes AFTER importing data is generally the fastest approach, but there is not automated tool for that.
Comment on This Data Unit