1.2.1  MySQL architecture

MySQL is a client server architecture based on TCP/IP. The MySQL server, 

which can be installed on a Windows, UNIX, Linux, or Mac platform, waits for 

connection on a specified port and responds to SQL statements from a client. 

The conceptual architecture of the MySQL database is illustrated in Figure 1 12. 

In the next pages the functionality of the integrated components is discussed in 

more detail.

Applications and Interfaces

nt

lie C

Administrative  

e

Application 

s

Interface and 

Query Interface

Interface and 

ba

Utilities

Utilities

taaD

Embedded 

DDL 

DML 

Query 

Preprocessor

Compiler

Precompiler

Execution 

Engine

Query Processing

Transaction Management

Recovery Management

errve

Concurrency   

Co

C n

oncur

curre

renc

ncy  

y    

T

T

r

r

ansa

ans

cti

ac

o

ti

n 

on 

Recovery 

Control 

se S

Co

C nt

o ro

nt l

ro  M

l Man

a age

n

r

ager

M

M

anager

anager

Log Manager

Manager

a

Manager

ba

Dat

Storage Management

Storage Manager

Memory Manager

Resource Manager

r

rceu

Main and 

so

Physical Disk / 

 re

Virtual Memory 

Secondary 

(includes all  buffer)

icals

Storage

yhP

Figure 1 12   Conceptual MySQL architecture

 Chapter 1. Introduction 

29