Hi Baron,
I need to try some trick like that, a sort of offline index building.
Luckily I have a slave on that is basically a backup server.
Tomorrow I am going to play more with the dude.
Do you think that there would be any improvement in converting the table
to InnoDB
forcing to use multiple files as tablespace?
Thanks
Claudio
Baron Schwartz wrote:
Claudio,
http://www.mysqlperformanceblog.com/2007/10/29/hacking-to-make-alter-table-online-for-certain-changes/
Your mileage may vary, use at your own risk, etc.
Basically: convince MySQL that the indexes have already been built but
need to be repaired, then run REPAIR TABLE. As long as the index is
non-unique, this can be done by sort. In your case, the index
(PRIMARY) is unique, so you'll need to see if you can work around that
somehow. Maybe you can create it under another name as non-unique,
build it, then swap it and the .frm file out. Have fun.
This is the only option I see for you, but maybe there are others.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
