You are upgrading a MySQL instance to the latest 8.0 version. Examine this output: You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?
A.
It defines all innodb tablespace options relative to a starting parent directory.
B.
It is not necessary because innodb_data_home_dir is already defined.
C.
It allows scanning of other locations to discover more innodb tablespaces.
D.
It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
E.
It adds more temporary workspace in addition to the innodb_tmpdir location.
The correct statement is:
C. It allows scanning of other locations to discover more innodb tablespaces.
The innodb_directories option in MySQL 8.0 allows the server to scan additional directories to discover more InnoDB tablespaces. This is particularly useful when you have tablespaces located outside the main data directory. So, by adding ‘/innodb_extras’ to innodb_directories, MySQL will be able to discover any tablespaces located in this directory.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dudeDaG
7 months, 2 weeks agoxexeu
7 months, 4 weeks agoFelipeK
9 months, 2 weeks agoFelipeK
2 months, 2 weeks ago