[Sqlrelay-discussion] Strange behaviour of sqlr-connection-mysql

[Tom H. <tom...@sa...>]

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...