AnsweredAssumed Answered

Optimize OTK MySQL database

Question asked by Tattwa on Aug 31, 2018
Latest reply on Oct 27, 2018 by Dustin Dauncey

Single external MySQL database being used for two Gateway Nodes(Node1, Node2). Observed different database query during load testing. So, is there any monitoring tools available to observe MySQL database transactions in a clustering environment.

How to optimize and analysis database transactions?

 

is there any CA provides monitoring performance tools?

 

e.g. insert token is taking 625 ms while load testing.

query :

INSERT INTO oauth_token (otk_token_id, token, expiration, client_key, resource_owner, status, created, client_name, scope, custom, client_ident)                                 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 

Stack trace error in New Relic

 


com.mysql.jdbc.PreparedStatement.executeUpdate (PreparedStatement.java:2347)
…e.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate (NewProxyPreparedStatement.java:105)
…amework.jdbc.core.JdbcTemplate$2.doInPreparedStatement (JdbcTemplate.java:817)
…amework.jdbc.core.JdbcTemplate$2.doInPreparedStatement (JdbcTemplate.java:1)

org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:586)

org.springframework.jdbc.core.JdbcTemplate.update (JdbcTemplate.java:811)

org.springframework.jdbc.core.JdbcTemplate.update (JdbcTemplate.java:867)
org.springframework.jdbc.core.JdbcTemplate.update (JdbcTemplate.java:875)

…h.server.jdbc.JdbcQueryingManagerImpl.performJdbcQuery (Unknown Source)

…h.server.jdbc.JdbcQueryingManagerImpl.performJdbcQuery (Unknown Source)

…h.server.jdbc.JdbcQueryingManagerImpl.performJdbcQuery (Unknown Source)

…assertions.jdbcquery.server.ServerJdbcQueryAssertion.a (Unknown Source)

…jdbcquery.server.ServerJdbcQueryAssertion.checkRequest (Unknown Source)

…ion.composite.ServerCompositeAssertion.iterateChildren (Unknown Source)

…cy.assertion.composite.ServerAllAssertion.checkRequest (Unknown Source)

…ion.composite.ServerCompositeAssertion.iterateChildren (Unknown Source)

…ertion.composite.ServerOneOrMoreAssertion.checkRequest (Unknown Source)

…ion.composite.ServerCompositeAssertion.iterateChildren (Unknown Source)

…cy.assertion.composite.ServerAllAssertion.checkRequest (Unknown Source)

…ion.composite.ServerCompositeAssertion.iterateChildren (Unknown Source)

Skipping 60 lines....(:0)
com.l7tech.server.tomcat.ResponseKillerValve.invoke (Unknown Source)
com.l7tech.server.tomcat.ConnectionIdValve.invoke (Unknown Source)

org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:109)

org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:295)

org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:861)

….http11.Http11Protocol$Http11ConnectionHandler.process (Http11Protocol.java:606)

…apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run (JIoEndpoint.java:396)

java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142)

java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:617)

java.lang.Thread.run (Thread.java:748)

Outcomes