MySQL Glossary

.ARM file.

.ARZ file

ACID

adaptive flushing

adaptive hash index

AHI

AIO

application programming interface (API)

apply

asynchronous I/O

atomic

atomic DDL

atomic instruction

auto-increment

auto-increment locking

autocommit

availability

B-tree

backticks

backup

base column

beta

binary log

binlog

blind query expansion

bottleneck

bounce

buddy allocator

buffer

buffer pool

buffer pool instance

built-in

business rules

.cfg file

cache

cardinality

change buffer

change buffering

checkpoint

checksum

child table

clean page

clean shutdown

client

clustered index

cold backup

column

column index

column prefix

commit

compact row format

composite index

compressed backup

compressed row format

compressed table

compression

compression failure

concatenated index

concurrency

configuration file

consistent read

constraint

counter

covering index

CPU-bound

crash

crash recovery

CRUD

cursor

data definition language

data dictionary

data directory

data files

data manipulation language

data warehouse

database

DCL

DDL

deadlock

deadlock detection

delete

delete buffering

denormalized

descending index

dictionary object cache

dirty page

dirty read

disk-based

disk-bound

DML

document id

doublewrite buffer

drop

dynamic row format

early adopter

error log

eviction

exclusive lock

extent

.frm file

Fast Index Creation

fast shutdown

file format

file-per-table

fill factor

fixed row format

flush

flush list

foreign key

FOREIGN KEY constraint

FTS

full backup

full table scan

full-text search

FULLTEXT index

fuzzy checkpointing

GA

gap

gap lock

general log

general query log

general tablespace

generated column

generated stored column

generated virtual column

global transaction

group commit

hash index

HDD

heartbeat

high-water mark

history list

hole punching

hot

hot backup

.ibd file

.ibz file

I/O-bound

ib-file set

ibbackup_logfile

ibdata file

ibtmp file

ib_logfile

ilist

implicit row lock

in-memory database

incremental backup

index

index cache

index condition pushdown

index hint

index prefix

index statistics

infimum record

INFORMATION_SCHEMA

InnoDB

innodb_autoinc_lock_mode

innodb_file_per_table

innodb_lock_wait_timeout

innodb_strict_mode

insert

insert buffer

insert buffering

insert intention lock

instance

instrumentation

intention exclusive lock

intention lock

intention shared lock

inverted index

IOPS

isolation level

join

KEY_BLOCK_SIZE

latch

list

lock

lock escalation

lock mode

locking

locking read

log

log buffer

log file

log group

logical

logical backup

loose_

low-water mark

LRU

LSN

.MRG file

.MYD file

.MYI file

master server

master thread

MDL

memcached

merge

metadata lock

metrics counter

midpoint insertion strategy

mini-transaction

mixed-mode insert

mtr

multi-core

multiversion concurrency control

mutex

MVCC

my.cnf

my.ini

mysql

MySQL Enterprise Backup

mysqlbackup command

mysqld

mysqldump

natural key

neighbor page

next-key lock

non-locking read

non-repeatable read

nonblocking I/O

normalized

NoSQL

NOT NULL constraint

NULL

.OPT file

off-page column

OLTP

online

online DDL

optimistic

optimizer

option

option file

overflow page

.par file

page

page cleaner

page size

parent table

partial backup

partial index

Performance Schema

pessimistic

phantom

physical

physical backup

PITR

plan stability

point-in-time recovery

prefix

prepared backup

primary key

process

pseudo-record

Pthreads

purge

purge buffering

purge lag

purge thread

query

query execution plan

query log

quiesce

R-tree

RAID

random dive

raw backup

READ COMMITTED

read phenomena

READ UNCOMMITTED

read view

read-ahead

read-only transaction

record lock

redo

redo log

redundant row format

referential integrity

relational

relevance

REPEATABLE READ

repertoire

replication

restore

rollback

rollback segment

row

row format

row lock

row-based replication

row-level locking

rw-lock

savepoint

scalability

scale out

scale up

schema

SDI

search index

secondary index

segment

selectivity

semi-consistent read

SERIALIZABLE

Serialized Dictionary Information (SDI)

server

shared lock

shared tablespace

sharp checkpoint

shutdown

slave server

slow query log

slow shutdown

snapshot

sort buffer

space ID

sparse file

spin

SQL

SSD

startup

statement-based replication

statistics

stemming

stopword

storage engine

stored generated column

strict mode

sublist

supremum record

surrogate key

synthetic key

system tablespace

table

table lock

table scan

table statistics

table type

tablespace

temporary table

temporary tablespace

text collection

thread

torn page

TPS

transaction

transaction ID

transparent page compression

transportable tablespace

troubleshooting

truncate

tuple

two-phase commit

undo

undo buffer

undo log

undo log segment

undo tablespace

unique constraint

unique index

unique key

variable-length type

victim

virtual column

virtual generated column

virtual index

wait

warm backup

warm up

workload

write combining

XA

young