Solved

CPanel Dedicated Server Nameserver Issues

Posted on 2013-01-22
1
329 Views
Last Modified: 2013-02-07
Hi -

My company has a dedicated server running CPanel that I have cursory involvement in - but only insofar as if something messes up it ends up falling into my lap to fix.  CPanel isn't my admin tool of choice - but I'm comfortable enough to navigate around in it.

The server is messing up - insofar as at some point - it gets bogged down (I'm assuming a ram issue?) and the nameserver functions start messing up (sites cease resolving).  So - I can't get to the server if I use the actual domain names - but I can get to it if I just use the direct IP of the server.

Now - I've got a couple of suspicions as to what's causing it - and I'd like your perspectives to see if I'm off base or if I'm probably on target.

Most likely cause (in my opinion)
Too many open/sleeping MySQL connections  - There's a site that exists off-server that communicates with the SQL server on ours.  When I look at the open MySQL processes - at some point it bogs up and there are HUNDREDS of open/sleeping MySQL processes going which have been open/sleeping for hours and hours.  

I'm thinking that the other service doesn't close the connections properly after each transaction - and eventually that just bogs down the server.

Secondary possible cause (in my opinion):
the /dev/sda1 partion is too full and there's too much memory swapping going on

/dev/sda1             9.7G  6.4G  2.8G  70% /

What do you think? Is this something you've run into before - and do my guesses sound on target?  Or is there something I might be missing.

Thanks!
0
Comment
Question by:erzoolander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 21

Accepted Solution

by:
Julian Matz earned 500 total points
ID: 38808573
Do you have root access? If so, what does the "top" command reveal? Also, if you install 'sysstat', it will give you some useful tools to monitor your server's resources over a period of time, which can be logged and then analyzed.

I've had many of these issues. In two instances, it was the hard drive, containing the root file system that was failing/corrupt. In another case, it was the MySQL server, which was getting bogged down by corrupt tables. There were a couple of other issues, too, so it really could be different reasons.

You can set cPanel to alert you when the server load reaches a certain threshold. If you then start an SSH session to your server and run the top command, it might give you a hint as to what's consuming your resources. You can install csf and lfd from www.configserver.com. It's a very simple process, and it ties in very nicely with cPanel. It is meant as firewall and intrusion prevention system, but it can also send you alerts such as the high server load alert. This may be easier than using the sysstat tools, although they are not that difficult either.

Another useful command is 'free -h', which shows you information about memory usage.
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The purpose of this article is to demonstrate how we can use conditional statements using Python.
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question