From: Warren Young
Date: November 7 2007 8:57pm
Subject: Re: Issues with multi-queries
List-Archive: http://lists.mysql.com/plusplus/7144
Message-Id: <473226A6.9020307@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Paul Martin wrote:
> I cant attach b/c of size limits on this list, 

Actually, I think the list just strips all attachments.  Just paste the 
code inline instead.

If you are in fact pasting it inline and not attaching it, and it's 
really so big that it hits the list's size limit, you need to boil it 
down to something much simpler.  No one's going to want to wade through 
a huge program to tease the MySQL++ bits apart from everything else.

> 1. 'Lost Connection to the MySQL Server' This seems to happen quite
> often, and I can make it happen more frequently by limiting the time
> between queries.  In my program I have a multi-query with about
> 50-100 mostly updates being executed every 3 secs or so.  It will run
> fine for hours and then I get this message.  I have added some code
> to reconnect, which seems to help in most cases but not all.  I have
> seen a post about a similar problem on the mailing list.  I have
> noticed the same problem with my modded multiquery app, depending on
> the value I give the 'Sleep' function.

I'd need to see the code, but my wild guess is that you're doing 
something to annoy the underlying MySQL C API library.  It has limits on 
what it allows, when.

> I am pretty sure that I have a memory leak 

I've added a FAQ item on this topic:

	http://tangentsoft.net/mysql++/#memleak