1z0-888 Exam Dumps : MySQL 5.7 Database Administrator

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance