Contact MySQL
|
Login
|
Register
The world's most popular open source database
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 5.5 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
The InnoDB Storage Engine
Introduction to InnoDB
Benefits of Using InnoDB Tables
Best Practices for InnoDB Tables
Checking InnoDB Availability
Upward and Downward Compatibility
Testing and Benchmarking with InnoDB
Turning Off InnoDB
Third-Party Software Contributions
Performance Patches from Google
Multiple Background I/O Threads Patch from Percona
Performance Patches from Sun Microsystems
Installing the InnoDB Storage Engine
Upgrading the InnoDB Storage Engine
Downgrading the InnoDB Storage Engine
InnoDB and the ACID Model
InnoDB Multi-Versioning
InnoDB Architecture
Buffer Pool
Change Buffer
Adaptive Hash Index
Redo Log Buffer
System Tablespace
InnoDB Data Dictionary
Doublewrite Buffer
Undo Logs
File-Per-Table Tablespaces
Redo Log
Group Commit for Redo Log Flushing
InnoDB Locking and Transaction Model
InnoDB Locking
InnoDB Transaction Model
Transaction Isolation Levels
autocommit, Commit, and Rollback
Consistent Nonlocking Reads
Locking Reads
Locks Set by Different SQL Statements in InnoDB
Phantom Rows
Deadlocks in InnoDB
An InnoDB Deadlock Example
Deadlock Detection and Rollback
How to Minimize and Handle Deadlocks
InnoDB Configuration
InnoDB Startup Configuration
InnoDB Buffer Pool Configuration
The InnoDB Buffer Pool
Configuring Multiple Buffer Pool Instances
Making the Buffer Pool Scan Resistant
Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)
Configuring InnoDB Buffer Pool Flushing
Monitoring the Buffer Pool Using the InnoDB Standard Monitor
Configuring the Memory Allocator for InnoDB
Configuring InnoDB Change Buffering
Configuring Thread Concurrency for InnoDB
Configuring the Number of Background InnoDB I/O Threads
Using Asynchronous I/O on Linux
Configuring the InnoDB Master Thread I/O Rate
Configuring Spin Lock Polling
Configuring InnoDB Purge Scheduling
Configuring Optimizer Statistics for InnoDB
Estimating ANALYZE TABLE Complexity for InnoDB Tables
InnoDB Tablespaces
Resizing the InnoDB System Tablespace
Changing the Number or Size of InnoDB Redo Log Files
Using Raw Disk Partitions for the System Tablespace
InnoDB File-Per-Table Tablespaces
Enabling and Disabling File-Per-Table Tablespaces
InnoDB Tables and Indexes
InnoDB Tables
Creating InnoDB Tables
The Physical Row Structure of an InnoDB Table
Moving or Copying InnoDB Tables
Converting Tables from MyISAM to InnoDB
AUTO_INCREMENT Handling in InnoDB
InnoDB and FOREIGN KEY Constraints
Limits on InnoDB Tables
InnoDB Indexes
Clustered and Secondary Indexes
The Physical Structure of an InnoDB Index
InnoDB Table Compression
Overview of Table Compression
Enabling Compression for a Table
Tuning Compression for InnoDB Tables
Monitoring InnoDB Table Compression at Runtime
How Compression Works for InnoDB Tables
SQL Compression Syntax Warnings and Errors
InnoDB File-Format Management
Enabling File Formats
Verifying File Format Compatibility
Compatibility Check When InnoDB Is Started
Compatibility Check When a Table Is Opened
Identifying the File Format in Use
Downgrading the File Format
InnoDB Row Storage and Row Formats
Overview of InnoDB Row Storage
Specifying the Row Format for a Table
DYNAMIC and COMPRESSED Row Formats
COMPACT and REDUNDANT Row Formats
InnoDB Disk I/O and File Space Management
InnoDB Disk I/O
File Space Management
InnoDB Checkpoints
Defragmenting a Table
Reclaiming Disk Space with TRUNCATE TABLE
InnoDB Fast Index Creation
Overview of Fast Index Creation
Examples of Fast Index Creation
Implementation Details of Fast Index Creation
Concurrency Considerations for Fast Index Creation
How Crash Recovery Works with Fast Index Creation
Limitations of Fast Index Creation
InnoDB Startup Options and System Variables
InnoDB INFORMATION_SCHEMA Tables
InnoDB INFORMATION_SCHEMA Tables about Compression
INNODB_CMP and INNODB_CMP_RESET
INNODB_CMPMEM and INNODB_CMPMEM_RESET
Using the Compression Information Schema Tables
InnoDB INFORMATION_SCHEMA Transaction and Locking Information
Using InnoDB Transaction and Locking Information
InnoDB Lock and Lock-Wait Information
Persistence and Consistency of InnoDB Transaction and Locking Information
InnoDB INFORMATION_SCHEMA Buffer Pool Tables
InnoDB Integration with MySQL Performance Schema
Monitoring InnoDB Mutex Waits Using Performance Schema
InnoDB Monitors
InnoDB Monitor Types
Enabling InnoDB Monitors
InnoDB Standard Monitor and Lock Monitor Output
InnoDB Tablespace Monitor Output
InnoDB Table Monitor Output
InnoDB Backup and Recovery
InnoDB Backup
InnoDB Recovery
InnoDB and MySQL Replication
InnoDB Troubleshooting
Troubleshooting InnoDB I/O Problems
Forcing InnoDB Recovery
Troubleshooting InnoDB Data Dictionary Operations
InnoDB Error Handling
Alternative Storage Engines
High Availability and Scalability
Replication
MySQL NDB Cluster 7.2
Partitioning
Stored Programs and Views
INFORMATION_SCHEMA Tables
MySQL Performance Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.5 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 5.5 Release Notes
Download this Manual
PDF (US Ltr)
- 26.9Mb
PDF (A4)
- 26.9Mb
PDF (RPM)
- 25.3Mb
HTML Download (TGZ)
- 6.3Mb
HTML Download (Zip)
- 6.3Mb
HTML Download (RPM)
- 5.4Mb
Man Pages (TGZ)
- 158.1Kb
Man Pages (Zip)
- 261.3Kb
Info (Gzip)
- 2.6Mb
Info (Zip)
- 2.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 7.2
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
version 5.5
8.0 current
5.7
5.6
5.6 Japanese
MySQL 5.5 Reference Manual
/
The InnoDB Storage Engine
/ InnoDB Tablespaces
14.10 InnoDB Tablespaces
[
+/-
]
14.10.1 Resizing the InnoDB System Tablespace
14.10.2 Changing the Number or Size of InnoDB Redo Log Files
14.10.3 Using Raw Disk Partitions for the System Tablespace
14.10.4 InnoDB File-Per-Table Tablespaces
This section covers topics related to
InnoDB
tablespaces.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.5 Release Notes
Download this Manual
PDF (US Ltr)
- 26.9Mb
PDF (A4)
- 26.9Mb
PDF (RPM)
- 25.3Mb
HTML Download (TGZ)
- 6.3Mb
HTML Download (Zip)
- 6.3Mb
HTML Download (RPM)
- 5.4Mb
Man Pages (TGZ)
- 158.1Kb
Man Pages (Zip)
- 261.3Kb
Info (Gzip)
- 2.6Mb
Info (Zip)
- 2.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 7.2
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up
Login
You must be logged in to post a comment.