mysql 分区表执行计划_mysql 执行计划走分区

最新推荐文章于 2024-01-19 10:37:29 发布

莫少儒

最新推荐文章于 2024-01-19 10:37:29 发布

阅读量355

点赞数

文章标签： mysql 分区表执行计划

本文链接：https://blog.csdn.net/weixin_35741582/article/details/113433812

版权

mysql> EXPLAIN PARTITIONS select count(*) from history where clock<1438876800;

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

1 row in set (0.00 sec)

mysql> EXPLAIN PARTITIONS select count(*) from history where clock<143899999;

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+--------------------------+

1 row in set (0.00 sec)

mysql> EXPLAIN PARTITIONS select count(*) from history where clock<1439049600;

+----+-------------+---------+-------------------------------+-------+---------------+-----------+---------+------+-------+--------------------------+

+----+-------------+---------+-------------------------------+-------+---------------+-----------+---------+------+-------+--------------------------+

+----+-------------+---------+-------------------------------+-------+---------------+-----------+---------+------+-------+--------------------------+

1 row in set (0.00 sec)

莫少儒

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql 分区表执行计划_mysql 执行计划走分区

mysql> EXPLAIN PARTITIONS select count(*) from history where clock<1438876800;+----+-------------+---------+------------+-------+---------------+-----------+---------+------+------+----------...
复制链接

扫一扫