[Sqlrelay-discussion] Sqlrelay Debug details

[Ömer F. İ. <ome...@pi...>]

Hi,

We're using sqlrelay with a php website and oracle8 db. We use php-pear for
connecting to sqlrelay.

Sqlrelay and Oracle db running on seperate machines in the same network.

The site is working well for some time and the status is like this:

 

Open   Server Connections:  200

  Opened Server Connections:  200

 

  Open   Client Connections:  14

  Opened Client Connections:  41657

 

  Open   Server Cursors:      1000

  Opened Server Cursors:      1000

 

  Times  New Cursor Used:     0

  Times  Cursor Reused:       1462678

 

  Total  Queries:             731148

  Total  Errors:              755

 

Forked Listeners:           0

 

Sometimes open client connections suddenly increases. Oracle cpu usage at
that time is fine.

I wanna ask a few questions. Any help will be great.

 

Total Errors: 755 is that important? And what kind of errors is it counting?
Can i find them in the debug mode?

If a erronous query is sent to oracle, does it make sqlrelay get stuck or
something?