MySQL :: InnoDB 1.1 for MySQL 5.5 User’s Guide

InnoDB 1.1 for MySQL 5.5 User’s Guide :: Index

« C InnoDB Glossary

Section Navigation [Toggle]

Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

.ARM file, InnoDB Glossary
.ARZ file, InnoDB Glossary
.frm file, InnoDB Glossary
.ibd file, InnoDB Glossary
.ibz file, InnoDB Glossary
.MRG file, InnoDB Glossary
.MYD file, InnoDB Glossary
.MYI file, InnoDB Glossary
.OPT file, InnoDB Glossary
.PAR file, InnoDB Glossary
.TRG file, InnoDB Glossary
.TRN file, InnoDB Glossary

A

[index top]

ACID, InnoDB Glossary

adaptive flushing, InnoDB Glossary

adaptive hash index, Controlling Adaptive Hash Indexing, Dynamically Changing innodb_adaptive_hash_index, InnoDB Glossary

AIO, InnoDB Glossary

ALTER TABLE

ROW_FORMAT, Specifying the Row Format for a Table

Antelope, InnoDB Glossary

Antelope file format, InnoDB File-Format Management

application programming interface (API), InnoDB Glossary

apply, InnoDB Glossary

asynchronous I/O, Asynchronous I/O on Linux, InnoDB Glossary

atomic, InnoDB Glossary

atomic instruction, InnoDB Glossary

auto-increment, InnoDB Glossary

auto-increment locking, InnoDB Glossary

autocommit, InnoDB Glossary

B

[index top]

B-tree, InnoDB Glossary

background threads

master, Controlling the Master Thread I/O Rate, Controlling the Flushing Rate of Dirty Pages
read, Multiple Background I/O Threads
write, Multiple Background I/O Threads

backticks, InnoDB Glossary

backup, InnoDB Glossary

Barracuda, InnoDB Glossary

Barracuda file format, InnoDB File-Format Management

beta, InnoDB Glossary

binary log, InnoDB Glossary

binlog, InnoDB Glossary

blind query expansion, InnoDB Glossary

bottleneck, InnoDB Glossary

bounce, InnoDB Glossary

buddy allocator, InnoDB Glossary

buffer, InnoDB Glossary

buffer pool, Making Buffer Pool Scan Resistant, InnoDB Glossary

buffer pool instance, InnoDB Glossary

built-in, InnoDB Glossary

business rules, InnoDB Glossary

C

[index top]

cache, InnoDB Glossary

cardinality, InnoDB Glossary

change buffer, InnoDB Glossary

change buffering, InnoDB Glossary

disabling, Controlling InnoDB Change Buffering

checkpoint, InnoDB Glossary

checksum, InnoDB Glossary

child table, InnoDB Glossary

clean shutdown, InnoDB Glossary

client, InnoDB Glossary

clustered index, InnoDB Glossary

cold backup, InnoDB Glossary

column, InnoDB Glossary

column index, InnoDB Glossary

column prefix, InnoDB Glossary

commit, InnoDB Glossary

compact row format, InnoDB Glossary

composite index, InnoDB Glossary

compressed backup, InnoDB Glossary

compressed row format, InnoDB Glossary

compression, InnoDB Glossary

algorithms, How Compression Works in InnoDB
application and schema design, Tuning InnoDB Compression
BLOBs, VARCHAR and TEXT, How Compression Works in InnoDB
buffer pool, How Compression Works in InnoDB
compressed page size, Tuning InnoDB Compression
configuration characteristics, Tuning InnoDB Compression
data and indexes, How Compression Works in InnoDB
data characteristics, Tuning InnoDB Compression
enabling for a table, Enabling Compression for a Table
implementation, How Compression Works in InnoDB
information schema, InnoDB INFORMATION_SCHEMA tables, Information Schema Tables about Compression
innodb_strict_mode, InnoDB Strict Mode
KEY_BLOCK_SIZE, Tuning InnoDB Compression
log files, How Compression Works in InnoDB
modification log, How Compression Works in InnoDB
monitoring, Tuning InnoDB Compression
overflow pages, How Compression Works in InnoDB
overview, Overview of Table Compression
tuning, Tuning InnoDB Compression
workload characteristics, Tuning InnoDB Compression

concurrency, InnoDB Glossary

configuration file, InnoDB Glossary

consistent read, InnoDB Glossary

