MySQL

Architecture

• Architecture→
• Query Processing→

Transaction & Lock

• Transaction→
• MySQL Engine Lock→
• InnoDB Storage Engine Lock→
• Isolation Level→
• SELECT Lock→

Index

• Index→
• B-Tree Index→
• Clustering Index→
• Unique Index→
• Foreign Key→
• ETC Index→
• Index Merge→
• Index Condition Pushdown→

Optimizer & Execution Plan

• Optimizer→
• Data Processing→
• Statistics→
• Check Execution Plan→
• Analyze Execution Plan→

Query

• Query System Variable→
• Literal Notation→
• Operator→
• Built-in Function→
• SELECT→
• Sub Query→
• INSERT→
• UPDATE / DELETE→
• Performance Test→

Data Type

• CHAR / VARCHAR→
• Number→
• Date Time→
• ENUM→

Operations

• Replication→
• Partitioning→