Mysql Architecture
Mysql Architecture
Mysql Architecture
Architecture
1
2 December 5, 2019
Introduction
MySQL is an open-source relational database
management system. Its name is a combination of
"My", the name of co-founder Michael Widenius's
daughter, and "SQL", the abbreviation for Structured
Query Language.
Based on client/server architecture
MySQL was originally created to incorporate indexing
data to speed up data queries in the mSQL
database server, by using the indexed sequential
access method (ISAM). It did this by incorporating a
special data management algorithm called the
MyISAM storage engine. This proved to be a huge
success.
3 December 5, 2019
Overview
4 December 5, 2019
MySQL (InnoDB)Architecture
6 December 5, 2019
Tables/Indexes
Tablespaces
InnoDB Data Dictionary
Doublewrite Buffer
It a storage area located in the system
tablespace where InnoDB writes pages that are
flushed from the InnoDB buffer pool, before the
pages are written to their proper positions in the
data file.
Redo Log
Undo Logs
9 December 5, 2019