[Sqlrelay-discussion] Strange behaviour of sqlr-connection-mysql
Brought to you by:
mused
|
From: Tom H. <tom...@sa...> - 2010-04-06 11:55:19
|
Sorry for the repost, forgot to attacht the configuration file. Hi All, I am observing some strange behaviour of sqlr-connection-mysql. I am running a webservice against SQLRelay version 0.41 on MySQL version 5.0.45 using drop-in library libmysql50sqlrelay.so on a CentOS 5.2 x64 server. When the webservice is running under relatively high load during office hours everything seems to be working fine, performance is as expected and no errors. However, when the load is low (during the night for instance) I see that one or more of my sqlr-connection processes die. I haven't been able to find out whether it simply exits or crashes, I have not been able to get them to core dump. After that I see that new sqlr-connection processes are started (with options '-silent' and '-ttl 60'). I then observe that queries sometimes take very long to complete, sometimes they even take more than an hour! The data returned is correct though. Anyone who have seen this behaviour as well? I have attached my SQLRelay configuration file for reference. Thanks for your time. Kind regards, Tom Hesp tom...@sa... |