Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [shutdown]

51 questions
33
votes
5 answers

How to properly kill MySQL?

I have CentOS 64bit with CPanel installed and I use: service mysql stop It just keeps ticking periods and never seems like it stops. In the logs it just posts a lot of: 130303 17:42:38 [Warning] /usr/sbin/mysqld: Forcing close of thread In the…
Tiffany Walker
31
votes
4 answers

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

Are there any special steps necessary to prevent data corruption when restarting a server hosting an MS SQL Server instance? For example, I recently encountered the recommendation of stopping the SQL service manually. My understanding is that this…
Jon of All Trades
  • 5,987
  • 7
  • 48
  • 63
9
votes
3 answers

How to quickly startup/shutdown Oracle 11?

I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine). I need it for C/C++ programs that use the OCI/Pro*C API. I want this because I am used to the startup speed of…
maxschlepzig
  • 563
  • 4
  • 6
  • 16
9
votes
4 answers

What reasons are there to stop the SQL Server?

All I've read about is how potentially damaging it is to stop SQL Server because it creates a cold cache and sucks up memory. So why would someone want to stop the SQL Server? If you can provide any links to articles so that I can read more into…
Amerilys
  • 193
  • 1
  • 4
8
votes
1 answer

Start/Stop MySQL

I'm seeking help to understand what happens when the following command line is executed: root@prodn$ service mysqld stop Yes, it shuts down the MySQL server so access to it is no longer available until the service is started again. However, more…
dat789
  • 183
  • 5
5
votes
5 answers

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

One of my databases has been shutting down abnormally, but the log said "normal": 130422 13:23:01 [Note] /usr/libexec/mysqld: Normal shutdown 130422 13:23:01 [Note] Event Scheduler: Killing the scheduler thread, thread id 379021 130422 13:23:01…
quanta
  • 1,006
  • 9
  • 22
  • 36
5
votes
2 answers

Error: MySQL shutdown unexpectedly

Here is the screenshot of my XAMPP Control panel: Here is my Error Log : 2019-11-27 7:54:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-11-27 7:54:14 0 [Note] InnoDB: Uses event mutexes 2019-11-27 7:54:14 0…
md maruf
  • 51
  • 1
  • 1
  • 2
5
votes
1 answer

DB Restart Taking too long, site is down

I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing. What can I do? I can still access the server via SSH but I cannot connect to MySQL. This is urgent as my online store is now…
Hector
  • 155
  • 1
  • 1
  • 4
4
votes
1 answer

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

I had memory issues with using 32bit Xampp so I have installed 64bit components myself as a new server. Although, I want to make sure I am stopping the MySQL database server properly. Is this a sufficient way to shut it down so that frequently…
Gary Carlyle Cook
  • 143
  • 4
3
votes
1 answer

How to shutdown postgres through psql?

The recommended way to shutdown postgres is to send a signal representing the different shutdown modes (fast, smart, immediate) or using init managers (initd, systemd, etc.) or their equivalent on non-Linux OS. In a containerized environment it's…
Kalle Richter
  • 128
  • 1
  • 5
3
votes
1 answer

How to properly stop MySQL server on Mac OS X?

I installed MySQL Community Server following instructions at http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html with the Startup Item and the MySQL Preference Pane. I can stop the server with $ /usr/local/mysql/bin/mysqladmin -u root…
qazwsx
  • 3,507
  • 9
  • 23
  • 21
3
votes
1 answer

How to unmount oracle database?

According to the oracle docs, during shutdown, 3 steps are performed: Close the database. Unmount the database. Shut down the instance. Is it possible to make only first 2 steps?
user3565261
3
votes
1 answer

Oracle crashing on CentOS

Here is alert_XE.log: kkjcre1p: unable to spawn jobq slave process Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc: Process J000 died, see its trace file kkjcre1p: unable to spawn jobq slave process Errors in file…
Ghayel
  • 158
  • 1
  • 5
3
votes
1 answer

Unable to shut down MySQL server

I have tried using the system preferences and then shutting down MySQL there, but to no avail. I also tried typing killall -9 and -11. Both failed :(. I also tried /usr/local/mysql/bin/mysqladmin -u root -p shutdown. The last thing I tried is in the…
user26658
  • 45
  • 1
  • 4
2
votes
1 answer

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database start-up it just stays blank and writing no error…
smn_onrocks
  • 119
  • 3
1
2 3 4