Oracle Exam 1Z0-320 Topic 1 Question 5 Discussion

Actual exam question for Oracle's 1Z0-320 exam

Question #: 5
Topic #: 1

Your customer has provided you with the following server specifications: 64-bit, Oracle Linux 6, 24 Numa CPU cores, 48 GB memory, and sequential write-optimized drives in the /var/lib/seq-write directory. The customer wants you to optimize their MySQL 5.7.10 installation for the server resources available.

Identify three correct configurations for this server setup.

Amysql_numa_interleave=ON,innodb_buffer_pool_instances=8, innodb_log_file_size=24G

Binnodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8

Cinnodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1

Dplugin_load= ''thread_pool.so'', innodb_page_cleaners=12, innodb_log_group_home_dir=/var/lib/seq-write

Einnodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G

Finnodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G

Show Suggested Answer

Suggested Answer: A, B, E

by Yoko at Dec 25, 2022, 04:04 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-320 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!