List:General Discussion« Previous MessageNext Message »
From:Michael Bacarella Date:December 20 2005 10:46pm
Subject:ALTER TABLE on InnoDB -- behind the scenes?
View as plain text  
Confused about how ALTER TABLE foo ADD col2... operates.
  
  On an otherwise idle server, iostat 1 shows the disk being written to  at a rate of
15MB/sec (its capacity is about 50MB/sec), but the  ibdata-autoextend file only grows at
a rate of 500kb/sec.
  
  12GB table (w/ 1.5GB index) took 6 hours to complete, which suggests the actual table
rewriting did happen at 500kB/sec.  Something wrong here?
  
  What else was going on? 
  
  MySQL 4.1.10a RHEL4.1
Thread
• ALTER TABLE on InnoDB -- behind the scenes?Michael Bacarella20 Dec