MySQL DBA Tools - Session Manager
Provides manageability for database sessions allowing the user to monitor and kill sessions.
Toolbar Operations -
Available Operations for Sessions tab Refresh : Refreshes all the tab results from the database Reconnect : Reconnects to the database server Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds" Expand all : Expands all user's sessions available Collapse all: Collapses all user's sessions available Kill Session: Allows to kill selected session Group Sessions: Allows to group running sessions by Port, User, Command, State, Host, Process ID, Database, Time, and Info, allowing to locate sessions easier
Sessions Tab - Provides a list of sessions currently held by the MySQL server, as a tree view
Host: Server user name (login) Process ID: Number of process ID Port: Port number for the session User: Name of the user Database: Name of the database Command: Type of command Time: Time the session has been active State: Actual state of the session Info: Additional information on the session