constraint, InnoDB Glossary

counter, InnoDB Glossary

covering index, InnoDB Glossary

crash recovery, InnoDB Glossary

CREATE INDEX, Overview of Fast Index Creation

CREATE TABLE

KEY_BLOCK_SIZE, Tuning InnoDB Compression
options for table compression, Enabling Compression for a Table
ROW_FORMAT, Specifying the Row Format for a Table

CRUD, InnoDB Glossary

cursor, InnoDB Glossary

Fast Index Creation, InnoDB Glossary

concurrency, Concurrency Considerations for Fast Index Creation
crash recovery, How Crash Recovery Works with Fast Index Creation
examples, Examples of Fast Index Creation
implementation, Implementation Details of Fast Index Creation
limitations, Limitations of Fast Index Creation
overview, Overview of Fast Index Creation

fast shutdown, InnoDB Glossary

file format, InnoDB File-Format Management, InnoDB Glossary

Antelope, How Compression Works in InnoDB
Barracuda, Enabling Compression for a Table
downgrading, Downgrading the File Format
identifying, Identifying the File Format in Use

file format management

downgrading, Overview
enabling new file formats, The Barracuda File Format

file per table, Dynamically Changing innodb_file_per_table

file-per-table, InnoDB Glossary

fill factor, InnoDB Glossary

fixed row format, InnoDB Glossary

flush, InnoDB Glossary

flush list, InnoDB Glossary

flush list mutex, Separate Flush List Mutex

foreign key, InnoDB Glossary

FOREIGN KEY constraint, InnoDB Glossary

FOREIGN KEY constraints

and fast index creation, Limitations of Fast Index Creation
and TRUNCATE TABLE, TRUNCATE TABLE Reclaims Space

FTS, InnoDB Glossary

full backup, InnoDB Glossary

full table scan, InnoDB Glossary

full-text search, InnoDB Glossary

FULLTEXT index, InnoDB Glossary

fuzzy checkpointing, InnoDB Glossary

G

[index top]

GA, InnoDB Glossary
gap, InnoDB Glossary
gap lock, InnoDB Glossary
general query log, InnoDB Glossary
global_transaction, InnoDB Glossary
group commit, Group Commit, InnoDB Glossary

H

[index top]

hash index, InnoDB Glossary
HDD, InnoDB Glossary
heartbeat, InnoDB Glossary
history list, InnoDB Glossary
hot, InnoDB Glossary
hot backup, InnoDB Glossary

I

[index top]

ib-file set, Verifying File Format Compatibility, InnoDB Glossary

ibbackup command, InnoDB Glossary

ibbackup_logfile, InnoDB Glossary

ibdata file, InnoDB Glossary

ib_logfile, InnoDB Glossary

ilist, InnoDB Glossary

implicit row lock, InnoDB Glossary

in-memory database, InnoDB Glossary

incremental backup, InnoDB Glossary

index, InnoDB Glossary

index cache, InnoDB Glossary

index dives (for statistics estimation), Controlling Optimizer Statistics Estimation

index hint, InnoDB Glossary

index prefix, InnoDB Glossary

indexes

creating and dropping, Implementation Details of Fast Index Creation
primary (clustered) and secondary, Implementation Details of Fast Index Creation

infimum record, InnoDB Glossary

information schema tables, InnoDB INFORMATION_SCHEMA tables

INNODB_CMP, INNODB_CMP and INNODB_CMP_RESET
INNODB_CMPMEM, INNODB_CMPMEM and INNODB_CMPMEM_RESET
INNODB_CMPMEM_RESET, INNODB_CMPMEM and INNODB_CMPMEM_RESET
INNODB_CMP_RESET, INNODB_CMP and INNODB_CMP_RESET
INNODB_LOCKS, INNODB_LOCKS
INNODB_LOCK_WAITS, INNODB_LOCK_WAITS
INNODB_TRX, INNODB_TRX

INFORMATION_SCHEMA, InnoDB Glossary

innobackup command, InnoDB Glossary

InnoDB, InnoDB Glossary

troubleshooting

fast index creation, Limitations of Fast Index Creation

InnoDB Hot Backup, InnoDB Glossary

InnoDB parameters, deprecated, Deprecated Parameters

innodb_file_io_threads, Multiple Background I/O Threads

InnoDB parameters, new, New Parameters

innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages
innodb_change_buffering, Controlling InnoDB Change Buffering
innodb_file_format, The Barracuda File Format
innodb_file_format_check, Compatibility Check When InnoDB Is Started
innodb_io_capacity, Controlling the Master Thread I/O Rate
innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm
innodb_read_io_threads, Multiple Background I/O Threads
innodb_spin_wait_delay, Control of Spin Lock Polling
innodb_stats_sample_pages, Controlling Optimizer Statistics Estimation
innodb_strict_mode, InnoDB Strict Mode
innodb_use_sys_malloc, Using Operating System Memory Allocators
innodb_write_io_threads, Multiple Background I/O Threads

InnoDB parameters, with new defaults, Parameters with New Defaults

innodb_additional_mem_pool_size, Parameters with New Defaults
innodb_buffer_pool_size, Parameters with New Defaults
innodb_change_buffering, Parameters with New Defaults
innodb_file_format_check, Parameters with New Defaults
innodb_log_buffer_size, Parameters with New Defaults
innodb_max_dirty_pages_pct, Controlling the Flushing Rate of Dirty Pages, Parameters with New Defaults
innodb_sync_spin_loops, Parameters with New Defaults
innodb_thread_concurrency, Parameters with New Defaults

InnoDB storage engine

compatibility, Features of the InnoDB Storage Engine
downloading, Obtaining and Installing the InnoDB Storage Engine
features, Features of the InnoDB Storage Engine
installing, Obtaining and Installing the InnoDB Storage Engine
restrictions, Compatibility Considerations for Downgrade and Backup

innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages

innodb_adaptive_hash_index, Controlling Adaptive Hash Indexing

and innodb_thread_concurrency, Changes Regarding Thread Concurrency
dynamically changing, Dynamically Changing innodb_adaptive_hash_index

innodb_additional_mem_pool_size

and innodb_use_sys_malloc, Using Operating System Memory Allocators

innodb_autoinc_lock_mode, InnoDB Glossary

innodb_change_buffering, Controlling InnoDB Change Buffering

innodb_concurrency_tickets, Changes Regarding Thread Concurrency

innodb_file_format, InnoDB File-Format Management, InnoDB Glossary

Antelope, How Compression Works in InnoDB
Barracuda, Enabling Compression for a Table
downgrading, Overview
enabling new file formats, The Barracuda File Format
identifying, Identifying the File Format in Use

innodb_file_format_check, Compatibility Check When InnoDB Is Started

innodb_file_io_threads, Multiple Background I/O Threads

innodb_file_per_table, Enabling Compression for a Table, InnoDB Glossary

dynamically changing, Dynamically Changing innodb_file_per_table

innodb_io_capacity, Controlling the Master Thread I/O Rate

innodb_lock_wait_timeout, InnoDB Glossary

dynamically changing, Dynamically Changing innodb_lock_wait_timeout

innodb_max_dirty_pages_pct, Controlling the Flushing Rate of Dirty Pages

innodb_old_blocks_pct, Making Buffer Pool Scan Resistant

innodb_old_blocks_time, Making Buffer Pool Scan Resistant

innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm

innodb_read_io_threads, Multiple Background I/O Threads

innodb_spin_wait_delay, Control of Spin Lock Polling

innodb_stats_on_metadata

dynamically changing, Dynamically Changing innodb_stats_on_metadata

innodb_stats_sample_pages, Controlling Optimizer Statistics Estimation

innodb_strict_mode, InnoDB Strict Mode, InnoDB Glossary

innodb_thread_concurrency, Changes Regarding Thread Concurrency

innodb_thread_sleep_delay, Changes Regarding Thread Concurrency

innodb_use_sys_malloc, Using Operating System Memory Allocators

and innodb_thread_concurrency, Changes Regarding Thread Concurrency

innodb_write_io_threads, Multiple Background I/O Threads

insert, InnoDB Glossary

insert buffer, InnoDB Glossary

insert buffering, InnoDB Glossary

disabling, Controlling InnoDB Change Buffering

instance, InnoDB Glossary

instrumentation, InnoDB Glossary

intention lock, InnoDB Glossary

internal memory allocator

disabling, Using Operating System Memory Allocators

inverted index, InnoDB Glossary

isolation level, InnoDB Glossary

J

[index top]

join, InnoDB Glossary

K

[index top]

KEY_BLOCK_SIZE, Enabling Compression for a Table, Tuning InnoDB Compression, InnoDB Glossary

