[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

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

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
melwong
Asked:
melwong
1 Solution
 
Garry GlendownConsulting and Network/Security SpecialistCommented:
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
 
mtayyab1984Commented:
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now