mysql-proxy-discuss team mailing list archive

[Gadafi Aeiman <aeiman.gadafi@xxxxxxxxxxx>]

Thank you for your response,
If you do
print("response-time: " .. (inj.response_time)
this method give the response time in microseconds, the problem that in linux, 
the precision of the clock system is one millisecond "if I am right", so with 
this method, I have some random results "if the mysql server not charged"
regards



Le Monday 07 December 2009 13:49:27 Diego Medina, vous avez écrit :
> On Mon, Dec 7, 2009 at 4:09 AM, Gadafi Aeiman <aeiman.gadafi@xxxxxxxxxxx> 
wrote:
> > Hello,
> > I want to monitor the response time of the mysql servers
> > I have to write a lua script that do this:
> > for each received query
> >        time1= getcurrentTime "in milliseconde"
> >        execute query
> >        time2= getcurrentTime "in milliseconde"
> >        print "time2-time1"
> >
> > Did someone do this before??
>
> Someone did
>
> http://fernandoipar.com/2009/04/06/using-mysql-proxy-to-benchmark-query-per
>formance/
>
> :)
>
> Thanks
>
>   -Diego
>
> > Best regardes
> >
> > --
> >
> > Aeiman
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~mysql-proxy-discuss
> > Post to     : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> > More help   : https://help.launchpad.net/ListHelp


-- 


Gadafi Aeiman
IRIT/ENSEEIHT
2 rue Charles Camichel - BP 7122
31071 Toulouse cedex  7