1Z0-873 · Question #117
Which of the following statements are true for InnoDB?
The correct answer is A. InnoDB is enabled by default. D. Tablespace and log files will be created even if not configured explicitly. For example, the InnoDB storage engine is included in all binary distributions. If you build MySQL from source, InnoDB is included by default unless you specify the --without-innodb configuration option. For a server that has the InnoDB storage engine included, support may be…
Question
Which of the following statements are true for InnoDB?
Options
- AInnoDB is enabled by default.
- BTablespace and log files have to be configured explicitly to be created.
- CInnoDB is not enabled by default.
- DTablespace and log files will be created even if not configured explicitly.
How the community answered
(18 responses)- A83% (15)
- B11% (2)
- C6% (1)
Explanation
For example, the InnoDB storage engine is included in all binary distributions. If you build MySQL from source, InnoDB is included by default unless you specify the --without-innodb configuration option. For a server that has the InnoDB storage engine included, support may be disabled at startup with the --skip-innodb option. A server that has InnoDB enabled uses a default configuration for its tablespace and log files unless you provide configuration options. If you don't specify any tablespace configuration options at all, InnoDB creates a shared tablespace consisting of a single 10MB auto-extending regular file named ibdata1 in the data
Topics
Community Discussion
No community discussion yet for this question.