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
 



  • No labels