1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ91

Installation and Configuration

You are using an existing server with a new configuration, and MySQL Server does not start.

Review this error-log snapshot:

Question Image

Which action would enable the server to start?

  • A Remove ib_logfile0 and ib_logfile1 files from the file system.
  • B Execute mysqladmin flush-logs.
  • C First run mysqld --initialize to refresh the Size of ib_logfile.
  • D Create a new ib_logfile0 file of size 26214400.
Explanation

ib_logfile0 is an InnoDB redo log file. Its on-disk size is 5,242,880 bytes, but the configured redo-log size is 26,214,400 bytes, so InnoDB rejects the incompatible file during startup. Removing both existing redo log files lets InnoDB create a matching redo-log set when the server starts. Prior to MySQL 8.0.30, these redo logs are typically named ib_logfile0 and ib_logfile1.

Learn more

Community Discussion

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