Examice

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

Go to Exam

Question 137

You are using an existing server with a new configuration. MySQL Server fails to start.

Examine this snapshot of the error log:

Which action would allow the server to start?

Remove ib_logfile0 and ib_logfile1 files from the file system.

Execute mysqladmin flush-logs.

First run mysqld --initialize to refresh the Size of ib_logfile.

Create a new ib_logfile0 file of size 26214400.

Correct Answer: A

The error log indicates that the MySQL server cannot start because the size of the log file 'ib_logfile0' does not match the size specified in the configuration file. Removing the 'ib_logfile0' and 'ib_logfile1' files will allow MySQL to recreate them with the correct size from the configuration file upon the next startup, solving the issue.

Discussion

marklvOption: A

A, those files will get recreated to the right size on start.

marklv

ib_logfile1 doesn't exist,. so not A. Not C, you do not need to wipe data. The log file needs to be fixed. So D, set it to what error message says.

DhanushkaOption: A

C will wipe existing data