Oracle Updated 1z0-908 Exam Questions and Answers by coen

The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

The mysqlcheck --optimize --all-databases command reclaims free space from table files.

The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

on slave: --replicate-wild-ignore=example.%

on slave: --replicate-ignore-db=example

on master: --replicate-ignore-db=example

on master: --binlog-ignore-db=example

on slave: --binlog-ignore-db=example

shell> mysqladmin --debug

shell> mysql --print-defaults

shell> mysqld --help --verbose

mysql> SHOW GLOBAL VARIABLES;

DESCRIBE manufacturing.parts;

SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’ AND TABLE_NAME=’parts’;

SHOW INDEXES FROM manufacturing.parts;

SELECT * FROM information_schema.COLUMN_STATISTICS;

EXPLAIN SELECT INDEXES FROM manufacturing.parts;