locked
Server Stopped Responding When Having Around 1000 Request RRS feed

  • Question

  • User1805528910 posted

    Hi Everyone,

    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.

    Wednesday, November 21, 2012 5:48 AM

All replies

  • User1801871119 posted

    please check server logs. what is hanging your database or your server?

    Wednesday, November 21, 2012 6:52 AM
  • User-1011137159 posted

    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.

    Wednesday, November 21, 2012 7:00 AM
  • User1805528910 posted

    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. 

    Wednesday, November 21, 2012 7:15 AM
  • User1801871119 posted

    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.

     

    Wednesday, November 21, 2012 7:24 AM
  • User-1011137159 posted

    then is there any problem in mysql server ? mean mysql server respnding or not 

    Wednesday, November 21, 2012 7:28 AM
  • User1801871119 posted

    mysql server has limitation of connections but if its handled correcly it works like a charm..

    i will definately monitor port? http://dev.mysql.com/doc/refman/5.0/en/security-guidelines.html

    Wednesday, November 21, 2012 7:34 AM
  • User1805528910 posted

    Hi Amit,

    MySql Server stopped responding when it having more request.

    Wednesday, November 21, 2012 12:44 PM