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
.cfg 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
AHI, InnoDB Glossary
AIO, InnoDB Glossary
ALTER TABLE
ROW_FORMAT, Specifying a Table’s Row Format
Antelope, InnoDB Glossary
Antelope file format, Overview of InnoDB File Formats
application programming interface (API), InnoDB Glossary
apply, InnoDB Glossary
asynchronous I/O, InnoDB Glossary
atomic, InnoDB Glossary
atomic instruction, InnoDB Glossary
auto-increment, InnoDB Glossary
auto-increment locking, InnoDB Glossary
autocommit, InnoDB Glossary

C

[index top]
cache, InnoDB Glossary
cardinality, InnoDB Glossary
change buffer, InnoDB Glossary
change buffering, Issues with the Insert Buffer, InnoDB Glossary
disabling, Controlling InnoDB Insert Buffering
checkpoint, InnoDB Glossary
checksum, InnoDB Glossary
child table, InnoDB Glossary
clean page, 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
compiling, Building the InnoDB Plugin from Source Code
composite index, InnoDB Glossary
compressed backup, InnoDB Glossary
compressed row format, InnoDB Glossary
compression, InnoDB Glossary
algorithms, Compression Algorithms
application and schema design, Compression and Application and Schema Design
BLOBs, VARCHAR and TEXT, Compressing BLOB, VARCHAR and TEXT Columns
buffer pool, Compression and the InnoDB Buffer Pool
compressed page size, Choosing the Compressed Page Size
configuration characteristics, Configuration Characteristics and Compression
data and indexes, InnoDB Data Storage and Compression
data characteristics, Data Characteristics and Compression
enabling for a table, Enabling Compression for a Table
implementation, How Compression Works in InnoDB
information schema, Overview of InnoDB Support in INFORMATION_SCHEMA, Information Schema Tables about Compression
innodb_strict_mode, InnoDB Strict Mode
KEY_BLOCK_SIZE, Choosing the Compressed Page Size
log files, Compression and the InnoDB Log Files
modification log, Compression of B-Tree Pages
monitoring, Monitoring Compression at Runtime
overflow pages, Compressing BLOB, VARCHAR and TEXT Columns
overview, Overview of Table Compression
tuning, Tuning InnoDB Compression
workload characteristics, Workload Characteristics and Compression
concurrency, InnoDB Glossary
configuration file, InnoDB Glossary
configuring, Configuring the InnoDB Plugin
consistent read, InnoDB Glossary
constraint, InnoDB Glossary
counter, InnoDB Glossary
covering index, InnoDB Glossary
crash, InnoDB Glossary
crash recovery, InnoDB Glossary
CREATE INDEX, Overview of Fast Index Creation
CREATE TABLE
KEY_BLOCK_SIZE, Choosing the Compressed Page Size
options for table compression, Enabling Compression for a Table
ROW_FORMAT, Specifying a Table’s Row Format
CRUD, InnoDB Glossary
cursor, InnoDB Glossary

D

[index top]
data dictionary, InnoDB Glossary
data directory, InnoDB Glossary
data files, InnoDB Glossary
data warehouse, InnoDB Glossary
database, InnoDB Glossary
DCL, InnoDB Glossary
DDL, InnoDB Glossary
deadlock, InnoDB Glossary
deadlock detection, InnoDB Glossary
delete, InnoDB Glossary
delete buffering, InnoDB Glossary
denormalized, InnoDB Glossary
descending index, InnoDB Glossary
dirty page, InnoDB Glossary
dirty read, InnoDB Glossary
disk-based, InnoDB Glossary
disk-bound, InnoDB Glossary
DML, InnoDB Glossary
document id, InnoDB Glossary
doublewrite buffer, InnoDB Glossary
downgrading, Overview
drop, InnoDB Glossary
DROP INDEX, Overview of Fast Index Creation
dynamic row format, InnoDB Glossary

E

[index top]
early adopter, InnoDB Glossary
error log, InnoDB Glossary
eviction, InnoDB Glossary
exclusive lock, InnoDB Glossary
extent, InnoDB Glossary

F

[index top]
Fast Index Creation, InnoDB Glossary
concurrency, Concurrency Considerations
crash recovery, Crash Recovery
examples, Examples
implementation, Implementation
limitations, Limitations
overview, Overview of Fast Index Creation
fast shutdown, InnoDB Glossary
file format, Overview of InnoDB File Formats, InnoDB Glossary
Antelope, Compressing BLOB, VARCHAR and TEXT Columns
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, Enabling New File Formats
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
foreign key, InnoDB Glossary
FOREIGN KEY constraint, InnoDB Glossary
FOREIGN KEY constraints
and fast index creation, Limitations
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
high-water mark, InnoDB Glossary
history list, InnoDB Glossary
hot, InnoDB Glossary
hot backup, InnoDB Glossary

