Solved

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

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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What does this formatting equate to? 7 18
Wordpress Cron - Send XML Data to external server FTP 3 23
Combining Queries 7 28
How do I show metrics with PHP or Javascript 6 33
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
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 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 …

860 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