mysql频繁更新的表，为什么字段数要设计少点？

Question

再看mysql手册的时候，看到一句话，如下：

For example, applications that perform frequent updates often have many tables with few columns, while applications that analyze large amounts of data often have few tables with many columns.

感觉说的有道理，但是细细想其背后的原理，却又说不出个所以然，有人能解答下吗？

Answer 1

我觉得是因为Mysql的锁机制，频繁更新的话，字段越多更新时间越长，对性能的影响就越大