dbTalk Databases Forums  

Question about selectivity estimation for InnoDB and ha_innodb::records_in_range

mailing.database.mysql-internals mailing.database.mysql-internals


Discuss Question about selectivity estimation for InnoDB and ha_innodb::records_in_range in the mailing.database.mysql-internals forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Question about selectivity estimation for InnoDB and ha_innodb::records_in_range - 05-16-2006 , 08:32 PM






------=_Part_21283_21840573.1147829535700
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

ha_innodb::records_in_range uses btr_estimate_n_rows_in_range to estimate
the selectivity of a predicate for an index. btr_estimate_n_rows_in_range
scans the root block of the index to estimate the value.

Are these estimates less accurate immediately after a split of the root
block? There will be few keys in the root block after it has been split.

Mark Callaghan
mcallaghan (AT) google (DOT) com

------=_Part_21283_21840573.1147829535700--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.