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…

Question

Exhibit

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.

• A
  3% (1)
• B
  3% (1)
• C
  79% (30)
• E
  11% (4)
• F
  5% (2)

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.