[Sqlrelay-discussion] debugging sql-relay

[<sql...@ma...>]

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