[Sqlrelay-discussion] Sqlrelay Debug details
Brought to you by:
mused
|
From: Ömer F. İ. <ome...@pi...> - 2008-10-15 15:19:59
|
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? |