mysql
阳光的毛毛
这个作者很懒,什么都没留下…
展开
-
mysql时间处理
MySQLdatediff(date1,date2):两个日期相减 date1 - date2,返回天数。selectdatediff('2008-08-08', '2008-08-01'); -- 7selectdatediff('2008-08-01', '2008-08-08'); -- -7参考:MySQL:日期函数、时间函数总结(MySQL 5.X)http://...原创 2019-12-28 19:14:09 · 139 阅读 · 0 评论 -
InnoDB page compression--InnoDB页面压缩
14.9.2InnoDB Page Compression14.9.2 InnoDB页面压缩InnoDBsupports page-level compression for tables that reside infile-per-tabletablespaces. This feature is referred to asTransparent Page Compress...翻译 2019-12-28 19:09:55 · 389 阅读 · 0 评论 -
InnoDB Table Compression---InnoDB表压缩
14.9.1.1 Overview of Table Compression表压缩概述Because processors and cache memories have increased in speed more than disk storage devices, many workloads are disk-bound. Data compression enables sma...翻译 2019-12-28 19:07:47 · 553 阅读 · 0 评论