3 ms·

You're talking about DDL. They're talking about an in-place rewrite of the value of a single column, which, yes, InnoDB will do with way less write load than p

by mst 9y ago

You're talking about DDL. They're talking about an in-place rewrite of the value of a single column, which, yes, InnoDB will do with way less write load than postgresql.

dk8996 9y ago
Yes, column updates. Although, using MySQL now, I really miss DDL migrations of PostgreSQL. It's a trade off.
ibotty 9y ago
Can you provide specifics? AFAICT that applies only to indexes (where there is another layer of indirection in MySQL).
- mst 9y ago
  InnoDB clusters on disk by PK so if your record is the same width and you don't change the PK it can AFAIK update in-place.
  - ibotty 9y ago
    Very late answer, but no, that is incompatible with mvcc. How can transactions (and rollbacks) work?