Rechercher dans le manuel MySQL

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 Verifying that InnoDB is the Default Storage Engine
15.1.4 Testing and Benchmarking with InnoDB

15.2 InnoDB and the ACID Model

15.3 InnoDB Multi-Versioning

15.4 InnoDB Architecture

15.5 InnoDB In-Memory Structures [+/-]

15.5.1 Buffer Pool
15.5.2 Change Buffer
15.5.3 Adaptive Hash Index
15.5.4 Log Buffer

15.6 InnoDB On-Disk Structures [+/-]

15.6.1 Tables
15.6.2 Indexes
15.6.3 Tablespaces
15.6.4 Doublewrite Buffer
15.6.5 Redo Log
15.6.6 Undo Logs

15.7 InnoDB Locking and Transaction Model [+/-]

15.7.1 InnoDB Locking
15.7.2 InnoDB Transaction Model
15.7.3 Locks Set by Different SQL Statements in InnoDB
15.7.4 Phantom Rows
15.7.5 Deadlocks in InnoDB

15.8 InnoDB Configuration [+/-]

15.8.1 InnoDB Startup Configuration
15.8.2 Configuring InnoDB for Read-Only Operation
15.8.3 InnoDB Buffer Pool Configuration
15.8.4 Configuring Thread Concurrency for InnoDB
15.8.5 Configuring the Number of Background InnoDB I/O Threads
15.8.6 Using Asynchronous I/O on Linux
15.8.7 Configuring the InnoDB Master Thread I/O Rate
15.8.8 Configuring Spin Lock Polling
15.8.9 Configuring InnoDB Purge Scheduling
15.8.10 Configuring Optimizer Statistics for InnoDB
15.8.11 Configuring the Merge Threshold for Index Pages
15.8.12 Enabling Automatic Configuration for a Dedicated MySQL Server

15.9 InnoDB Table and Page Compression [+/-]

15.9.1 InnoDB Table Compression
15.9.2 InnoDB Page Compression

15.10 InnoDB Row Formats

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

15.11.1 InnoDB Disk I/O
15.11.2 File Space Management
15.11.3 InnoDB Checkpoints
15.11.4 Defragmenting a Table
15.11.5 Reclaiming Disk Space with TRUNCATE TABLE

15.12 InnoDB and Online DDL [+/-]

15.12.1 Online DDL Operations
15.12.2 Online DDL Performance and Concurrency
15.12.3 Online DDL Space Requirements
15.12.4 Simplifying DDL Statements with Online DDL
15.12.5 Online DDL Failure Conditions
15.12.6 Online DDL Limitations

15.13 InnoDB Startup Options and System Variables

15.14 InnoDB INFORMATION_SCHEMA Tables [+/-]

15.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression
15.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
15.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
15.14.6 InnoDB INFORMATION_SCHEMA Metrics Table
15.14.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
15.14.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES

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

15.15.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
15.15.2 Monitoring InnoDB Mutex Waits Using Performance Schema

15.16 InnoDB Monitors [+/-]

15.16.1 InnoDB Monitor Types
15.16.2 Enabling InnoDB Monitors
15.16.3 InnoDB Standard Monitor and Lock Monitor Output

15.17 InnoDB Backup and Recovery [+/-]

15.17.1 InnoDB Backup
15.17.2 InnoDB Recovery

15.18 InnoDB and MySQL Replication

15.19 InnoDB memcached Plugin [+/-]

15.19.1 Benefits of the InnoDB memcached Plugin
15.19.2 InnoDB memcached Architecture
15.19.3 Setting Up the InnoDB memcached Plugin
15.19.4 InnoDB memcached Multiple get and Range Query Support
15.19.5 Security Considerations for the InnoDB memcached Plugin
15.19.6 Writing Applications for the InnoDB memcached Plugin
15.19.7 The InnoDB memcached Plugin and Replication
15.19.8 InnoDB memcached Plugin Internals
15.19.9 Troubleshooting the InnoDB memcached Plugin

15.20 InnoDB Troubleshooting [+/-]

15.20.1 Troubleshooting InnoDB I/O Problems
15.20.2 Forcing InnoDB Recovery
15.20.3 Troubleshooting InnoDB Data Dictionary Operations
15.20.4 InnoDB Error Handling

Find a PHP function

Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-innodb-storage-engine.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

Manuel MySQL : https://dev.mysql.com/

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.