Improve company productivity with a Business Account.Sign Up

x
?
Solved

CPanel Dedicated Server Nameserver Issues

Posted on 2013-01-22
1
Medium Priority
?
341 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
1 Comment
 
LVL 21

Accepted Solution

by:
Julian Matz earned 2000 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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

606 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