From: Jorgen Loland Date: January 18 2011 3:19pm Subject: bzr commit into mysql-next-mr-bugfixing branch (jorgen.loland:3259) WL#5594 List-Archive: http://lists.mysql.com/commits/129098 Message-Id: <20110118151922.9A6B38B3@atum21.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2213458994810986633==" --===============2213458994810986633== 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:jorgen.loland@stripped 3259 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:19:19 +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; --===============2213458994810986633== 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\ # es64bzmnv3kj27o2 # target_branch: file:///export/home/jl208045/mysql/wl4800/mysql-next-\ # mr-opt-backporting-wl4800-range-subselect/ # testament_sha1: 858c3b7d1f1a1479be2e8605c6c15a87c0b4382e # timestamp: 2011-01-18 16:19:22 +0100 # base_revision_id: jorgen.loland@stripped\ # woj63d5hvb53zsnq # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWTp7uJgAAbBfgEAQWGf/9363 PqC////wUARmozWYdud7Tl3ndhKRNGqn+miTTbQFT9Ke1Rk8TU9IxPKG1M0yYoGRUxNoNNNCNMpp 6Q0ZNAAAA0AZEMlPQBDEo0xp6poA9TQABkAGJFTeUntU/VPyoaAepp6T1A0AADQABJQUnlPDRMke hPUeo09Q9TQ0AAAAWib6bSb06ZCgZXs2cHxVpQ7GgWOX1XMiZ1oILRKnQ23KFK37jiySeeOKJiUw wdUKpGUm+yxjOd3r6dIPa5azFLOqXdZPSU+SDhU2zCVs6QcT4VCNA17CpBO3AVjtsepnCxDND33W YEmpF5lofleq+xpKcRC2vMBBblMkhUY8j6cuJXhY0HtUkZIZEjajQyiDxmuOo6jZIMHBCEjngVF4 Y+ECB5gjstKhJDhISBHFRmKoYxAIvjKUe2tqzGuRp2D9UcG6ZwE+fYQO9oDWD6REs9bY74DUMRqC QENxR5RhbtBuDqZlAkZuid7wyljZDfYIpoqRWrWLMJNogNH6DZDjMoUvRRmUPC56rmijGLxQDZnj HPsHmZL1SiW90DF0tShvjAJpaL1kqPlyki2lcFpnKxpyIJ10HYC+CYXvlcQgkZeZaqbY6zUN7TdG Z4zFRRAdjg3SEFIG4QEy0XcV2SM4EMCiA0zSuM4i7c4oy1Cdm+lIIPyl80tyRkI2IJvAo6SEQGdN PUNvg4U01RKMNmiJEN5wJWvUijvPUZ03knj7ynEaUc38mcDoKHRTkMa4m+/sTchzDHTZdBBSdn3W alplUv6Cj9aT/Nldo2iTK89a0Qcw0tYHnbKg+yIj7wRSZ1InliQhpR39PDWbk+Ph5Qu3LFxsP4UJ n3GRPY0SSbRNQXtwMmMw7etYuOtWMToKQRxync8OZgD4Eh9XgeKgiJY2SHDMal/X0i5wxoaTKuWK khs75cq3vk2ogd4lhoHlxZDt69KIMWtYaoBbESFKJgX1XDXmxOHErGAOa5qqIQ4Xj0UYghqtZhUj bGIy/TTIkf0oaHqhInca9RRTkFaCxWSp97n19omWcmxd3UEdOJG/szFRgU54Wr4EQTJZYV8uDItF bQ5oNMGseTDBF6LATXYTZbeJMvGbwT4gmgXYgyl5WJA6jOjtHIZVx8GY1logBmGGoCiSH7vqhgFY S3yuawngEK4sTQwoFSnyTh5naMbTUpMgWizD5zkM4Y4A9wUAtFsaQ0eOMdzzNquSHyRG45bpWCOh Ok9QlTLS0RgoHNMag6M4pUs32oqqqkhSjHb3KJAISJPAwJCwl58zTYTNALQVNup7AY6vQe9q686R toUwtmKMq32DkUAxn4kUhrjv2CQ1WkaZa6KkfcpSRDPnfnSX5SNagWj9Yo4KnHZRqCsy1kqNCXEn JUDWXAU82sIYSKb7xgAOdBjOknz3IQKQaxOQSCBwBqO/hZSZpKIF5bLYcVx3cqwxnkUgHphjx6N2 eSci6wMBylGD45jv5qBcg99duF4uAVIsbQIKhwyJo4iYpbtJHlrqdpjFqTFUJ1g2kgFgQqMWIIza tqckk43IZ8QbRAGN5/xdyRThQkDp7uJg --===============2213458994810986633==--