← thecodex.expert · The Codex Family of Knowledge
Databases

MySQL

The classic web database — powers a huge share of the internet. Fast, familiar, well-supported.

Full guide coming soon. A complete spoonfed walkthrough of MySQL — what it is, when to use it, how to set it up, and how it connects to your code — is being written. For now, here is the short version.

What is MySQL?

The classic web database — powers a huge share of the internet. Fast, familiar, well-supported.

MySQL Reference Topics 12 planned

These are the topics planned for this reference. They are not written yet — the list is published so you can see what is coming. Everything already complete on this site is linked from the Languages section.

What is MySQL Coming soon

Origin at MySQL AB (1995), Sun/Oracle acquisition, and MariaDB's fork.

Guide in progress
Installing MySQL Coming soon

Package managers, Docker, and MySQL Community vs. Enterprise editions.

Guide in progress
Data Types in MySQL Coming soon

Numeric, string, and date types, plus MySQL-specific quirks.

Guide in progress
Storage Engines: InnoDB vs. MyISAM Coming soon

Why the pluggable storage-engine architecture matters.

Guide in progress
Indexes in MySQL Coming soon

B-tree indexes, and how InnoDB clusters data around the primary key.

Guide in progress
Querying with SQL Coming soon

MySQL's SQL dialect and where it diverges from the standard.

Guide in progress
Joins and Relations Coming soon

Foreign keys and referential integrity under InnoDB.

Guide in progress
Transactions and ACID Coming soon

InnoDB's transaction support and isolation levels.

Guide in progress
Replication in MySQL Coming soon

Binary-log-based replication for read scaling and high availability.

Guide in progress
Performance Tuning Coming soon

EXPLAIN, the query cache's removal, and InnoDB buffer pool sizing.

Guide in progress
Backup and Restore Coming soon

mysqldump vs. physical backup tools like Percona XtraBackup.

Guide in progress
Connecting from Application Code Coming soon

Drivers and ORMs across common languages.

Guide in progress