Solved

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

Posted on 2012-03-18
2
415 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

If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
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.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

831 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