Alex Rivera | Logout

MySQL show status - active or total connections?

Asked 2011-09-15T14:10:16.027
327

When I run show status like 'Con%' it shows the number of connections, which is 9972 and constantly growing. Is this an active number of connections or connections made in total?

Edit
Report

1 Answer

172
SHOW STATUS WHERE `variable_name` = 'Threads_connected';

This will show you all the open connections.

answered 2013-07-08T22:18:03.063

Your Answer