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.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…