Hi! On Fri, Jan 9, 2009 at 4:39 AM, Sheeri K. Cabral <[email protected]> wrote: > Why isn't dropping an index/primary key/unique key/foreign key an online > operation? Or rather, why is it slow? It should be easy to drop an index, > there's no updating needed other than "don't use the index object any more".
I think in the case of innodb, dropping the primary key essentially involves creating a new primary key *and* reorder the data according to the order of the key entries. The secondary indexes would need to be updated as well to point to the new primary key's index entry. > > (the answer may very well be "it is a very fast operation")...at any rate, > this should be changed in Drizzle if it isn't already... > I think this would be slow rather than fast. (Just guessing this - Innodb experts, what say you?) roland. > > -- > - Sheeri K. Cabral > > Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a > remote DBA firm, and consulting would constitute a conflict of > interest. However, I do recommend our work, and if you're looking for DBA > work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) > right now, whether you need a few hours a week, or someone fulltime while > you continue a job search. > > I have a webpage with tips on how to find a > DBA: http://sheeri.net/how-to-find-a-dba/ > I can recommend http://www.toomanyconnections.com as a good site to find > MySQL (and Oracle) DBAs. > If you're looking for web design, I recommend the small business my husband > works for, http://www.digital-loom.com > I regret that I have no other information for any other type of position, > including developer, programmer and systems administrator. > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
