dbTalk Databases Forums  

Connection Issues

mailing.database.mysql-plusplus mailing.database.mysql-plusplus


Discuss Connection Issues in the mailing.database.mysql-plusplus forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Craig Snyder
 
Posts: n/a

Default Connection Issues - 09-26-2005 , 01:14 PM






------=_NextPart_000_0032_01C5C28A.715A8400
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

All -



I was wondering if I could get some assistance.



We have written a server that uses MySQL++ to connect to a MySQL database.
We are using connection pooling so when the server starts up we open up X
number of threads. Lately we are seeing connections close. We added the
ping() to verify that the connect still exists and reconnect if is does not.
This weekend we saw several ping requests fail. Is this normal? Should we
not use connection pooling? Any advice?



Craig




------=_NextPart_000_0032_01C5C28A.715A8400--



Reply With Quote
  #2  
Old   
Warren Young
 
Posts: n/a

Default Re: Connection Issues - 09-26-2005 , 03:50 PM






Craig Snyder wrote:
Quote:
We are using connection pooling so when the server starts up we open up X
number of threads. Lately we are seeing connections close.
See the comments in the Wishlist regarding threading. Right now,
MySQL++ doesn't do anything at all to enforce the underlying
libmysqlclient restrictions on threads. It is quite possible,
therefore, that you are running into one of those limits.

It's also possible that you didn't build MySQL++ with threading support.
It isn't turned on by default.

The next version should have better constraints in place to help you
avoid violating libmysqlclient design limits. Would you be willing to
hammer such features and help us debug them or are you just looking for
a fix, and will move on after you get it?

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.