22 votes
Accepted

What reasons are there to stop the SQL Server?

Brent listed some invalid reasons for stopping the service, but there are valid reasons too: Restart required by a service pack or other update Certain configuration changes (e.g. service account ...
Aaron Bertrand's user avatar
20 votes

What reasons are there to stop the SQL Server?

Because they think there's a memory problem - SQL Server uses all of the memory available to it, up to its max memory setting (and even beyond.) Unknowing folks go into Task Manager, see SQL Server ...
Brent Ozar's user avatar
  • 42.5k
13 votes

Error: MySQL shutdown unexpectedly

I came across similar problem and tried this Stack Overflow answer by Fabrizio Valencia. It worked. Stop there! Please do not delete anything! First try to do what I did. OK, none of the listed ...
User_beginner's user avatar
6 votes
Accepted

How to unmount oracle database?

Yes, it's possible. SQL> alter database close; Database altered. SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED SQL> alter database dismount; Database ...
atokpas's user avatar
  • 8,544
6 votes

What steps are necessary to safely restart a machine hosting Microsoft SQL Server?

This is all detailed exhaustively on this page. Start, Stop, Pause, Resume, Restart SQL Server Services Being that your question specifically asks "are there any recommended by Microsoft" I'm ...
Evan Carroll's user avatar
  • 60.3k
5 votes

How to shutdown postgres through psql?

The documentation tells you to send a signal to the master postgres process, or to let pg_ctl do this. In SQL, you can extract the PID of the master process from pg_read_file('postmaster.pid'), but ...
CL.'s user avatar
  • 5,063
4 votes
Accepted

DB Restart Taking too long, site is down

Without seeing any additional information, here is my best guess why MySQL is trying to shutdown for a long time: I suspect mysqld no longer has a socket file. About 1.5 years ago, I answered mysql ...
RolandoMySQLDBA's user avatar
3 votes
Accepted

Unable to shut down MySQL server

Ideally you can shutdown using /etc/init.d/mysqld stop I cannot add comments so requesting to post what do you see in error log when you do mysqladmin shutdown About kill commands please note ...
mysql_user's user avatar
  • 1,892
3 votes
Accepted

How does Oracle close and unmount a database?

It helps to understand what 'mount mode' means: Before DB is mounted, instance is up (SGA and other memory structures are allocated but DB and its files etc have not been verified yet. In mount mode, ...
Raj's user avatar
  • 902
3 votes
Accepted

Is this way of MySQL shutdown via bat file sufficient to minimise corruption?

If you want to shutdown MySQL effectively, you need to run several things @echo off rem rem Flush Everything and its Grandmother rem echo "Stopping MySQL Service" "C:\host\MariaDB\bin\...
RolandoMySQLDBA's user avatar
3 votes
Accepted

How can I stop Oracle Shutdown command?

It seems like the obvious answer is that you can't stop a shutdown that is happening, but you can do either a shutdown immediate or shutdown abort from a different session if you did a shutdown normal....
Gandolf989's user avatar
  • 1,510
3 votes
Accepted

MySQL customized service script for zip installation

SHUTDOWN MySQL 5.7 now features the SHUTDOWN command, which requiresthe SHUTDOWN privilege. SHUTDOWN METHOD #1: Within mysql client mysql> SHUTDOWN; SHUTDOWN METHOD #2: From OS using mysql ...
RolandoMySQLDBA's user avatar
3 votes

SQL Server service start automatically only after Windows Shutdown, how can I make restart automatically without batch file?

You can set the service property to restart it (service properties --> recovery --> first / second / third failure and have a delay between each restarts e.g. 1 min). You should also, have the service ...
Kin Shah's user avatar
  • 61.8k
2 votes

Does the order in which vms are shutdown impact the postgresql replication environment?

You can shutdown and restart primary and standby in any order you want; that won't cause a problem. However, you could get into trouble if you keep the standby server down while data modifications ...
Laurenz Albe's user avatar
  • 42.5k
2 votes

My SQL server cannot start after a sudden shutdown

The error message says a system database, model has it's log file broken: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x83635096; actual: 0x83634816). It ...
vonPryz's user avatar
  • 2,926
2 votes
Accepted

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

I'm pretty sure the recovery process is done on each database everytime the instance start. (and in other scenario as well, like an AG failover for example) If it was stopped in a clean way, there ...
Dominique Boucher's user avatar
1 vote

MariaDB 10.1 shutdown stuck at "Event Scheduler: Purging the queue"

MySQL also have the same problem. I encountered the same problem in MySQl5.7.19. When shutdown a mysql server, it stuck at "Event Scheduler: Purging the queue. 0 events". In MySQL5.7.25 ...
Peanut's user avatar
  • 11
1 vote
Accepted

MySQL keeps shutting down: /usr/sbin/mysqld: unknown variable 'set-variable=key_buffer_size=32M'

in the Module Configuration for mysql you find the path to my.cnf Edit this file and remove the line with key_buffer_size=32M and save it. And then start the server. Webmin information on mysql
nbk's user avatar
  • 7,846
1 vote

Know when MySQL server was slow shutdown?

Priviet Юрий You question puzzled me a bit first. The answer to your question was too easy and this is dangerous... About time - was, is and will be How can I find out if the database "was" ...
shinguz's user avatar
  • 61
1 vote

Audit OSQL command shutting down a SQL Server

As mentioned by Dan Guzman if you are using the T-SQL SHUTDOWN command to shut down SQL Server, you see see the details with username in two places: SQL Server Error Log Date 3/15/2020 7:44:...
SqlWorldWide's user avatar
  • 12.8k
1 vote

How to allow in-progress transactions to complete when shutting down PostgreSQL?

I don't know of a way to do this automatically. You could start a smart shutdown, and then loop through live connections terminating them if they are idle. This would be a bit fragile, as if your ...
jjanes's user avatar
  • 36.3k
1 vote

Getting MySQL start and shutdown time

STARTUP TIME For everyone running MySQL 5.7 SELECT NOW() - INTERVAL variable_value SECOND MySQL_Started FROM performance_schema.global_status WHERE variable_name='Uptime'; For anyone running MySQL ...
RolandoMySQLDBA's user avatar
1 vote

/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that?

Just to add one more possible reason: in my case it was the unattended-upgrades (on Ubuntu) who did the restart of mysql.
Silvan's user avatar
  • 11
1 vote

What reasons are there to stop the SQL Server?

One reason could be is that you bought new hardware and migrated the databases to this new server. You now are shutting down this sql server instance on the old box (together with the box itself) ...
SQLMenace's user avatar
  • 289
1 vote

What reasons are there to stop the SQL Server?

A valid reason is when there is other software running on the same server that needs some of the memory SQL server has, but that only runs a few times a month. For example my wife (an accountant ...
Ian Ringrose's user avatar
1 vote
Accepted

Oracle crashing on CentOS

this is surely a resources or limits problem. For the first check if you have RemoveIPC enabled (Man for login.conf If it does not solve, review the Database Quick Installation Guide in the sections ...
Giova's user avatar
  • 402
1 vote

MySQL server cannot be stopped

You may not be aware of this, but the MySQL service is designed to be restarted automatically. There is a program called mysqld_safe. Its job is to do the following: STEP 01 : start mysqld STEP 02 : ...
RolandoMySQLDBA's user avatar
1 vote

MySQL server cannot be stopped

Try stopping the mysql server, instead of killing the process: sudo /etc/init.d/mysql stop
andresigualada's user avatar
1 vote

MySQL database got corrupted

MySQL can run as a service and I hope that windows is stopping the services gracefully or you are likely to have more problems outside of MySQL. If you want to be careful, stop the service by hand. ...
eroomydna's user avatar
  • 1,031

Only top scored, non community-wiki answers of a minimum length are eligible