Sleep Mode - Slow Request

Question

inside hibernate.property. that any parameter I can set so that all slow queries take too long to return a result? I am using spring -hibernate applicationContext.xml

Answer 1

I have 2 suggestions:

• you can use Oracle Statspack.
• you can use some JDBC P6Spy or log4jdbc proxy protocol runtime .

I used IronGrid's P6Spy and IronTrack SQL in the past, and it was a decent combo (see this blog post ). But note:

• P6Spy (5 ).
• ( ).
• IronTrack SQL ( , ).

log4jdbc, ( , , Excel, script ). -:

• JDBC 3 JDBC 4!
• , , , net.sf.log4jdbc.DriverSpy prepend "jdbc: log4" URL- jdbc, !
• SQL . .
• SQL , , SQL- , , SQL .
• SQL .
• JDBC JDK 1.4 SLF4J 1.x.
• , Apache 2.0 : http://www.apache.org/licenses/LICENSE-2.0

Answer 2

SQL , hibernate.show_sql true (. http://www.javalobby.org/java/forums/t44119.html). . , mysql, , , .

: http://adminlinux.blogspot.com/2009/07/mysql-slow-queries-log.html

, .