1Z0-873 · Question #126
Assume you compile MySQL from source and invoke configure with the following options. --with-charset=latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installation that contains…
The correct answer is A. The compiled version will use less disk space, because only a few character sets will be installed B. The compiled version will use less memory, because only a few character sets will be loaded by. To reduce the amount of disk space required by character sets for your MySQL installation and the amount of memory used by the server as it runs, don't select unneeded character sets when you configure MySQL. This requires that you compile MySQL from source rather than using a…
Question
Assume you compile MySQL from source and invoke configure with the following options. --with-charset=latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installation that contains many more character sets, which of the following statements is/are true?
Options
- AThe compiled version will use less disk space, because only a few character sets will be installed
- BThe compiled version will use less memory, because only a few character sets will be loaded by
- CThe compiled version will use less file handles, because only a few files need to be opened when
How the community answered
(25 responses)- A80% (20)
- C20% (5)
Explanation
To reduce the amount of disk space required by character sets for your MySQL installation and the amount of memory used by the server as it runs, don't select unneeded character sets when you configure MySQL. This requires that you compile MySQL from source rather than using a precompiled binary distribution.
Topics
Community Discussion
No community discussion yet for this question.