tag:blogger.com,1999:blog-1135944569112521190.post2850439602019939805..comments2024-03-28T08:20:49.787+01:00Comments on Daniël's Database Blog: When your query is blocked, but there is no blocking queryDaniël van Eedenhttp://www.blogger.com/profile/14757324605223498151noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1135944569112521190.post-85327254129655865372019-11-07T11:31:52.809+01:002019-11-07T11:31:52.809+01:00There are Multiple Queries Executed on the same ta...There are Multiple Queries Executed on the same table in events_statements_history_long , How can i know which one among them ?? <br /><br />We use tomcat connection pool , to get the connections for our service <br />sreeramhttps://www.blogger.com/profile/08372522046489614173noreply@blogger.comtag:blogger.com,1999:blog-1135944569112521190.post-9846724700672216532014-10-26T19:57:11.726+01:002014-10-26T19:57:11.726+01:00Good one. Thanks.Good one. Thanks.Daniël van Eedenhttps://www.blogger.com/profile/14757324605223498151noreply@blogger.comtag:blogger.com,1999:blog-1135944569112521190.post-42613800113332933582014-10-26T17:27:03.897+01:002014-10-26T17:27:03.897+01:00For viewing the statements a transaction has done ...For viewing the statements a transaction has done previously, I generally recommend enabling and using the events_statements_history consumer/table, which holds the last 10 statements per active thread, rather than events_statements_history_long, which is the last 10000 globally (which could age out quickly). This will you will *always* get the last 10 statements per thread.Mark Leithhttps://www.blogger.com/profile/07526409233197705882noreply@blogger.com