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
