[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    Memory leak in DBD::mysql with server side prepares?
From:       Jason <abysss () gmail ! com>
Date:       2006-05-30 19:31:18
Message-ID: d5b43acc0605301231q3b6ab5eeta75f8f7a5a1cf46e () mail ! gmail ! com
[Download RAW message or body]

First, here are the perl/mysql versions involved:
MySQL: 4.1.14
Perl: 5.8.0
DBI: 1.50
DBD::mysql: 3.0004

Here is a simple perl script that uses server side prepares (db vars removed):

#!/usr/bin/perl -w

use strict;
use DBI;

my $ssp   = 1;
my $count = 0;

my $query = "SELECT * FROM content_class WHERE id = ? LIMIT 1";

my $dbh_l = DBI->connect (
            "dbi:mysql:database=$DBName:host=$DBHost:mysql_server_prepare=$ssp",
            $DBUser, $DBPass,
            { RaiseError => 1, PrintError => 0 },
);

my $s_q   = $dbh_l->prepare($query);
my $id    = 484262734;

while (1) {
  $s_q->execute($id);
  my @data = $s_q->fetchrow_array();
  $s_q->finish;

  $count++;

  print "ran $count queries\r";

  sleep(0.3);
}

This script, when run, will eat about 10M of memory a second.  Am I
missing something about server side prepares?

Cheers,
-Jason

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=msql-mysql-modules@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]