Monitoring used connections on mysql to debug 'too many connections'
- by Nir
On LAMP production server I get the 'too many connections' error from MYSQL occasionally, I want to add monitoring to find if the reason is that I exceed the max-connections limit.
My question: How can I query from mysql or from mysqladmin the current number of used connections?
(I noticed that show status gives total connections and not the…