I

[index top]
ib-file set, File Format Compatibility, InnoDB Glossary
ibbackup command, InnoDB Glossary
ibbackup_logfile, InnoDB Glossary
ibdata file, InnoDB Glossary
ib_logfile, InnoDB Glossary
ignore_builtin_innodb, Installing the Precompiled InnoDB Plugin as a Shared Library
and skip_innodb, Using the InnoDB Plugin with MySQL 5.1.30 or Earlier
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
primary (clustered) and secondary, Implementation
infimum record, InnoDB Glossary
information schema tables, Overview of InnoDB Support in INFORMATION_SCHEMA
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
InnoDB Hot Backup, InnoDB Glossary
InnoDB Plugin
compatibility, Features of the InnoDB Plugin
downloading, Obtaining and Installing the InnoDB Plugin
features, Features of the InnoDB Plugin
installing, Obtaining and Installing the InnoDB Plugin
restrictions, Operational Restrictions
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 Insert Buffering
innodb_concurrency_tickets, Changes Regarding Thread Concurrency
innodb_file_format, Overview of InnoDB File Formats, InnoDB Glossary
Antelope, Compressing BLOB, VARCHAR and TEXT Columns
Barracuda, Enabling Compression for a Table
downgrading, Overview
enabling new file formats, Enabling New File Formats
identifying, Identifying the File Format in Use
innodb_file_format_check, Startup File Format Compatibility Checking
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 Cache Scan Resistant
innodb_old_blocks_time, Making Buffer Cache 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, Issues with the Insert Buffer, InnoDB Glossary
disabling, Controlling InnoDB Insert Buffering
installing
binary InnoDB Plugin, Installing the Precompiled InnoDB Plugin as a Shared Library, Using the InnoDB Plugin with MySQL 5.1.30 or Earlier
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

M

[index top]
master server, InnoDB Glossary
master thread, InnoDB Glossary
MDL, InnoDB Glossary
memcached, 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 Cache Scan Resistant
midpoint insertion strategy, InnoDB Glossary
mini-transaction, InnoDB Glossary
mixed-mode insert, InnoDB Glossary
multi-core, InnoDB Glossary
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]
natural key, InnoDB Glossary
neighbor page, InnoDB Glossary
next-key lock, InnoDB Glossary
non-blocking I/O, InnoDB Glossary
non-locking read, InnoDB Glossary
non-repeatable read, InnoDB Glossary
normalized, InnoDB Glossary
NoSQL, InnoDB Glossary
NOT NULL constraint, InnoDB Glossary
NULL, InnoDB Glossary

P

[index top]
page, InnoDB Glossary
page cleaner, InnoDB Glossary
page size, InnoDB Glossary
parameters, deprecated, Deprecated Parameters
innodb_file_io_threads, Multiple Background I/O Threads
parameters, new, New Parameters
innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages
innodb_change_buffering, Controlling InnoDB Insert Buffering
innodb_file_format, Enabling New File Formats
innodb_file_format_check, Startup File Format Compatibility Checking
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
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_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
parent table, InnoDB Glossary
partial backup, InnoDB Glossary
partial index, InnoDB Glossary
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 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
linear, Changes in the Read Ahead Algorithm
random, Changes in the Read Ahead Algorithm
READ COMMITTED, InnoDB Glossary
READ UNCOMMITTED, InnoDB Glossary
read view, InnoDB Glossary
read-ahead, InnoDB Glossary
read-only transaction, InnoDB Glossary
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, COMPACT and REDUNDANT Row Formats
COMPRESSED, Enabling Compression for a Table, DYNAMIC Row Format
DYNAMIC, DYNAMIC Row Format
REDUNDANT, 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
skip_innodb
and ignore_builtin_innodb, Using the InnoDB Plugin with MySQL 5.1.30 or Earlier
slave server, InnoDB Glossary
slow query log, InnoDB Glossary
slow shutdown, InnoDB Glossary
snapshot, InnoDB Glossary
source code, Building the InnoDB Plugin from Source Code
space ID, InnoDB Glossary
spin, InnoDB Glossary
SQL, InnoDB Glossary
SSD, Overview of Table Compression, InnoDB Glossary
startup, 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
surrogate key, InnoDB Glossary
synthetic key, InnoDB Glossary
system tablespace, InnoDB Glossary

T

[index top]
table, InnoDB Glossary
table lock, InnoDB Glossary
table scan, Making Buffer Cache 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
transportable tablespace, InnoDB Glossary
troubleshooting, InnoDB Glossary
truncate, InnoDB Glossary
TRUNCATE TABLE, TRUNCATE TABLE Reclaims Space
tuple, InnoDB Glossary
two-phase commit, 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