[Sqlrelay-discussion] debugging sql-relay
Brought to you by:
mused
|
From: <sql...@ma...> - 2010-07-09 22:49:32
|
I have an xmlrpc app that uses sql-relay to access a mysql server each time a client connects to the xmlrpc server. In the course of a day, It receives approximately 500,000 requests and each request makes between 1 and 5 queries. sql-relay often dies (processes are still running but queries return nothing even though data should be returned). When this occurs I manually restart it. The most recent time, before restarting it I ran sqlr-status: Open Server Connections: 15 Opened Server Connections: 2089 Open Client Connections: 1 Opened Client Connections: 25857 Open Server Cursors: 45 Opened Server Cursors: 6267 Times New Cursor Used: 0 Times Cursor Reused: 64067 Total Queries: 63549 Total Errors: 624 Forked Listeners: 25 My question is, what is a good way of debugging sql-relay? I've put it in debug mode at times (connection and/or listener) and all it does is create thousands of files which don't seem to provide anything of use to me. The number of "Forked Listeners" might be the problem considering that number is usually 0. Thanks for any tips in debugging this issue, Phil |