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.

MySQL 5.1.x | Windows Server 2003

Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue?

For example, if I set concurrent connections to 800 in the dialogue window, I see max_connections=1023 in my.ini. Why? Is this normal?

share|improve this question

1 Answer 1

max_connections is a global variable which will retain this value until you change it in my.ini and restart MySQL service.

Whereas concurrent connections can be measured by max_used_connections status variable which will vary based number of concurrent connections on your MySQL server. This value is used to calculate Highest number of concurrent connections. i.e. If this value is say 1000 and after sometime if number of concurent connections drops still this status variable will show 1000 until you execute Flush status query on your server.

To know exactly how many connections are open currently, you should check Threads_connected status variable.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.