diff options
| author | Mattias Jonsson <mattias.jonsson@sun.com> | 2010-03-04 12:09:09 +0100 |
|---|---|---|
| committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2010-03-04 12:09:09 +0100 |
| commit | 2d5c6b5bfef5a078279b2f34e1f4ec701a545672 (patch) | |
| tree | 192b9147cfa1de054d482806c80fa69dd6b55e62 /sql/ha_partition.cc | |
| parent | be2a015e1270699084e7690faac669ee7fa6c84d (diff) | |
| download | mariadb-git-2d5c6b5bfef5a078279b2f34e1f4ec701a545672.tar.gz | |
Bug#48229: group by performance issue of partitioned table
Problem was block_size on partitioned tables was not set,
resulting in keys_per_block was not correct which affects
the cost calculation for read time of indexes (including
cost for group min/max).Which resulted in a bad optimizer
decision.
Fixed by setting stats.block_size correctly.
Diffstat (limited to 'sql/ha_partition.cc')
| -rw-r--r-- | sql/ha_partition.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/ha_partition.cc b/sql/ha_partition.cc index b854e270029..36bd90e3237 100644 --- a/sql/ha_partition.cc +++ b/sql/ha_partition.cc @@ -5053,6 +5053,7 @@ int ha_partition::info(uint flag) file= m_file[handler_instance]; file->info(HA_STATUS_CONST); + stats.block_size= file->stats.block_size; stats.create_time= file->stats.create_time; ref_length= m_ref_length; } |