Hi Morten, You might want to read this post on MySQL Performance Blog that was posted a few days ago: http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/
Have a nice day, - Martijn On Wed, Mar 18, 2009 at 11:50, Morten <my.li...@mac.com> wrote: > > Hi, I just tried this on a local copy of the table with ~500.000 rows: > > execute 'ALTER TABLE users MODIFY email VARCHAR(255) CHARACTER SET latin1 > NOT NULL' > > The old character set was UTF8. We're doing this to make the index smaller. > This took around 45 minutes to complete. In production, we have about > 1.000.000 rows. While the production servers are dedicated DB servers in > comparison to my MacBook, I'm still concerned that this is going to > literally take hours. > > How can this be speeded up if at all? Dropping the index first and then > recreate? > > Br, > > Morten > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=mart...@crystal-labs.nl > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
