Re: [Sqlrelay-discussion] performance statistics

[Devananda <kar...@ya...>]

Rodney Holm wrote:
> Here is a short thread regarding the implementation of statistics 
> gathering.
>
> Unfortunately Im not able to work on this anytime soon, hopefully this 
> information will come in handy to others looking to add this most 
> desirable feature to sqlrelay.
>
Rodney,

Thank you for sending me that thread. It gave me a starting point, and 
I've been digging into the source for a few hours now. I've reached a 
bit of a wall, however -- how does the sqlrconnection class relate to 
the sqlrconnection_svr class? My understanding of it is that the former 
is instantiated w/in each API's library and used to connect to the sqlr 
connection daemon, whereas the latter is how each sqlr connection daemon 
actually connects to the particular database server.

I was hoping to modify the sqlrsh tool just enough to get it to read 
info from the shared memory segment, but am having (most likely 
conceptual) trouble figuring out how to get that information -- sqlrsh 
only has an instance of sqlrconnection, so I'm guessing that I will need 
to create interfaces in both these classes to request/receive the status 
data which will be stored in the shared mem segment.

Any thoughts?

Regards,
Devananda