MySQL storage engines, InnoDB, character sets, replication, query cache history, EXPLAIN and common admin commands.
35 cards · basic cards · AI-written, checked twice. Edit anything.
- What is MySQL's default storage engine starting from version 5.5?
Show answer
InnoDB- Which storage engine provides ACID compliance and crash recovery?
Show answer
InnoDB- MyISAM uses what type of locking mechanism?
Show answer
Table-level locking- Which common storage engine does not support transactions?
Show answer
MyISAM- What storage engine is optimized for read-heavy workloads?
Show answer
MyISAM- What type of locking does InnoDB use by default?
Show answer
Row-level locking- What is the InnoDB buffer pool?
Show answer
An in-memory cache that stores table and index data to speed up reads- List the four ACID properties in database transactions.
Show answer
Atomicity, Consistency, Isolation, Durability- What is InnoDB's default row format as of MySQL 5.7?
Show answer
DYNAMIC- Does InnoDB support foreign key constraints?
Show answer
Yes, with full referential integrity enforcement- How does InnoDB recover from crashes?
Show answer
Using the redo log and undo log to replay or rollback transactions- What file extension does InnoDB use for its tablespace data files?
Show answer
.ibd (InnoDB data)- What is the difference between a character set and a collation?
Show answer
Character set maps characters to numbers; collation defines sort and comparison rules- What does MySQL's utf8 actually support?
Show answer
Only 3 bytes per character, not full UTF-8- What character set should be used for true UTF-8 including 4-byte characters?
Show answer
utf8mb4
FlashKeepers