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.
Hemant Yadav Software Developer
Please remember to click “Mark as Answer” on the post that helps you
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.
My Tech Blogs MCPD Enterprise and Web Application
MCTS Web, Window and Enterprise Application
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.
Hemant Yadav Software Developer
Please remember to click “Mark as Answer” on the post that helps you
hemant.yadav
Contributor
2261 Points
682 Posts
Server Stopped Responding When Having Around 1000 Request
Nov 21, 2012 09:48 AM|LINK
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.
Please remember to click “Mark as Answer” on the post that helps you
jagjot
Contributor
2648 Points
1229 Posts
Re: Server Stopped Responding When Having Around 1000 Request
Nov 21, 2012 10:52 AM|LINK
please check server logs. what is hanging your database or your server?
M.Sc, MIEEE, MCP, CCNA
amitpatel.it
Star
7908 Points
1856 Posts
Re: Server Stopped Responding When Having Around 1000 Request
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.
MCPD Enterprise and Web Application
MCTS Web, Window and Enterprise Application
hemant.yadav
Contributor
2261 Points
682 Posts
Re: Server Stopped Responding When Having Around 1000 Request
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.
Please remember to click “Mark as Answer” on the post that helps you
jagjot
Contributor
2648 Points
1229 Posts
Re: Server Stopped Responding When Having Around 1000 Request
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.
M.Sc, MIEEE, MCP, CCNA
amitpatel.it
Star
7908 Points
1856 Posts
Re: Server Stopped Responding When Having Around 1000 Request
Nov 21, 2012 11:28 AM|LINK
then is there any problem in mysql server ? mean mysql server respnding or not
MCPD Enterprise and Web Application
MCTS Web, Window and Enterprise Application
jagjot
Contributor
2648 Points
1229 Posts
Re: Server Stopped Responding When Having Around 1000 Request
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? http://dev.mysql.com/doc/refman/5.0/en/security-guidelines.html
M.Sc, MIEEE, MCP, CCNA
hemant.yadav
Contributor
2261 Points
682 Posts
Re: Server Stopped Responding When Having Around 1000 Request
Nov 21, 2012 04:44 PM|LINK
Hi Amit,
MySql Server stopped responding when it having more request.
Please remember to click “Mark as Answer” on the post that helps you