From 4886d14827c69877e8d089ae7c7f178a9a54ad7a Mon Sep 17 00:00:00 2001 From: Varun Gupta Date: Fri, 7 Dec 2018 02:12:22 +0530 Subject: MDEV-17032: Estimates are higher for partitions of a table with @@use_stat_tables= PREFERABLY The problem here is EITS statistics does not calculate statistics for the partitions of the table. So a temporary solution would be to not read EITS statistics for partitioned tables. Also disabling reading of EITS for columns that participate in the partition list of a table. --- sql/partition_info.h | 1 + 1 file changed, 1 insertion(+) (limited to 'sql/partition_info.h') diff --git a/sql/partition_info.h b/sql/partition_info.h index f250c5496bf..10b8954ace7 100644 --- a/sql/partition_info.h +++ b/sql/partition_info.h @@ -384,6 +384,7 @@ private: bool is_full_part_expr_in_fields(List &fields); public: bool has_unique_name(partition_element *element); + bool field_in_partition_expr(Field *field) const; }; uint32 get_next_partition_id_range(struct st_partition_iter* part_iter); -- cgit v1.2.1