Skip to main content

How to get Active Transactions and Locks from MySQL

To get a list of active transactions and locks that are currently executing against our target database

MySQL captures transaction and lock information in the INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS INFORMATION_SCHEMA tables.
  • INNODB_TRX provides us with information on the currently executing transactions.
  • INNODB_LOCKS gives us information on current lock.
  • INNODB_LOCK_WAITS provides information on who is actually waiting for locks. 
The query below enables one to see active locks filtered by a particular database:

    Post a Comment

    Popular posts from this blog

    How to reset password of Jenkins

    Reset password of JenkinsPrefer way, No securities were harmedSee also:
    What is Jenkins' initial admin password

    To reset it without disabling security if you're using matrix permissions (probably easily adaptable to other login methods): In config.xml, set disableSignup to false.Restart Jenkins.Go to the Jenkins web page and sign up with a new user.In config.xml, duplicate one of the <permission>hudson.model.Hudson.Administer:username</permission> lines and replace username with the new user.If it's a private server, set disableSignup back to true in config.xml.Restart Jenkins.Go to the Jenkins web page and log in as the new user.Reset the password of the original user.Log in as the original user. Optional cleanup: Delete the new user.Delete the temporary <permission> line in config.xml.
    Alternative way:
    ssh to the server, disable authentication, set the password via the Jenkins Web UI, then enable authentication.

    How to Remove / Hide "Powered by Blogger" (Attribution Gadget)

    Settings -> Template -> Edit HTML -> Jump to widget: choose Attribution1

    Change it to:

    <b:widget id='Attribution1' locked='false' mobile='no' title='' type='Attribution'/>

    Go to Layout, remove Attribution1 widget.

    To hide: Template -> Customize ->  Advanced -> Add CSS - Paste the following code  -> Apply to Blog:
    #Attribution1 { display: none!important; }