The my.cnf file contains the following entries: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:50M;/disk2/ibdata2:50M:autoextend Which of the following statements are true?

The correct answer is B. There are two InnoDB data files D. The total minimum size of the InnoDB data files is 100MB. A tablespace consisting of a single 100MB file named innodata1 located in the data directory: innodb_data_file_path = innodata1:100M It's unnecessary to specify a value for the innodb_data_home_dir option in this case because the data directory is its default value. A…

MySQL Configuration

Question

The my.cnf file contains the following entries:

innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:50M;/disk2/ibdata2:50M:autoextend Which of the following statements are true?

Options

AThe data files will be stored below the default data directory
BThere are two InnoDB data files
CThere are three InnoDB data files
DThe total minimum size of the InnoDB data files is 100MB
EThe total maximum size of the InnoDB data files is 100MB
FThe initial size of the InnoDB data files on server startup will be set to 50MB. If more space is

How the community answered

(41 responses)

A
2% (1)
B
73% (30)
C
2% (1)
E
7% (3)
F
15% (6)

Explanation

A tablespace consisting of a single 100MB file named innodata1 located in the data directory: innodb_data_file_path = innodata1:100M It's unnecessary to specify a value for the innodb_data_home_dir option in this case because the data directory is its default value. A tablespace like that in the previous example, except that the file is auto-extending: innodb_data_file_path = innodata1:100M:autoextend A tablespace like that in the previous example, but with a limit of 500MB on the size to which the innodb_data_file_path = innodata1:100M:autoextend:max:500M

Topics

#innodb_data_file_path#tablespace configuration#autoextend#my.cnf

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice