Bug #41815 memory leak if mysql_server_prepare is enabled

Description:
DBD::mysql has a memory leak when use "mysql_server_prepare=1".

How to repeat:
use DBI;
my $dbh = DBI->connect('dbi:mysql:mysql_server_prepare=1', 'sandbox', 'sandbox');
my $sth = $dbh->prepare('select 1');
while ( 1 ) {
    $sth->execute;
    $sth->fetch;
}

Suggested fix:
because execute many dbd_describe() maybe.
It seems resolved this problem when use this patch.

--- DBD-mysql-4.010.orig/dbdimp.c       2008-12-29 01:52:26.000000000 +0900
+++ DBD-mysql-4.010/dbdimp.c    2009-01-01 10:26:56.000000000 +0900
@@ -3159,7 +3159,6 @@
       /** Store the result in the current statement handle */
       DBIc_NUM_FIELDS(imp_sth)= mysql_num_fields(imp_sth->result);
       DBIc_ACTIVE_on(imp_sth);
-      imp_sth->done_desc= 0;
       imp_sth->fetch_done= 0;
     }
   }

Thank you for the report.

Verified as described.

Hello Masahiro

In order for us to continue the process of reviewing your contribution to MySQL - We need you to review and sign the Sun|MySQL contributor agreement (the "SCA")

The process is explained here: 
http://forge.mysql.com/wiki/Sun_Contributor_Agreement

Getting a signed/approved SCA on file will help us facilitate your contribution-- this one, and others in the future.

Thank you ! 

Liz Drachnik  - Program Manager - MySQL

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I can confirm this as still broken.

You need to fix this even if you can't get a sign off on that one line change.  Or at least document it as a known memory leak that you can't fix due to bureaucratic deadlock.

Almost 4 years, version 4.022 and bug still there.
It makes "server prepare" feature absolutely unusable on high-load web-projects, because scripts consume RAM very quickly.

FreeBSD 8.1-RELEASE amd64
MySQL: 5.1.48 FreeBSD port
DBI 1.622
DBD::mysql 4.022

Thank you for the report.

We don't work on DBD::mysql bugs anymore. All its bugs should go to CPAN: https://rt.cpan.org/Public/Dist/Display.html?Name=DBD-mysql

I re-submitted your report to https://rt.cpan.org/Public/Bug/Display.html?id=83486
Please subscribe to the new report on CPAN and work with DBD::mysql developers in case if they need additional details.