Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm chasing connection issues with a very busy MySQL server and I've increased the back_log setting from the default of 50 to 2048. I can see that the setting has taken affect in the DB, but I was hoping there was a way to view the actual number of connections that are being queued, so that I can verify this has solved my problem.

Is this possible?

share|improve this question
    
You can execute SHOW FULL PROCESSLIST and see the # of rows this indicates # of connections (connection threads connected) to the server. –  Mahesh Patil Dec 16 '13 at 11:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.