Consider this shell output and executed commands: [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 about 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.
The correct answer is Ckill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
It sends a SIGTERM signal to the MySQL server to perform a graceful shutdown.
This means that the server will complete any ongoing transactions, flush caches, and close connections before shutting down.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
marklv
3 months, 2 weeks agoFelipeK
6 months, 1 week ago