In addition to MySQL’s various storage engines, the MySQL database server contains a number of core features that enable data warehousing. These include:
Data/Index partitioning (range, hash, key, list, composite) in MySQL 5.1 and above
No practical storage limits (1 tablespace=110TB) with automatic storage management
Built-in Replication
Strong indexing support (B-tree, fulltext, clustered, hash, GIS)
Multiple, configurable data/index caches
Pre-loading of data into caches
Unique query cache (caches result set + query; not just data)
Parallel data load
Multi-insert DML
Read-only tables
Cost-based optimizer
Wide platform support
