Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 24

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?

It defines all innodb tablespace options relative to a starting parent directory.

It is not necessary because innodb_data_home_dir is already defined.

It allows scanning of other locations to discover more innodb tablespaces.

It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

It adds more temporary workspace in addition to the innodb_tmpdir location.

Correct Answer: C

The parameter innodb_directories allows MySQL to scan additional directories to discover more InnoDB tablespaces. By adding '/innodb_extras' to innodb_directories, MySQL includes this directory in its search path for locating tablespaces, which can be especially useful if you have tablespaces stored outside the main data directory.

Discussion

dudeDaGOption: B

Even though the correct answer is "C", so the correct/approved/recommended answer for Exam is B?

xexeuOption: C

Answer C

FelipeKOption: C

https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

FelipeK

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.