nerdexam
Oracle

1Z0-873 · Question #109

Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?

The correct answer is A. They are highly optimized. C. Many are built using commercial compilers that produce a better quality build than with freely E. They may include libraries not available in the standard operating system library. One significant benefit is that binaries produced by MySQL are likely to provide better performance than those you build yourself: MySQL AB has a great deal of experience selecting configuration options such as compiler switches that produce the most highly optimized binaries…

MySQL Installation and Configuration

Question

Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?

Options

  • AThey are highly optimized.
  • BThey are cross-platform.
  • CMany are built using commercial compilers that produce a better quality build than with freely
  • DThey will work with tools such as MySQL Administrator and MySQL Query Browser.
  • EThey may include libraries not available in the standard operating system library.

How the community answered

(42 responses)
  • A
    86% (36)
  • B
    10% (4)
  • D
    5% (2)

Explanation

One significant benefit is that binaries produced by MySQL are likely to provide better performance than those you build yourself: MySQL AB has a great deal of experience selecting configuration options such as compiler switches that produce the most highly optimized binaries. In many cases, MySQL AB uses commercial compilers that produce superior quality code compared to the compilers typically available for general-purpose use. In some cases, MySQL AB produces binaries compiled with libraries that provide capabilities beyond those available in the standard operating system vendor libraries. For example, on Linux systems, a special C library is used that allows a higher maximum number of concurrent connections than can be achieved using the stock C library. Other times, binaries are built using special libraries that work around known bugs in vendor

Topics

#MySQL binaries#compiler optimization#platform libraries#pre-built distributions

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice