I have running one big web application and manipulate around 2 GP of data with 1500 users in a node system.i didn't go with server. while all users are in live the server goes down.
so want to know the below the things
You can go to
/etc/my.cnf file and check the maximum connection which is allowed.
The default setting for max_connections is 100. However you can update that.
You can change the setting to e.g. 200 by issuing the following command without having to restart the MySQL server
set global max_connections = 200;