Depending on your setup this may be addressed with Extended Fast Index Creation: http://www.percona.com/doc/percona-server/5.5/man.... The good folks at Percona have written more about it, including benchmarks in a few different scenarios: http://www.mysqlperformanceblog.com/2011/11/06/im.... If you are doing an insert directly in to the new table, it may be better to simply delay adding indicies until after the table is populated.

We need to know which session is yours. HTTP is stateless, so we use a cookie to keep the identifier for your session on your browser, the actual contents of the session are stored on our servers.