MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
InnoDB Storage Engine - Primary and Secondary Indexes
This chapter provides tutorial examples and notes on the InnoDB storage engine. Topics include InnoDB data rows and pages; the primary index and secondary indexes; full table scan; performance of index ranges; tablespace files; InnoDB initialization errors; 'ibd2sdi' command to extract SDI.
These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.
Primary Key Index on InnoDB Table
InnoDB Primary Key Index on Large Table
"SELECT COUNT(*)" on InnoDB Table
InnoDB Table with Long Rows
Secondary Index on InnoDB Table
Unique Index on InnoDB Table
Performance of Index Range on InnoDB Table
Workaround on InnoDB "SELECT COUNT(*)" Problem
InnoDB Tablespace Files
Moving InnoDB Data Files or Directories
Exporting and Importing InnoDB Tablespace Files
InnoDB Initialization Fails to Finish
ibd2sdi — InnoDB SDI Extraction Utility
Takeaways:
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
Storage Engines in MySQL Server
►InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Installing MySQL Server on Linux