Contact MySQL |
Login | Register

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 5.7

8.0
5.6
5.5

5.6 Japanese

MySQL 5.7 Reference Manual / The InnoDB Storage Engine

Chapter 15 The InnoDB Storage Engine

Table of Contents [+/-]

15.1 Introduction to InnoDB [+/-]

15.1.1 Benefits of Using InnoDB Tables
15.1.2 Best Practices for InnoDB Tables
15.1.3 Checking InnoDB Availability
15.1.4 Testing and Benchmarking with InnoDB
15.1.5 Turning Off InnoDB

15.2 InnoDB and the ACID Model

15.3 InnoDB Multi-Versioning

15.4 InnoDB Architecture [+/-]

15.4.1 Buffer Pool
15.4.2 Change Buffer
15.4.3 Adaptive Hash Index
15.4.4 Redo Log Buffer
15.4.5 System Tablespace
15.4.6 InnoDB Data Dictionary
15.4.7 Doublewrite Buffer
15.4.8 Undo Log
15.4.9 File-Per-Table Tablespaces
15.4.10 General Tablespaces
15.4.11 Undo Tablespace
15.4.12 Temporary Tablespace
15.4.13 Redo Log

15.5 InnoDB Locking and Transaction Model [+/-]

15.5.1 InnoDB Locking
15.5.2 InnoDB Transaction Model
15.5.3 Locks Set by Different SQL Statements in InnoDB
15.5.4 Phantom Rows
15.5.5 Deadlocks in InnoDB

15.6 InnoDB Configuration [+/-]

15.6.1 InnoDB Startup Configuration
15.6.2 Configuring InnoDB for Read-Only Operation
15.6.3 InnoDB Buffer Pool Configuration
15.6.4 Configuring the Memory Allocator for InnoDB
15.6.5 Configuring InnoDB Change Buffering
15.6.6 Configuring Thread Concurrency for InnoDB
15.6.7 Configuring the Number of Background InnoDB I/O Threads
15.6.8 Configuring the InnoDB Master Thread I/O Rate
15.6.9 Configuring Spin Lock Polling
15.6.10 Configuring InnoDB Purge Scheduling
15.6.11 Configuring Optimizer Statistics for InnoDB
15.6.12 Configuring the Merge Threshold for Index Pages

15.7 InnoDB Tablespaces [+/-]

15.7.1 Resizing the InnoDB System Tablespace
15.7.2 Changing the Number or Size of InnoDB Redo Log Files
15.7.3 Using Raw Disk Partitions for the System Tablespace
15.7.4 InnoDB File-Per-Table Tablespaces
15.7.5 Creating a File-Per-Table Tablespace Outside the Data Directory
15.7.6 Copying File-Per-Table Tablespaces to Another Server
15.7.7 Storing InnoDB Undo Logs in Separate Tablespaces
15.7.8 Truncating Undo Logs That Reside in Undo Tablespaces
15.7.9 InnoDB General Tablespaces
15.7.10 InnoDB Tablespace Encryption

15.8 InnoDB Tables and Indexes [+/-]

15.8.1 Creating InnoDB Tables
15.8.2 Role of the .frm File for InnoDB Tables
15.8.3 Physical Row Structure of InnoDB Tables
15.8.4 Moving or Copying InnoDB Tables to Another Machine
15.8.5 Converting Tables from MyISAM to InnoDB
15.8.6 AUTO_INCREMENT Handling in InnoDB
15.8.7 InnoDB and FOREIGN KEY Constraints
15.8.8 Limits on InnoDB Tables
15.8.9 Clustered and Secondary Indexes
15.8.10 InnoDB FULLTEXT Indexes
15.8.11 Physical Structure of an InnoDB Index
15.8.12 Sorted Index Builds

15.9 InnoDB Table and Page Compression [+/-]

15.9.1 InnoDB Table Compression
15.9.2 InnoDB Page Compression

15.10 InnoDB File-Format Management [+/-]

15.10.1 Enabling File Formats
15.10.2 Verifying File Format Compatibility
15.10.3 Identifying the File Format in Use
15.10.4 Modifying the File Format

15.11 InnoDB Row Storage and Row Formats [+/-]

15.11.1 Overview of InnoDB Row Storage
15.11.2 Specifying the Row Format for a Table
15.11.3 DYNAMIC and COMPRESSED Row Formats
15.11.4 COMPACT and REDUNDANT Row Formats

15.12 InnoDB Disk I/O and File Space Management [+/-]

15.12.1 InnoDB Disk I/O
15.12.2 File Space Management
15.12.3 InnoDB Checkpoints
15.12.4 Defragmenting a Table
15.12.5 Reclaiming Disk Space with TRUNCATE TABLE

15.13 InnoDB and Online DDL [+/-]

15.13.1 Overview of Online DDL
15.13.2 Performance and Concurrency Considerations for Online DDL
15.13.3 SQL Syntax for Online DDL
15.13.4 Combining or Separating DDL Statements
15.13.5 Examples of Online DDL
15.13.6 Implementation Details of Online DDL
15.13.7 How Crash Recovery Works with Online DDL
15.13.8 Online DDL for Partitioned InnoDB Tables
15.13.9 Limitations of Online DDL

15.14 InnoDB Startup Options and System Variables

15.15 InnoDB INFORMATION_SCHEMA Tables [+/-]

15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
15.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Tables
15.15.3 InnoDB INFORMATION_SCHEMA System Tables
15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
15.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
15.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
15.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Information Table
15.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES

15.16 InnoDB Integration with MySQL Performance Schema [+/-]

15.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
15.16.2 Monitoring InnoDB Mutex Waits Using Performance Schema

15.17 InnoDB Monitors [+/-]

15.17.1 InnoDB Monitor Types
15.17.2 Enabling InnoDB Monitors
15.17.3 InnoDB Standard Monitor and Lock Monitor Output
15.17.4 InnoDB Tablespace Monitor Output
15.17.5 InnoDB Table Monitor Output

15.18 InnoDB Backup and Recovery [+/-]

15.18.1 The InnoDB Recovery Process
15.18.2 Tablespace Discovery During Crash Recovery

15.19 InnoDB and MySQL Replication

15.20 InnoDB memcached Plugin [+/-]

15.20.1 Benefits of the InnoDB memcached Plugin
15.20.2 InnoDB memcached Architecture
15.20.3 Setting Up the InnoDB memcached Plugin
15.20.4 Security Considerations for the InnoDB memcached Plugin
15.20.5 Writing Applications for the InnoDB memcached Plugin
15.20.6 The InnoDB memcached Plugin and Replication
15.20.7 InnoDB memcached Plugin Internals
15.20.8 Troubleshooting the InnoDB memcached Plugin

15.21 InnoDB Troubleshooting [+/-]

15.21.1 Troubleshooting InnoDB I/O Problems
15.21.2 Forcing InnoDB Recovery
15.21.3 Troubleshooting InnoDB Data Dictionary Operations
15.21.4 InnoDB Error Handling

PREV HOME UP NEXT

User Comments

Sign Up Login You must be logged in to post a comment.