Scribd
Upload
69 views25 pages

VTC MySQL Architechture

This document discusses the architecture of MySQL server and client/server communication. It covers how the MySQL server resides on a local host, the core subsystems that make up the MySQL server architecture including query parsing, caching, and optimization. It also mentions storage engines, plugins, and hardware/OS considerations.

Uploaded by

Stephen Efange
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
69 views25 pages

VTC MySQL Architechture

This document discusses the architecture of MySQL server and client/server communication. It covers how the MySQL server resides on a local host, the core subsystems that make up the MySQL server architecture including query parsing, caching, and optimization. It also mentions storage engines, plugins, and hardware/OS considerations.

Uploaded by

Stephen Efange
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 25

CLINENT/SERVER ARCHITECTURE

COMMUNICATION PROTOCOLS
 MySQL Server Reside on Specific server call Localhost
MYSQL SERVER ARCHITECTURE
CONTINUE …
MYSQL SERVER / DAEMON
CLIENT LIBRARIES
CONTINUE..
CONTINUE…
CONTINUE…
CORE SUBSYSTEMS
ANOTHER CORE SUBSYSTEMS INCLUDE
PERFORMANCE CACHES
CONTINUE…
CONTINUE…
QUERY PARSING
QUERY CACHE
CONTINUE…
QUERY OPTIMIZER
HOW THE OPTIMIZER WORKS
MYSQL PLUG-IN INTERFACE
STORAGE ENGINES
CONTINUE…
INFORMATION SCHEMA
HARDWARE AND OS ISSUES
CONTINUE…

You might also like