D.S

dev.mysql.com

MySQL :: MySQL 5.7 Reference Manual :: 15.6.3.3 Configuring Multiple Buffer Pool Instances

MySQL :: MySQL 5.7 Reference Manual :: 15.6.3.3 Configuring Multiple Buffer Pool Instances 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 Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization 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 Testing and Benchmarking with InnoDB Turning Off InnoDB 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 Log File-Per-Table Tablespaces General Tablespaces Undo Tablespace Temporary Tablespace InnoDB Temporary Table Undo Logs 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 Configuring InnoDB for Read-Only Operation InnoDB Buffer Pool Configuration The InnoDB Buffer Pool Configuring InnoDB Buffer Pool Size Configuring Multiple Buffer Pool Instances Making the Buffer Pool Scan Resistant Configuring InnoDB Buffer Pool Prefetching (Read-Ahead) Configuring InnoDB Buffer Pool Flushing Fine-tuning InnoDB Buffer Pool Flushing Saving and Restoring the Buffer Pool State Monitoring the Buffer Pool Using the InnoDB Standard Monitor Configuring the Memory Allocator for InnoDB Configuring InnoDB Change Buffering Configuring the Change Buffer Maximum Size Configuring Thread Concurrency for InnoDB Configuring the Number of Background InnoDB I/O Threads Configuring the InnoDB Master Thread I/O Rate Configuring Spin Lock Polling Configuring InnoDB Purge Scheduling Configuring Optimizer Statistics for InnoDB Configuring Persistent Optimizer Statistics Parameters Configuring Non-Persistent Optimizer Statistics Parameters Estimating ANALYZE TABLE Complexity for InnoDB Tables Configuring the Merge Threshold for Index Pages 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 Creating a File-Per-Table Tablespace Outside the Data Directory Copying File-Per-Table Tablespaces to Another Server Transportable Tablespace Examples Transportable Tablespace Internals Storing InnoDB Undo Logs in Separate Tablespaces Truncating Undo Logs That Reside in Undo Tablespaces InnoDB General Tablespaces InnoDB Tablespace Encryption InnoDB Tables and Indexes Creating InnoDB Tables Role of the .frm File for InnoDB Tables Physical Row Structure of InnoDB Tables Moving or Copying InnoDB Tables to Another Machine Converting Tables from MyISAM to InnoDB AUTO_INCREMENT Handling in InnoDB InnoDB and FOREIGN KEY Constraints Limits on InnoDB Tables Clustered and Secondary Indexes InnoDB FULLTEXT Indexes Physical Structure of an InnoDB Index Sorted Index Builds InnoDB Table and Page Compression InnoDB Table Compression Overview of Table Compression Creating Compressed Tables Tuning Compression for InnoDB Tables Monitoring Compression at Runtime How Compression Works for InnoDB Tables Compression for OLTP Workloads SQL Compression Syntax Warnings and Errors InnoDB Page Compression 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 Modifying 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 and Online DDL Overview of Online DDL Performance and Concurrency Considerations for Online DDL SQL Syntax for Online DDL Combining or Separating DDL Statements Examples of Online DDL Implementation Details of Online DDL How Crash Recovery Works with Online DDL Online DDL for Partitioned InnoDB Tables