L

[index top]

latch, InnoDB Glossary

list, InnoDB Glossary

lock, InnoDB Glossary

lock escalation, InnoDB Glossary

lock mode, InnoDB Glossary

lock wait timeout, Dynamically Changing innodb_lock_wait_timeout

locking, InnoDB Glossary

information schema, InnoDB INFORMATION_SCHEMA tables, Information Schema Tables about Transactions, Special Locking Considerations for InnoDB INFORMATION_SCHEMA Tables

locking read, InnoDB Glossary

log, InnoDB Glossary

log buf mutex, Improved Log Sys Mutex

log buffer, InnoDB Glossary

log file, InnoDB Glossary

log group, InnoDB Glossary

log sys mutex, Improved Log Sys Mutex

logical, InnoDB Glossary

logical backup, InnoDB Glossary

loose_, InnoDB Glossary

LRU, InnoDB Glossary

LRU page replacement, Making Buffer Pool Scan Resistant

LSN, InnoDB Glossary

M

[index top]

master server, InnoDB Glossary

master thread, InnoDB Glossary

MDL, InnoDB Glossary

memory allocator

innodb_use_sys_malloc, Using Operating System Memory Allocators

merge, InnoDB Glossary

metadata lock, InnoDB Glossary

metrics counter, InnoDB Glossary

midpoint insertion, Making Buffer Pool Scan Resistant

midpoint insertion strategy, InnoDB Glossary

mini-transaction, InnoDB Glossary

mixed-mode insert, InnoDB Glossary

multi-core, InnoDB Glossary

multiple buffer pools, Improvements to Performance from Multiple Buffer Pools

multiple rollback segments, Better Scalability with Multiple Rollback Segments

mutex, InnoDB Glossary

MVCC, InnoDB Glossary

my.cnf, InnoDB Glossary

my.ini, InnoDB Glossary

mysql, InnoDB Glossary

MySQL Enterprise Backup, InnoDB Glossary

mysqlbackup command, InnoDB Glossary

mysqld, InnoDB Glossary

mysqldump, InnoDB Glossary

N

[index top]

neighbor page, InnoDB Glossary
next-key lock, InnoDB Glossary
non-blocking I/O, InnoDB Glossary
non-repeatable read, InnoDB Glossary
normalized, InnoDB Glossary
NOT NULL constraint, InnoDB Glossary
NULL, InnoDB Glossary

O

[index top]

off-page column, InnoDB Glossary
OLTP, InnoDB Glossary
online, InnoDB Glossary
optimistic, InnoDB Glossary
optimizer, InnoDB Glossary
optimizer statistics estimation, Dynamically Changing innodb_stats_on_metadata, Controlling Optimizer Statistics Estimation
option, InnoDB Glossary
option file, InnoDB Glossary
overflow page, InnoDB Glossary

P

[index top]

page, InnoDB Glossary

page cleaner, InnoDB Glossary

page size, InnoDB Glossary

parent table, InnoDB Glossary

partial backup, InnoDB Glossary

partial index, InnoDB Glossary

Performance Schema, Integration with MySQL PERFORMANCE_SCHEMA, InnoDB Glossary

persistent statistics, InnoDB Glossary

pessimistic, InnoDB Glossary

phantom, InnoDB Glossary

physical, InnoDB Glossary

physical backup, InnoDB Glossary

PITR, InnoDB Glossary

plan stability, InnoDB Glossary

plugin, InnoDB Glossary

point-in-time recovery, InnoDB Glossary

prepared backup, InnoDB Glossary

primary key, InnoDB Glossary

process, InnoDB Glossary

PROCESSLIST

possible inconsistency with INFORMATION_SCHEMA tables, Possible Inconsistency with PROCESSLIST

pseudo-record, InnoDB Glossary

Pthreads, InnoDB Glossary

purge, InnoDB Glossary

purge buffering, InnoDB Glossary

purge lag, InnoDB Glossary

purge scheduling, Better Scalability with Improved Purge Scheduling

purge thread, InnoDB Glossary

Q

[index top]

query, InnoDB Glossary
query execution plan, InnoDB Glossary
quiesce, InnoDB Glossary

R

[index top]

RAID, InnoDB Glossary

random dive, InnoDB Glossary

raw backup, InnoDB Glossary

read ahead, More Read-Ahead Statistics

