Re: [Sqlrelay-discussion] performance statistics

[Rodney H. <rh...@et...>]

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.










Hey Rodney,

Sorry to take forever to get back to you.

I'd be happy to accept whatever work you're interested in doing on this.

In the past, I had considered implementing it using a block of shared
memory and then having a monitor program that just reads the values from
the shared memory segment and displays them on the screen.

The listener already maintains a block of shared memory to coordinate
communication between the listener and the connections.  There's a
struct in src/common/defines.h called shmdata that defines the contents
of the shared memory segment.  You could add any parameters that you'd
like to keep track of to that struct and then the connections could
increment/decrement them as necessary.

The sqlrconnection_svr class has a member variable called idmemoryptr
that points to the shared memory segment.  So, for instance, you could
add a parameter called querycount and increment it using
idmemoryptr->querycount++.

I'd recommend against coordinating access to the parameters with
semaphores, it would add way too much overhead.  The program that
monitors the parameters should just poll them periodically.

Those are my ideas.  Give it a shot and keep me posted  :)

Dave
dav...@fi...

On Thu, 2006-02-02 at 08:32 -0700, Rodney Holm wrote:

 >> David,
 >>
 >> I would be interested in working to implement this feature.  That is of
 >> course if you are willing to accept the help.
 >>
 >> Im new to sqlrelay and would like to get some guidance from you before
 >> embarking down this path.  Have you given some thought to where it would
 >> make the most sense to add the statistics gathering and retrieval?
 >>
 >> Since the connection processes can dynamically increase and decrease
 >> depending on configuration and load, storing the information at that
 >> level is probably not an option.
 >>
 >> What are your thoughts?
 >>
 >> thanks
 >> rodney
 >>
 >>
 >> David Muse wrote:
 >
 >>> > Sorry, it's not currently possible to get live statistics.  It's on the
 >>> > TODO list, but I haven't implemented it yet.
 >>> >
 >>> > Dave
 >>> > dav...@fi...
 >>> >
 >>> > On Tue, 2006-01-31 at 11:43 -0700, Rodney Holm wrote:
 >>> >
 >>
 >>>> >>Greetings.
 >>>> >>
 >>>> >>Is it currently possible to obtain live statistics for the defined
 >>>> >>instances?
 >>>> >>
 >>>> >>What I would like to see is things like:
 >>>> >># of active connections
 >>>> >># of queries sent
 >>>> >># of rows returned
 >>>> >># of ORA errors
 >>>> >># of requests handled by the listener
 >>>> >>
 >>>> >>Is that information stored somewhere currently and just not accessible
 >>>> >>or would the storage mechanisms need to be built into the objects?
 >>>> >>
 >>>> >>thanks
 >>>> >>rodney

Devananda wrote:
> Hello, list!
> 
> I've been testing sqlrelay for a few days, and would like the 
> development team here to be able to start using it soon, but one thing 
> is bothering me -- I have not found a way to monitor a running instance 
> of sqlrelay (or any of it's components), short of turning on debugging 
> and doing a lot of grep'ing and counting in the log files (which 
> wouldn't be feasible on a production system).
> 
> So ... does anyone know of a tool or method whereby I can see statistics 
> about the current performance of sqlrelay? ie, open connections, memory 
> usage, # of connections created, # of connections timed out, # of 
> connections waiting? I'm hoping for something similar to 'apachectl 
> status', though simple text output of a lot of variables (similar to 
> 'mysql> show status;') would be a huge help.
> 
> 
> Thanks in advance!
> 
> Devananda
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion