Tuesday, February 28, 2012

How to display current thread in mysql?

This is going to be a very short post. :) If you would like to know how many transactions remained uncommitted(opened) in mysql server then all you have to do is just run this query on your mysql server.

SHOW FULL PROCESSLIST

Short, isn't it? 

1 comment:

  1. or sometimes is more usefull select * from information_schema.processlist :P

    ReplyDelete