The database is a data persistence system. All data persistence is inseparable from the disk. The disk performance is critical
Take the typical MySQL architecture as an example:
- Connectors: Various languages encapsulate the method of connecting to MySQL database
- Server layer: including connector, query cache, analyzer, optimizer, etc., covering the core functions of MySQL
- Storage Engines layer: responsible for data storage and extraction, and dealing with underlying physical files. The most commonly used storage engine is Innodb
- Files&Logs layer: stores the real table data and logs of the database
- Data persistence to disk