XK0-005 · Question #822
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…
The correct answer is C. Issue the dd if=/dev/zero of=/swapfile bs=1024 count=65536 command. D. Issue the mkswap /dev/sda2; swapon -v /dev/sda2 command. 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…
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.
How the community answered
(34 responses)- A3% (1)
- B6% (2)
- C79% (27)
- E3% (1)
- F9% (3)
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.
Topics
Community Discussion
No community discussion yet for this question.