How Restart MySQL Linux on a Shared Signature UNIX account?

There may be times when MySQL cpu usage jumped to nearly 199% or even more and you needed to restart MySQL Linux. But you can’t do this. Whole of the website get stuck. None of your website is opening or there is problem loading website. Load of server becomes very high at that time. You must be scratching out your head, finding the solution to your problem. But found nothing.

There can be so many reasons for this unnatural cpu usage fluctuation by MySQL server.

Some reasons may be:

1. Some background process by server. Like, mail etc.

2. Some plug-in may be eating the cpu usage by giving heavy load. Some plugin may running in the background which is drying up the cpu like automated plugins, cache plugins etc.

3. Background log generation may be among other reason. Sometimes log file uses so many cpu to maintain its log, It's a cpu extensive usage .

4. Heavy traffic at any given point of time,

5. Excessive usage of database etc.

These all eats up cpu a lot. It will make the cpu usage shoot up to an uncontrollable level. Load on server also gets increased.

This article will help you to restart MySQL manually on a Shared Signature UNIX account. To do this process you will nbe needed to connect to your account via Secure Shell Connection.

To restart MySQL Linux connection, try the following steps:

1. Try to disable MySQL through control panel of your website account and thereafter re-enabling it. It will take time to do so. If that does not work, then only connect to the account using SSH client. There are so many free clients available on the internet. Try anyone of them.

2. Now Enter your login details and password to enter into your account.

3. Browse to your home directory by running following command on your ssh interface:
cd /usr/home/USERID

Replace userid with your account id in the above mentioned command.

4. Now try to run the following command on your ssh panel to restart your mysql.

Type the following on your screen

~/etc/rc.d/ restart

Now its time to check that whether MYSQL is running or not. If it is running, then you are successfully done, Otherwise you can just proceed to the next step.

5. Now attempt to stop MySQL manually by running the following command:

~etc/rc.d/ stop

Now see if there is any of MYSQL associated files by running the following Command:

ls –lah tmp/mysql*

6. You can get an output similar to this :

srwxrwxrwx 1 ver915 vuser 0B Jan 30 06:48 tpm/mysql.sock

7. Now remove the file you find by previous command by running following command:

rm tmp/mysql.sock

8. Now finally, run the following command to restart MYSQL:

etc/rc.d/ restart

If still there is problem then you can also try the following command:

rm tmp/mysql.sock

If still your problem persist then its now time to have a talk with your host and get it shorted out immediately. There may be some serious problem.

Hope this article on Restart MySQL Linux helped you to short out your problem.

Category: Web Programming Viewing 6537 | Added in February 13, 2014

0 Responses

Add comments:

Your name: Your website Some styles: Add button:
Your comments here:




Wise Words

"When we finally presented it at the shareholders' meeting, everyone in the auditorium stood up and gave it a five-minute ovation. What was incredible to me was that I could see the Mac team in the first few rows. It was as though none of us could believe that we'd actually finished it. Everyone started crying."

- Steve Jobs

Outside of subject

The wrong direction

Although this is the first post about my four hour workweek, it did not just start for me. If you read the about me section, that was almost a year ago. So how did I do? Well, I've made some progress. By falling and standing up. By making decisions and ignoring some. After my breakdown I...

continue reading

Going crazy – doing crazy

I ended up going on a trip to Oxford (UK), visiting some international friends I made by tango dancing, while it also was an opportunity to go dancing in London and Oxford.

Staying over with a friend was very nice and also useful. It made my trip cost way less, while I also had some...

continue reading

What you know about earning on blog posts

Service post on the blog: a dollar sign is the cheesiest - the process of verification of the blog.

Today, every blogger has the opportunity to receive a small remuneration for his work on the blog, write a short message or a review of a web resource, service, or company.


continue reading

My worry about losing the Queen

My worry about losing the Queen would be that she would still be entitled to take money from the Crown Estates. I hope when negotiations are taking place after the referendum, that the SNP would not go soft on this and on a number of other matters, like being over generous with the entitlement...

continue reading

How to get indoor an orchids to grow and bloom?

The thing which, apart from Climate Gate, really knocked them sideways was that bitterly cold December 2013.

Louise wouldn't remember it because she was with Chris Huhne in Cancun at the time and kept telling us how warm it was poolside — while it was –15ºC here and...

continue reading