Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 21, 2012 04:44 PM by hemant.yadav
Nov 21, 2012 09:48 AM|LINK
I have dedicated database server xeon server with 6 GB Ram where MySql 5.4 database running. My Database having around 5 Million plus record and having around 90 tables.
Whenever site getting more request my database server failed to responed the request and got hang and i must have to restart it.
Please help me how to resolve it or am i missing any configuration on the server.
Nov 21, 2012 10:52 AM|LINK
please check server logs. what is hanging your database or your server?
Nov 21, 2012 11:00 AM|LINK
In this case various possibilities....
1. Your IIS not responding
2. Application pool is full
3. You have use log of session variable so you memory full.
4. SQL database lock or not responding (this is higer chances as you said there are huge data, so to veriry this fire sql query once web browser not reposding of your server. If problem in sql then find our is there any lock or due to huge data then fine
tune your query.
Nov 21, 2012 11:15 AM|LINK
My IIS and Pool working fine on application server. I have 2 dedicated server 1 is for database and another server for application. Everything work fine on application server.
But database server i have installed MySql and using MySql Database not Sql Server.
Nov 21, 2012 11:24 AM|LINK
Did you managed to check logs on database server?
When you have dedicated server for database you wanna check if your application in closing connection when the job is done.
also look at your connection port on database server? if connection is not closed it can cause port to block or slowdown data transfer.
Nov 21, 2012 11:28 AM|LINK
then is there any problem in mysql server ? mean mysql server respnding or not
Nov 21, 2012 11:34 AM|LINK
mysql server has limitation of connections but if its handled correcly it works like a charm..
i will definately monitor port?
Nov 21, 2012 04:44 PM|LINK
MySql Server stopped responding when it having more request.