READ COMMITTED, InnoDB Glossary

READ UNCOMMITTED, InnoDB Glossary

read view, InnoDB Glossary

read-ahead, InnoDB Glossary

linear, Changes in the Read-Ahead Algorithm
random, Changes in the Read-Ahead Algorithm

record lock, InnoDB Glossary

redo, InnoDB Glossary

redo log, InnoDB Glossary

redundant row format, InnoDB Glossary

referential integrity, InnoDB Glossary

relational, InnoDB Glossary

relevance, InnoDB Glossary

REPEATABLE READ, InnoDB Glossary

replication, InnoDB Glossary

restore, InnoDB Glossary

rollback, InnoDB Glossary

rollback segment, InnoDB Glossary

row, InnoDB Glossary

row format, InnoDB Glossary

row lock, InnoDB Glossary

row-based replication, InnoDB Glossary

row-level locking, InnoDB Glossary

ROW_FORMAT

COMPACT, Antelope File Format: COMPACT and REDUNDANT Row Formats
COMPRESSED, Enabling Compression for a Table, Barracuda File Format: DYNAMIC and COMPRESSED Row Formats
DYNAMIC, Barracuda File Format: DYNAMIC and COMPRESSED Row Formats
REDUNDANT, Antelope File Format: COMPACT and REDUNDANT Row Formats

rw-lock, InnoDB Glossary

S

[index top]

savepoint, InnoDB Glossary

scalability, InnoDB Glossary

schema, InnoDB Glossary

search index, InnoDB Glossary

secondary index, InnoDB Glossary

segment, InnoDB Glossary

selectivity, InnoDB Glossary

semi-consistent read, InnoDB Glossary

SERIALIZABLE, InnoDB Glossary

server, InnoDB Glossary

shared lock, InnoDB Glossary

shared tablespace, InnoDB Glossary

sharp checkpoint, InnoDB Glossary

SHOW ENGINE INNODB MUTEX, More Compact Output of SHOW ENGINE INNODB MUTEX

SHOW ENGINE INNODB STATUS

and innodb_adaptive_hash_index, Controlling Adaptive Hash Indexing
and innodb_use_sys_malloc, Using Operating System Memory Allocators

shutdown, InnoDB Glossary

slave server, InnoDB Glossary

slow query log, InnoDB Glossary

slow shutdown, InnoDB Glossary

snapshot, InnoDB Glossary

spin, InnoDB Glossary

SQL, InnoDB Glossary

SSD, InnoDB Glossary

statement-based replication, InnoDB Glossary

statistics, InnoDB Glossary

stemming, InnoDB Glossary

stopword, InnoDB Glossary

storage engine, InnoDB Glossary

strict mode, InnoDB Strict Mode, InnoDB Glossary

sublist, InnoDB Glossary

supremum record, InnoDB Glossary

system tablespace, InnoDB Glossary

T

[index top]

table, InnoDB Glossary
table lock, InnoDB Glossary
table scan, Making Buffer Pool Scan Resistant
table type, InnoDB Glossary
tablespace, InnoDB Glossary
tablespace dictionary, InnoDB Glossary
temporary table, InnoDB Glossary
text collection, InnoDB Glossary
thread, InnoDB Glossary
torn page, InnoDB Glossary
TPS, InnoDB Glossary
transaction, InnoDB Glossary
transaction ID, InnoDB Glossary
troubleshooting, InnoDB Glossary
truncate, InnoDB Glossary
TRUNCATE TABLE, TRUNCATE TABLE Reclaims Space
tuple, InnoDB Glossary
two-phase commit, InnoDB Glossary

U

[index top]

undo, InnoDB Glossary
undo log, InnoDB Glossary
unique constraint, InnoDB Glossary
unique index, InnoDB Glossary
unique key, InnoDB Glossary

V

[index top]

victim, InnoDB Glossary

W

[index top]

wait, InnoDB Glossary
warm backup, InnoDB Glossary
warm up, InnoDB Glossary
Windows, InnoDB Glossary
workload, InnoDB Glossary
write combining, InnoDB Glossary

X

[index top]

XA, InnoDB Glossary

Y

[index top]

young, InnoDB Glossary

This is the User’s Guide for the InnoDB storage engine 1.1 for MySQL 5.5, generated on 2012-05-23 (revision: 30566) .

Top / Previous / Next / Up / Table of Contents