Documentation Home
InnoDB 1.1 for MySQL 5.5 User's Guide
Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


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
.isl 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

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 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, COMPACT and REDUNDANT Row Formats, InnoDB Glossary
composite index, InnoDB Glossary
compressed backup, InnoDB Glossary
compressed row format, DYNAMIC and COMPRESSED Row Formats, InnoDB Glossary
compression, Working with InnoDB Compressed Tables, InnoDB Glossary
algorithms, How Compression Works for InnoDB Tables
application and schema design, Tuning Compression for InnoDB Tables
BLOBs, VARCHAR and TEXT, How Compression Works for InnoDB Tables
buffer pool considerations, How Compression Works for InnoDB Tables
compressed page size, Tuning Compression for InnoDB Tables
configuration characteristics, Tuning Compression for InnoDB Tables
data and indexes, How Compression Works for InnoDB Tables
data characteristics, Tuning Compression for InnoDB Tables
enabling for a table, Enabling Compression for a Table
implementation, How Compression Works for InnoDB Tables
information schema, InnoDB INFORMATION_SCHEMA tables, Information Schema Tables about Compression
innodb_strict_mode, InnoDB Strict Mode
KEY_BLOCK_SIZE, Tuning Compression for InnoDB Tables
log file format, How Compression Works for InnoDB Tables
modification log, How Compression Works for InnoDB Tables
monitoring, Tuning Compression for InnoDB Tables
overflow pages, How Compression Works for InnoDB Tables
overview, Overview of Table Compression
tuning, Tuning Compression for InnoDB Tables
workload characteristics, Tuning Compression for InnoDB Tables
compression failure, InnoDB Glossary
concurrency, InnoDB Glossary
configuration file, InnoDB Glossary
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, Tuning Compression for InnoDB Tables
options for table compression, Enabling Compression for a Table
ROW_FORMAT, Specifying the Row Format for a Table
CRUD, InnoDB Glossary
cursor, InnoDB Glossary

E

[index top]
early adopter, InnoDB Glossary
error log, InnoDB Glossary
eviction, InnoDB Glossary
exclusive lock, InnoDB Glossary
extent, 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, Verifying File Format Compatibility, InnoDB Glossary
ibbackup_logfile, InnoDB Glossary
ibdata file, InnoDB Glossary
ibtmp 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
INFORMATION_SCHEMA, InnoDB Glossary
INNODB_CMP table, INNODB_CMP and INNODB_CMP_RESET
INNODB_CMPMEM table, INNODB_CMPMEM and INNODB_CMPMEM_RESET
INNODB_CMPMEM_RESET table, INNODB_CMPMEM and INNODB_CMPMEM_RESET
INNODB_CMP_RESET table, INNODB_CMP and INNODB_CMP_RESET
INNODB_LOCKS table, Information Schema Tables about Transactions
INNODB_LOCK_WAITS table, Information Schema Tables about Transactions
INNODB_TRX table, Information Schema Tables about Transactions
InnoDB, InnoDB Glossary
troubleshooting
fast index creation, Limitations of Fast Index Creation
InnoDB parameters, deprecated, Deprecated Parameters
innodb_file_io_threads, Multiple Background InnoDB I/O Threads
InnoDB parameters, new, New Parameters
innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages from the InnoDB Buffer Pool
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 InnoDB Master Thread I/O Rate
innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm
innodb_read_io_threads, Multiple Background InnoDB 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 InnoDB I/O Threads
InnoDB parameters, with new defaults, Parameters with New Defaults
innodb_change_buffering, Parameters with New Defaults
innodb_file_format, Parameters with New Defaults
innodb_file_format_check, Parameters with New Defaults
innodb_file_per_table, Parameters with New Defaults
innodb_max_dirty_pages_pct, Controlling the Flushing Rate of Dirty Pages from the InnoDB Buffer Pool
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 from the InnoDB Buffer Pool
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 system variable
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 for InnoDB Tables
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 InnoDB 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 InnoDB 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 from the InnoDB Buffer Pool
innodb_old_blocks_pct, Making the Buffer Pool Scan Resistant
innodb_old_blocks_time, Making the Buffer Pool Scan Resistant
innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm
innodb_read_io_threads, Multiple Background InnoDB I/O Threads
innodb_spin_wait_delay, Control of Spin Lock Polling
innodb_stats_on_metadata system variable, 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
and innodb_thread_concurrency, Changes Regarding Thread Concurrency
innodb_use_sys_malloc system variable, Using Operating System Memory Allocators
innodb_write_io_threads, Multiple Background InnoDB 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
IOPS, 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 the 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]
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
parent table, InnoDB Glossary
partial backup, InnoDB Glossary
partial index, InnoDB Glossary
Performance Schema, Integration with the 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

S

[index top]
savepoint, InnoDB Glossary
scalability, InnoDB Glossary
scale out, InnoDB Glossary
scale up, 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
space ID, InnoDB Glossary
spin, InnoDB Glossary
SQL, InnoDB Glossary
SSD, Working with InnoDB Compressed Tables, 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 the Buffer Pool Scan Resistant
table type, InnoDB Glossary
tablespace, InnoDB Glossary
tablespace dictionary, InnoDB Glossary
temporary table, InnoDB Glossary
temporary tablespace, 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
tuning
InnoDB compressed tables, Tuning Compression for InnoDB Tables
tuple, InnoDB Glossary
two-phase commit, InnoDB Glossary

U

[index top]
undo, InnoDB Glossary
undo log, InnoDB Glossary
undo tablespace, InnoDB Glossary
unique constraint, InnoDB Glossary
unique index, InnoDB Glossary
unique key, 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

PREV   HOME   UP  
User Comments
Sign Up Login You must be logged in to post a comment.