From: Jorgen Loland Date: January 18 2011 3:20pm Subject: bzr commit into mysql-next-mr-bugfixing branch (jorgen.loland:3260) WL#5594 List-Archive: http://lists.mysql.com/commits/129099 Message-Id: <20110118152030.6D0C68B3@atum21.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1742989845921025553==" --===============1742989845921025553== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///export/home/jl208045/mysql/wl4800/mysql-next-mr-opt-backporting-wl4800-range-subselect/ based on revid:guilhem.bichot@stripped 3260 Jorgen Loland 2011-01-18 WL#5594: Add optimizer traces to the range optimizer Review comments: fix documentation for SQL_SELECT::traced_before modified: sql/opt_range.h === modified file 'sql/opt_range.h' --- a/sql/opt_range.h 2011-01-14 15:53:48 +0000 +++ b/sql/opt_range.h 2011-01-18 15:20:27 +0000 @@ -857,10 +857,13 @@ class SQL_SELECT :public Sql_alloc { bool free_cond; /** - Used by optimizer tracing if this is a subquery: Whether or not - execution of this subselect has been traced by optimizer tracing - already. If optimizer trace option DYNAMIC_RANGE is disabled, - this is used to disable tracing after the first one. + Used for QS_DYNAMIC_RANGE, i.e., "Range checked for each record". + Used by optimizer tracing to decide whether or not dynamic range + analysis of this select has been traced already. If optimizer + trace option DYNAMIC_RANGE is enabled, range analysis will be + traced with different ranges for every record to the left of this + table in the join. If disabled, range analysis will only be traced + for the first range. */ bool traced_before; --===============1742989845921025553== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/jorgen.loland@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: jorgen.loland@stripped\ # on7x3yd9qxmitvff # target_branch: file:///export/home/jl208045/mysql/wl4800/mysql-next-\ # mr-opt-backporting-wl4800-range-subselect/ # testament_sha1: 441caa673d2e9459e9d0f186494785ee957d2c71 # timestamp: 2011-01-18 16:20:30 +0100 # base_revision_id: guilhem.bichot@stripped\ # 9zvrua9ejymso51i # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWRP8CeAAAatfgEAQWGf/9363 PqC////wUASGr1zrM9WWXjru7dwSkEnqZoUwxomgaQ9JPUYmJ6jQ2Ro0gaQlPKftSeSTwTNUyYjA AIyYCGBBKCmEaaTIymJB6mRkND1AAND1ABiRSemTJPajSbUZPJPU2iDRoAaAA0ElGkEeoxEPFMjT amQaAAAAAWicabCX0+d5RTFXv3+0rK0osyIEka8VtrM9CCC0Sx8PzoUKVx/hybgmmiYxqQqujrFQ GwONuZreejhp+aHujWsnkmVDlWe6E+Km+kbcoYTueRPfQsuI4xKKTwyLz8VlSMhmDdL35q33O3Iz UtDyXdnrcPOQhY9IailciondIlWIx7K821d9YPG3FHRDmVIgZrJ6WCdFrZXHTYQMxB2RDxaXlRoT AyykZ2iQcsUCAi55WX8bIRU0Pi9Kzljqtpkmrkj+s/WERK+Ix4TQO5xGSm6l2jEIYBBygBBQJSpb KxXmIqZxA00kHA4w+k3GGMomOEqj4kTAiMOC2TnLDfBLZVeEiFEilBkhJqpaFxQBwVL6+Yq9bZKT 5UzKvTNOJ2T4ua9aoqZaO+Kpr8jEZoaSmDSRHWWkJA0GpqXCeFsKQgdvQHZFD9BFGE2xS9MT5V5G IiWUTxXRL8IioF2hZYUTVOVr3VJRLbENtBouWmmjUJbE0uegnQleyrVOS66q12FEaSjKTg6LJYFg RkunEz14pKsbFGzy2scikTgepJhepFHaeg3nwMHhykPYcZfh/u31OYojZMU4lsdy4kvuRtMVNkKE FJ096xQa7jtNu48U4xtfHLe8AZls1sSHB7AbN+Ii7S4XNZAR0ImWUijSkf9PDtym87pPGIad9ZjT q/Z5pGnEvc7sDNoJzULLpEwqwI1XZEczwzMAb5IfM8DxUSIz1MkKMQwWNDvqHVlC0vS65Gmdokkc CPofLZr8I6aiGz5EodMVTPr6lUfNobbDdFEGRVv4Lzp5OfPE62ttDHDHBmIGJ3T6sOI5btcFNRnj aPJacGDQq/lhAYTicgBCg720pjSIkKVRO/TG+yuUfNunCKiZHTHmaxZnFQgUjWQiZ18RgUIV9AtV ZD421JdSsO7GsvWppMKEL0LEBbGpjlsz3orAswE1wC6+wu1IOOAtuIT7tavGfV0GRspj4MhxHUZy QVJdwBjwSfe3XJAsDBvxZ7iikKK0ppHha+ePodw59GRYlesDoGicxKFGEIMFaDTtTpDyAxUyucWZ NwCF+YzMs5gERW4/OtBLHYspINvCYMt40SzF+nqR5yqrMzMAyAskzixAFAhJ0dEGeHntmiTOByju q1U3TXj367QMqFEKRONU05DQ4ZFAOdzRDoCMZ8zALS0iTPtSrLQktilIwbst+iP04HOQLCXsHTMI 2ByiIhVMwkRgS4k2QApWkp5qYRRkT22EUCEmTHG+zVwlI7EVlHvV1FUkLrf/F+WoyWsw6kXM9KaE 1/VUmGfYqUGqx5LtVEKlXo5yMajTuwNZhyQLbHhS458OHFUUg90JVQFCpYdM8YmcopZmWont1KjC 90ZhhBRHIX4w6A3QMc/0DQLQYqQjBsNackrQdJdcNaF+UHMJLT/i7kinChICf4E8AA== --===============1742989845921025553==--