Solved

CPanel Dedicated Server Nameserver Issues

Posted on 2013-01-22
1
318 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo‚Ķ
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.:
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

808 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