Understanding MySQL 8 Directory Structure and Table Storage

This guide explains MySQL 8's main directory layout, the locations of command binaries and configuration files, how databases and system schemas are represented on the file system, and the differences between InnoDB and MyISAM storage engines, including tablespace and file naming conventions.

Database FilesDirectory StructureInnoDB

0 likes · 13 min read

Understanding MySQL 8 Directory Structure and Table Storage

ITPUB

Jun 22, 2016 · Databases

Understanding MySQL Architecture: Files, Logs, and Configuration Explained

This article provides a comprehensive overview of MySQL's architecture, detailing its database and instance components, various file types, configuration parameters, and the roles of different log files such as error, slow query, binary, and redo logs.

ConfigurationDatabase Fileslogs

0 likes · 15 min read

Understanding MySQL Architecture: Files, Logs, and Configuration Explained

Java High-Performance Architecture

Aug 28, 2015 · Databases

Understanding MySQL Physical Files: System, Log, Replication, and Data Files Explained

This article outlines the four main types of MySQL physical files—system, log, replication, and data files—detailing their purposes and showing visual examples to help database administrators manage storage effectively and ensure optimal performance.

Database FilesLog FilesReplication

0 likes · 1 min read

Understanding MySQL Physical Files: System, Log, Replication, and Data Files Explained