List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 10 2006 7:30pm
Subject:Re: dropping primary key - 99%CPU
View as plain text  
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
Thread
dropping primary key - 99%CPUGaspar Bakos10 Jun
  • Re: dropping primary key - 99%CPUDan Nelson10 Jun
    • Re: dropping primary key - 99%CPUGaspar Bakos10 Jun
      • Re: dropping primary key - 99%CPUmos11 Jun
      • Re: dropping primary key - 99%CPUebergen11 Jun