MySQL :: MySQL 8.0 Reference Manual :: 15.9.1 InnoDB Table Compression

MySQL 8.0 Reference Manual

Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statement Syntax
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 8.0
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 8.0 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary

15.9.1 InnoDB Table Compression

15.9.1.1 Overview of Table Compression
15.9.1.2 Creating Compressed Tables
15.9.1.3 Tuning Compression for InnoDB Tables
15.9.1.4 Monitoring InnoDB Table Compression at Runtime
15.9.1.5 How Compression Works for InnoDB Tables
15.9.1.6 Compression for OLTP Workloads
15.9.1.7 SQL Compression Syntax Warnings and Errors

This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general tablespaces. Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ALTER TABLE.

PREV HOME UP NEXT