Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For the following hardware specification, how can I estimate the maximum concurrent connection of MySQL server?

  • Intel Xeon E5620 2.4GHz 12MB L3 Cache 1066MHz
  • 4GB x 3 1333MHz DDR3 ECC RAM
  • 300GB SAS HDD (10K rpm)
  • MySQL Server 5.1 Community version
  • Ubuntu Linux Server 11.04 LTS
share|improve this question

Test with mysqlslap.

share|improve this answer
Thanks for the answer. However, the purpose of estimating the maximum concurrent connection is to test whether the hardware is sufficient for certain amount of concurrent connection. We need to estimate the number of concurrent connection BEFORE purchasing the hardware. – Raptor Oct 19 '11 at 3:40

Your Answer


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.