Pass 1z0-888 Exam Guide

The MySQL server has stopped inserting data to check index consistency.

InnoDB is doing CRC32 checks over the tablespace data as it grows.

The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.

InnoDB has filled the redo log and now must flush the pages.

Secondary indexes no longer fit into the buffer pool.

monitoring the Innodb_rows_inserted status variable

monitoring the innodb_redo_log_size variable

monitoring the information_schema.TABLES table

monitoring datadir size in the operating system

monitoring cumulative Innodb_page_size increase

monitoring the performance_schema_hosts_size variable

Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.

Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

Start the MySQL Server with –initialize-insecure to force a password reset procedure on the command line.