/
MySQL User Connection Analysis
MySQL User Connection Analysis
- Jonathan Schmale
Owned by Jonathan Schmale
Total Thread Connections
show status where variable_name = 'threads_connected';Max Connections
The connected threads are limited by max_connections:
show variables like 'max_connections';
SET GLOBAL max_connections = 350;Connection Timeout
The connected threads timeout and are closed if they are inactive for too long.
show variables like 'wait_timeout';
-- applies to new connection sessions only - 20 minutes (default 28800 is 8 hours)
SET GLOBAL wait_timeout = 1200; -- secondsRunning Threads
Top Hosts
If you want to know which hosts and users are taking up the most open connections quickly and easily:
Top Hosts By User
, multiple selections available,
Related content
Trouble Connecting to MySQL Database
Trouble Connecting to MySQL Database
More like this
MySQL Encrypted Connections
MySQL Encrypted Connections
More like this
Riding Results Summary
Riding Results Summary
More like this
High Level Results
High Level Results
More like this
Configuring MySQL Users
Configuring MySQL Users
More like this
Results Timelines
Results Timelines
More like this