I'm having some issues using multi-queries... I'm using a C++ dialog app with MySQL
5.0.19-nt and MySQL++ 2.3.2 on a Windows XP platform. I have modified the 'multiquery
example' to demonstrate these problems... I cant attach b/c of size limits on this list,
so I guess I can email it seperately (is there a better way?). Here is a summary of the
issues:
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.
2. Memory Leak
I am pretty sure that I have a memory leak as a result of the queries. I have only viewed
the usage in the Windows Task Manager window and I realize that isn't necessarily
accurate, but my app seems to grow and grow from approx 3.5Mb to over 12Mb in 3 hours.
I've turned off other things, etc. and it seems to be the db queries causing it. I have
noticed a similar growth with my modded multiquery app. It is hard to tell for sure as
the usage seems to drop after a while to below its starting level (once only). I think
this is some sort of WIndows garbage collection. However the growth starts again and
continues way past the original point it dropped.
TIA for any help.
Paul Martin

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.