Hacker News Reader

Comment by mt42or | Hacker News Reader

"Cannot online add a new column" This is false. https://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-...

Very weird.

From https://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-...:

  Add column
  In-Place?: *Yes*
  Rebuilds Table?: *Yes*
  Permits Concurrent DML?: *Yes* (Concurrent DML is not permitted when adding an auto-increment column.)
  Only Modifies Metadata?: *No*
  Data is reorganized substantially, making it an expensive operation.

In practice, the last no is a serious problem.

Could you elaborate why it prevents online DDL ?

I think the point of the article is that adding an index to a big table with lots of writes is practically not possible:

Quoting from the article:

  real problem for big tables

  as adding a few columns to our biggest tables started to take 2+ hours
  or sometimes was completely unpredictable and exceeded our announced downtime windows.

Apparently, adding a column was even a problem during a maintenance window because the runtime was even longer than they expected.

Compared to PostgreSQL:

  As long as the new column is NULL and does not have a default value,
  it’s in practice a no-op to add it. No matter if your table size is 100MB or 100GB

The linked https://www.percona.com/doc/percona-toolkit/2.1/pt-online-sc... generally works really well though, and in the simplest case it's as easy as following the usage example. I'm surprised that they knew about it yet didn't invest the time to learn it.

Reply on news.ycombinator.com