QuestionQ13

Installation and Configuration

Consider the following shell output and commands that were executed:

[root@oel7 ~]# ps aux | grep mysqld  
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid  
[root@oel7 ~]# kill -15 2076  

Which statement is true regarding MySQL server shutdown?

  • A kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
  • B kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
  • C kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
  • D mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
Explanation

On Unix, signal 15 (SIGTERM) instructs mysqld to perform its normal shutdown process. MySQL documents this as equivalent to executing the SQL SHUTDOWN statement, whose shutdown functionality is also provided by mysqladmin shutdown.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!