QuestionQ10

Installation and Configuration

You are upgrading a MySQL instance to the most recent 8.0 release.

Review this output:

Question Image

You intend to add this parameter to the configuration:

innodb_directories=’/innodb_extras’

Which statement is correct?

  • 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.
Explanation

innodb_directories defines directories that InnoDB scans at startup to discover tablespace files. Adding /innodb_extras makes that additional location available for discovery of InnoDB tablespaces; it does not move tablespaces or change the data-home or temporary-directory settings.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!