[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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