I'm performing some load tests on my brand new server PHP/Mysql. I'm testing a very simple API that perform this query:
select *,sleep(0.5) from debug limit 1
I added the sleep(0.5) because I wanted to see how the server behave with multiple concurrent connections and I found a bottleneck: if I run "SHOW PROCESSLIST" I can see only 5 process even if I have 10 concurrent user. The load test show that the connections are queued because the response time is growing during the test from 500 milliseconds to several seconds (depending on the duration of the test and the number of concurrent users).
I checked
select @@max_connections
and it's 151 (the default). What other parameter I should check to increase the number of concurrent connection on my DB?
Thanks a lot
Aucun commentaire:
Enregistrer un commentaire