From: Tor Didriksen Date: October 1 2012 2:20pm Subject: bzr push into mysql-5.1 branch (tor.didriksen:3829 to 3830) Bug#14683676 List-Archive: http://lists.mysql.com/commits/144937 X-Bug: 14683676 Message-Id: <20121001142010.28874.18532.3830@atum07.no.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3830 Tor Didriksen 2012-10-01 Bug#14683676 ENDLESS MEMORY CONSUMPTION IN SETUP_REF_ARRAY WITH MAX IN SUBQUERY n_child_sum_items kept increasing. Since it is used for calculating the size of ref_pointer_array, we will allocate larger and larger chunks of memory, until we hit some operating system limit. The memory is free()d at disconnect, but is most likely *not* returned to the operating system. modified: sql/sql_lex.cc 3829 Joerg Bruehe 2012-10-01 [merge] Merge 5.1.66 into main 5.1 modified: support-files/mysql.spec.sh === modified file 'sql/sql_lex.cc' --- a/sql/sql_lex.cc 2012-04-18 11:14:05 +0000 +++ b/sql/sql_lex.cc 2012-10-01 11:12:38 +0000 @@ -1616,6 +1616,7 @@ void st_select_lex::init_query() ref_pointer_array= 0; select_n_where_fields= 0; select_n_having_items= 0; + n_child_sum_items= 0; subquery_in_having= explicit_limit= 0; is_item_list_lookup= 0; first_execution= 1; No bundle (reason: useless for push emails).