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)