Alter Table is Slooooowww

• Very disk I/O intensive

• MySQL rewrites all indexes every time!

  • Make several index changes at once
  • Make sure your key_buffer is big
  • Same for myisam_sort_buffer

• Think through changes carefully

• Plan ahead

• Alter off-line if possible

• Consider a progressive migration