Load Testing with 250 users

Question

I have been testing my web application with a load of 250 simultaneous users. But i am getting a database error -

A Database Error has occured Unable to connect to the database with the following settings filename: core/loader.php

I have no idea about the reason the database goes down like this?

probably you have too many concurrent database connections. check your DB configurations see also [the manual](https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html) (but disregard the outdated PHP-code-examples using the mysql_-functions) — Franz Gleichmann, Oct 20 '16 at 11:05

score 1 · Answer 1 · edited May 23 '17 at 12:19

1

It sounds like you have hit the MySQL connection limit:

Add the line below to the bottom of your my.cnf and restart MySQL

max_connections = 250

You'll need to tweak this value to suit your server best - see What does max_connections really mean? and the docs for more details on how to pick this value - but 250 should be fine for your testing

edited May 23 '17 at 12:19

Community

1
1

answered Oct 20 '16 at 11:09

JBithell

627
2
11
27

@sunshine Did this work for you? If it did please select it as the accepted one – JBithell Oct 24 '16 at 18:16
it was a micro instance on AWS and we changed to a medium tier and was resolved – sunshine Oct 25 '16 at 06:56

Load Testing with 250 users

1 Answers1