MySQL process list – Customized connection counts

August 27, 2014

You got a production support call related to connection usage. Max_connections is set to 400 and  connection usage has reached the maximum limit. Below are some of the customized reports that can be used to trace the problem Count by host : mysql> select count(*),host from information_schema.processlist group by HOST; +———-+———–+ | count(*) | host […]

Read the full article →