Re: dropping primary key - 99%CPU

[Dan Nelson]

In the last episode (Jun 10), Gaspar Bakos said:
> Could someone explain why dropping a primary key of a table (of
> ~1million rec) may take up to minutes of time and 99%CPU?
> 
> Naively, I would have thought that this involves only updating the
> index file.

Currently mysql handles all "ALTER TABLE" commands by rebuilding the
entire table and all indexes.

-- 
	Dan Nelson
	dnelson@stripped