Solved

Is it safe to stop mysql server when server is busy?

Posted on 2012-03-18
2
413 Views
Last Modified: 2012-03-18
I'm getting too many connections coming in and my site hangs. Processlist in mysql shows lots of queries.

So is is safe to just stop mysql now? Will it interrupt any ongoing queries?
0
Comment
Question by:melwong
2 Comments
 
LVL 17

Accepted Solution

by:
Garry-G earned 50 total points
ID: 37734308
Anything that needs data from your database will stop working. If that's OK with you, shut it down ...
Please note that if the client software using the database is not programmed decently with transactions, it might leave data in an inconsistent state ... so a graceful shutdown of the clients (like, e.g., the web service) might be a good idea, then shut down the database (though the first step may already take care of your load problem ;) )
0
 
LVL 2

Expert Comment

by:mtayyab1984
ID: 37734402
if you properly shut down your SQL server, it won't loose anything other than those who are in the middle of some transactions (those will be cancelled). so its safe!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now