Thanks for the response Madhaawa. I guess this is something useful if we can get this via analytics or JMX.
Thanks Godwin On Thu, Jan 4, 2018 at 12:58 PM, Madhawa Gunasekara <madha...@wso2.com> wrote: > Hi Godwin, > > We can use log4jdbc to check the backend latency of DB Calls. [1] > > What you have to do is > > 1) download the log4jdbc jar and paste into the lib folder. > 2) modify the log4j.properties file with your preferences : > > log4j.logger.jdbc.sqltiming=INFO > > 3) change the integrator.sh file to pass the system properties, you have > to specify the driver class in that property > *-Dlog4jdbc.drivers=<driverclass>[,<driverclass>...] * > 4) change the datasource configurations as mentioned in the documentation. > > - JDBC Driver from* com.mysql.jdbc.Driver *to > *net.sf.log4jdbc.DriverSpy * > - MySQL JDBC Connection string changed from > *jdbc:mysql://localhost:3306/test* to > *jdbc:log4jdbc:mysql://localhost:3306/test* > > [1] http://kveeresham.blogspot.com/2015/03/logging-jdbc- > activities-using-log4jdbc.html > > Thanks, > Madhawa > > On Wed, Dec 27, 2017 at 11:30 AM, Godwin Shrimal <god...@wso2.com> wrote: > >> Hi Devs, >> >> I have a proxy service which calls the DSS over local transport, I want >> to check the backend latency of DB calls. Since this is local transport we >> cannot use JMX (AFAIK Its anyway not giving endpoint wise stats). What is >> the best way to get this? >> >> Thanks >> Godwin >> >> -- >> *Godwin Amila Shrimal* >> Associate Technical Lead >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: *+94772264165* >> linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/ >> <https://www.linkedin.com/in/godwin-amila-2ba26844/>* >> twitter: https://twitter.com/godwinamila >> <http://wso2.com/signature> >> > > > > -- > *Madhawa Gunasekara* > Senior Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: +94 719411002 <+94+719411002> > blog: *http://madhawa-gunasekara.blogspot.com > <http://madhawa-gunasekara.blogspot.com>* > linkedin: *http://lk.linkedin.com/in/mgunasekara > <http://lk.linkedin.com/in/mgunasekara>* > -- *Godwin Amila Shrimal* Associate Technical Lead WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: *+94772264165* linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/ <https://www.linkedin.com/in/godwin-amila-2ba26844/>* twitter: https://twitter.com/godwinamila <http://wso2.com/signature>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev