Magento : Too many database connections problem

Has an magento store which is getting busy into his business day by day and start throwing some performance related errors like this this one.
Yes this is Too many database connections problem when your store start getting attention of your visitors this could be obvious problem because you don't have took any developer care about the future of you store, so here is some tips about getting up and running your store smoothly.

This error comes when you try to connect to your mysql server and all available connections are in use by some other visitors.the number of connections is controlled by max_connections system variable this is set to 151 by default for MYSQL 5.5 and you can increase its values by following this simple steps :

1) Open your mysql configuration file located at /etc/my.cnf

2) Locate this variable max_connections

3) Set your desire number of available connection number for avoiding future error
max_connections = 250

4) Restart you mysql server and this will surely off your headache.


Thanks
If you found this post helpful and enjoyable please comment and share. :-)