4、是否基于存储引擎为表选用了合适的行格式(row format)。例如,压缩表在读写操作中会降低I/O操作需求并占用较少的磁盘空间,InnoDB支持读写应用场景中使用压缩表,但MyISAM仅能在读环境...
基于42个网页-相关网页
第33到51行格式化了表的主体。
此外,值压缩的行格式会为每一行占用两个字节。
In addition, the row format of value compression has a two-byte overhead per row.
因此,值压缩的行格式是否能产生正面的效果,取决于表的结构。
It therefore depends on the table structure as to whether the row format of value compression has positive results.
Imagine instead, you're writing code that's a hundred thousand lines, a million lines, of code. You don't want to write it in this form. All right, and the reason you don't want to do that is, well, several.
换一个角度来思考,你正在写的代码有几十万行,近百万行,你绝对不想写成这种格式,好吧,你不想这么做的原因有以下几个。
应用推荐