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
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, Overview of InnoDB File Formats
- 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 cache, Making Buffer Cache Scan Resistant
- buffer pool, 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, 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
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
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
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, Overview of InnoDB Support in INFORMATION_SCHEMA, Information Schema Tables about Transactions, Notes on Locking in InnoDB
- locking read, InnoDB Glossary
- log, InnoDB Glossary
- log buffer, InnoDB Glossary
- log file, InnoDB Glossary
- log group, InnoDB Glossary
- logical, InnoDB Glossary
- logical backup, InnoDB Glossary
- loose_, InnoDB Glossary
- low-water mark, InnoDB Glossary
- LRU, InnoDB Glossary
- LRU page replacement, Making Buffer Cache Scan Resistant
- LSN, 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
O
[
index top]
- off-page column, InnoDB Glossary
- OLTP, InnoDB Glossary
- online, InnoDB Glossary
- online DDL, 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
- 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
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