XK0-005 Question #1817: Real Exam Question with Answer & Explanation

Question

Users connecting to a MySQL database on a Linux system report frequent errors. An administrator reviews the following partial output of the /proc/meminfo and free commands: Which of the following should the administrator do to ensure that the MySQL service will continue to run even if the system runs out of swap space? (Choose two.)

Options

• AIssue the sysctl -w vm.overcommit_ratio=100 command.
• BIssue the sysctl -w vm.overconunit_memory=2 command.(Invalid key)
• CIssue the dd if=/dev/zero of=/swapfile bs=1024 count=65536 command.
• DIssue the mkswap /dev/sda2; swapon -v /dev/sda2 command.
• EReload the /etc/fstab file by issuing the mount -a command.(Not sufficient alone)
• FUse disk quotas on the swap space to prevent MySQL from overutilizing the swap partition.

Explanation

Creating a swap file with dd if=/dev/zero of=/swapfile bs=1024 count=65536 allocates additional swap space that MySQL can use when RAM is exhausted. Formatting and enabling a swap partition with mkswap /dev/sda2; swapon -v /dev/sda2 brings another swap device online, further increasing the system’s swap capacity.

No community discussion yet for this question.