MySQL Architecture

Use MySQL client programs to interface with the MySQL Server interactively and in batch

• MySQL Client Programs
• MySQL Command Options
• EXAM CRAM: MYSQL ARCHITECTURE FOR DEVELOPERS (SECTION 1)

Describe how MySQL uses disk and memory resources

• How MySQL Uses Memory
• MySQL server memory usage troubleshooting tips

List and describe key characteristics of standard MySQL storage engines including InnoDB, NDB, MyISAM, MEMORY, FEDERATED

• Storage Engines
• Comparison of MySQL database engines