Important definitions and terminologies used in MySQL Database
A
.ARM file in MySQL Database
.ARZ file in MySQL Database
.cfg file in MySQL Database
.frm file in MySQL Database
.ibd file in MySQL Database
.ibz file in MySQL Database
.MRG file in MySQL Database
.MYD file in MySQL Database
.MYI file in MySQL Database
.NET in MySQL Database
.OPT file in MySQL Database
.par file in MySQL Database
A
ACID in MySQL Database
adaptive flushing in MySQL Database
adaptive hash index in MySQL Database
ADO.NET in MySQL Database
Aggregate Function in MySQL Database
AIO in MySQL Database
Alias in MySQL Database
ALTER in MySQL Database
ANSI in MySQL Database
API in MySQL Database
application programming interface (API) in MySQL Database
apply in MySQL Database
AS in MySQL Database
ASCII in MySQL Database
ASP.net in MySQL Database
assembly in MySQL Database
asynchronous I/O in MySQL Database
atomic in MySQL Database
atomic DDL in MySQL Database
atomic instruction in MySQL Database
authentication server in MySQL Database
autocommit in MySQL Database
auto-increment in MySQL Database
auto-increment locking in MySQL Database
availability in MySQL Database
B
backticks in MySQL Database
Backup in MySQL Database
Backup and Recovery in MySQL Database
base column in MySQL Database
beta in MySQL Database
Binary and textual backups in MySQL Database
binary log in MySQL Database
binlog in MySQL Database
blind query expansion in MySQL Database
BLOB in MySQL Database
Boolean in MySQL Database
bottleneck in MySQL Database
bounce in MySQL Database
B-tree in MySQL Database
buddy allocator in MySQL Database
Buffer in MySQL Database
buffer pool in MySQL Database
buffer pool instance in MySQL Database
built-in in MySQL Database
business rules in MySQL Database
C
C API in MySQL Database
C# in MySQL Database
C++ in MySQL Database
cache in MySQL Database
cardinality in MySQL Database
Cascade in MySQL Database
CAST in MySQL Database
change buffer in MySQL Database
change buffering in MySQL Database
CHAR in MySQL Database
CHECK in MySQL Database
checkpoint in MySQL Database
checksum in MySQL Database
child table in MySQL Database
clean page in MySQL Database
clean shutdown in MySQL Database
Client in MySQL Database
client libraries in MySQL Database
Client Programs in MySQL Database
Client/Server in MySQL Database
client-side prepared statement in MySQL Database
CLOB in MySQL Database
Clustered Index in MySQL Database
cold backup in MySQL Database
COLLATE in MySQL Database
Column in MySQL Database
column index in MySQL Database
column prefix in MySQL Database
command interceptor in MySQL Database
COMMIT in MySQL Database
compact row format in MySQL Database
composite index in MySQL Database
Composite Key in MySQL Database
compressed backup in MySQL Database
compressed row format in MySQL Database
compressed table in MySQL Database
compression in MySQL Database
compression failure in MySQL Database
concatenated index in MySQL Database
concurrency in MySQL Database
configuration file in MySQL Database
connection in MySQL Database
connection pool in MySQL Database
connection string in MySQL Database
connector in MySQL Database
Connector/C++ in MySQL Database
Connector/J in MySQL Database
Connector/NET in MySQL Database
Connector/ODBC in MySQL Database
Connector/PHP in MySQL Database
consistent read in MySQL Database
CONSTRAINT in MySQL Database
Constraints in MySQL Database
counter in MySQL Database
covering index in MySQL Database
CPU-bound in MySQL Database
crash in MySQL Database
crash recovery in MySQL Database
CRUD in MySQL Database
Cursor in MySQL Database
D
Data Definition in MySQL Database
data definition language in MySQL Database
Data Definition Language (DDL) in MySQL Database
data dictionary in MySQL Database
data directory in MySQL Database
data files in MySQL Database
data manipulation language in MySQL Database
Data Manipulation Language (DML) in MySQL Database
data recovery in MySQL Database
Data Type in MySQL Database
Data types in MySQL Database
data warehouse in MySQL Database
Database in MySQL Database
Database Management System (DBMS) in MySQL Database
Datetime in MySQL Database
DCL in MySQL Database
DDEX provider in MySQL Database
DDL in MySQL Database
Deadlock in MySQL Database
deadlock detection in MySQL Database
Default in MySQL Database
DELETE in MySQL Database
delete buffering in MySQL Database
Denormalization in MySQL Database
denormalized in MySQL Database
descending index in MySQL Database
dictionary object cache in MySQL Database
dirty page in MySQL Database
dirty read in MySQL Database
disk-based in MySQL Database
disk-bound in MySQL Database
DISTINCT in MySQL Database
DML in MySQL Database
document id in MySQL Database
doublewrite buffer in MySQL Database
DROP in MySQL Database
DSN in MySQL Database
dynamic cursor in MySQL Database
dynamic row format in MySQL Database
dynamic SQL in MySQL Database
dynamic statement in MySQL Database
E
early adopter in MySQL Database
Eiffel in MySQL Database
embedded in MySQL Database
Entity in MySQL Database
ERD in MySQL Database
Error Handling in MySQL Database
Error Log in MySQL Database
Error Log in MySQL Database
Escape Character in MySQL Database
Event in MySQL Database
eviction in MySQL Database
exception interceptor in MySQL Database
exclusive lock in MySQL Database
EXISTS in MySQL Database
Explicit table and advisory locking in MySQL Database
Export in MySQL Database
Expressions and joining in MySQL Database
extent in MySQL Database
F
failover in MySQL Database
Fast Index Creation in MySQL Database
fast shutdown in MySQL Database
Field in MySQL Database
file format in MySQL Database
Filegroup in MySQL Database
file-per-table in MySQL Database
fill factor in MySQL Database
fixed row format in MySQL Database
Float in MySQL Database
flush in MySQL Database
flush list in MySQL Database
Foreign Key in MySQL Database
FOREIGN KEY constraint in MySQL Database
FTS in MySQL Database
full backup in MySQL Database
full table scan in MySQL Database
FULLTEXT index in MySQL Database
Full-Text Search in MySQL Database
fuzzy checkpointing in MySQL Database
G
GA in MySQL Database
GAC in MySQL Database
gap in MySQL Database
gap lock in MySQL Database
general log in MySQL Database
general query log in MySQL Database
general tablespace in MySQL Database
generated column in MySQL Database
generated stored column in MySQL Database
generated virtual column in MySQL Database
Glassfish in MySQL Database
global temporary tablespace in MySQL Database
global transaction in MySQL Database
GROUP BY in MySQL Database
group commit in MySQL Database
Grouping and aggregate functions in MySQL Database
GUI in MySQL Database
GUID in MySQL Database
H
hash index in MySQL Database
HAVING in MySQL Database
HDD in MySQL Database
heartbeat in MySQL Database
high-water mark in MySQL Database
history list in MySQL Database
hole punching in MySQL Database
host in MySQL Database
hot in MySQL Database
hot backup in MySQL Database
I
I/O-bound in MySQL Database
ib_logfile in MySQL Database
ibbackup_logfile in MySQL Database
ibdata file in MySQL Database
ib-file set in MySQL Database
ibtmp file in MySQL Database
ilist in MySQL Database
implicit row lock in MySQL Database
incremental backup in MySQL Database
Index in MySQL Database
index cache in MySQL Database
index condition pushdown in MySQL Database
index hint in MySQL Database
index prefix in MySQL Database
index statistics in MySQL Database
indexes in MySQL Database
infimum record in MySQL Database
INFORMATION_SCHEMA in MySQL Database
in-memory database in MySQL Database
Inner Join in MySQL Database
InnoDB in MySQL Database
InnoDB, merge, innodb, memory, federated and cluster storage in MySQL Database
innodb_autoinc_lock_mode in MySQL Database
innodb_file_per_table in MySQL Database
innodb_lock_wait_timeout in MySQL Database
innodb_strict_mode in MySQL Database
INSERT in MySQL Database
insert buffer in MySQL Database
insert buffering in MySQL Database
insert intention lock in MySQL Database
instance in MySQL Database
instrumentation in MySQL Database
INT in MySQL Database
Integrity Constraints in MySQL Database
intention exclusive lock in MySQL Database
intention lock in MySQL Database
intention shared lock in MySQL Database
interceptor in MySQL Database
intrinsic temporary table in MySQL Database
inverted index in MySQL Database
IOPS in MySQL Database
Isolation Level in MySQL Database
J
J2EE in MySQL Database
Java in MySQL Database
JBoss in MySQL Database
JDBC in MySQL Database
JNDI in MySQL Database
Join in MySQL Database
JSON in MySQL Database
K
KDC in MySQL Database
Key in MySQL Database
key distribution center in MySQL Database
KEY_BLOCK_SIZE in MySQL Database
keystore in MySQL Database
L
latch in MySQL Database
LEFT JOIN in MySQL Database
libmysql in MySQL Database
libmysqlclient in MySQL Database
libmysqld in MySQL Database
lifecycle interceptor in MySQL Database
LIKE in MySQL Database
list in MySQL Database
load balancing in MySQL Database
localhost in MySQL Database
Lock in MySQL Database
lock escalation in MySQL Database
lock mode in MySQL Database
Locking in MySQL Database
locking read in MySQL Database
log in MySQL Database
Log and status files in MySQL Database
log buffer in MySQL Database
log file in MySQL Database
log group in MySQL Database
logical in MySQL Database
logical backup in MySQL Database
Logical Operator in MySQL Database
loose_ in MySQL Database
low-water mark in MySQL Database
LRU in MySQL Database
LSN in MySQL Database
M
master in MySQL Database
master thread in MySQL Database
MDL in MySQL Database
medium trust in MySQL Database
memcached in MySQL Database
merge in MySQL Database
Metadata in MySQL Database
metadata lock in MySQL Database
metrics counter in MySQL Database
midpoint insertion strategy in MySQL Database
mini-transaction in MySQL Database
mixed-mode insert in MySQL Database
MM.MySQL in MySQL Database
Mono in MySQL Database
more in MySQL Database
mtr in MySQL Database
multi-core in MySQL Database
Multiple Servers in MySQL Database
multiversion concurrency control in MySQL Database
mutex in MySQL Database
MVCC in MySQL Database
my.cnf in MySQL Database
my.ini in MySQL Database
MyODBC drivers in MySQL Database
mysql in MySQL Database
MySQL Architecture in MySQL Database
mysql cluster in MySQL Database
MySQL distributions in MySQL Database
MySQL Enterprise Backup in MySQL Database
MySQL Service in MySQL Database
MySQL storage engines in MySQL Database
mysqladmin in MySQL Database
mysqlbackup command in MySQL Database
mysqlclient in MySQL Database
mysqld in MySQL Database
MySQLdb in MySQL Database
mysqldump in MySQL Database
mysqlimport in MySQL Database
N
N/A in MySQL Database
native C API in MySQL Database
natural key in MySQL Database
neighbor page in MySQL Database
next-key lock in MySQL Database
nonblocking I/O in MySQL Database
non-locking read in MySQL Database
non-repeatable read in MySQL Database
normalized in MySQL Database
NoSQL in MySQL Database
NOT NULL in MySQL Database
NOT NULL constraint in MySQL Database
NULL in MySQL Database
O
ODBC in MySQL Database
off-page column in MySQL Database
OLTP in MySQL Database
ON in MySQL Database
online in MySQL Database
online DDL in MySQL Database
open light in MySQL Database
optimistic in MySQL Database
Optimization in MySQL Database
optimizer in MySQL Database
option in MySQL Database
option file in MySQL Database
ORDER BY in MySQL Database
overflow page in MySQL Database
P
page in MySQL Database
page cleaner in MySQL Database
page size in MySQL Database
parent table in MySQL Database
partial backup in MySQL Database
partial index in MySQL Database
partial trust in MySQL Database
Performance Schema in MySQL Database
Perl in MySQL Database
Perl API in MySQL Database
persistent statistics in MySQL Database
pessimistic in MySQL Database
phantom in MySQL Database
PHP in MySQL Database
PHP API in MySQL Database
physical in MySQL Database
physical backup in MySQL Database
PITR in MySQL Database
plan stability in MySQL Database
point-in-time recovery in MySQL Database
port in MySQL Database
prefix in MySQL Database
prepared backup in MySQL Database
prepared statement in MySQL Database
Primary Key in MySQL Database
principal in MySQL Database
Procedure in MySQL Database
process in MySQL Database
pseudo-record in MySQL Database
Pthreads in MySQL Database
purge in MySQL Database
purge buffering in MySQL Database
purge lag in MySQL Database
purge thread in MySQL Database
Python in MySQL Database
Python API in MySQL Database
Q
Query in MySQL Database
query execution plan in MySQL Database
query log in MySQL Database
quiesce in MySQL Database
R
RAID in MySQL Database
random dive in MySQL Database
raw backup in MySQL Database
RDBMS in MySQL Database
READ COMMITTED in MySQL Database
read phenomena in MySQL Database
READ UNCOMMITTED in MySQL Database
read view in MySQL Database
read-ahead in MySQL Database
read-only transaction in MySQL Database
Record in MySQL Database
record lock in MySQL Database
redo in MySQL Database
redo log in MySQL Database
redo log archiving in MySQL Database
redundant row format in MySQL Database
Referential Integrity in MySQL Database
relational in MySQL Database
relevance in MySQL Database
REPEATABLE READ in MySQL Database
repertoire in MySQL Database
replica in MySQL Database
Replication in MySQL Database
restore in MySQL Database
RIGHT JOIN in MySQL Database
Rollback in MySQL Database
rollback segment in MySQL Database
Row in MySQL Database
row format in MySQL Database
row lock in MySQL Database
row-based replication in MySQL Database
row-level locking in MySQL Database
R-tree in MySQL Database
Ruby in MySQL Database
Ruby API in MySQL Database
rw-lock in MySQL Database
S
savepoint in MySQL Database
scalability in MySQL Database
scale out in MySQL Database
scale up in MySQL Database
Scaling in MySQL Database
Schema in MySQL Database
SDI in MySQL Database
search for words or phrases in a large amount of text in MySQL Database
search index in MySQL Database
secondary index in MySQL Database
Security in MySQL Database
segment in MySQL Database
SELECT in MySQL Database
selectivity in MySQL Database
semi-consistent read in MySQL Database
SERIALIZABLE in MySQL Database
serialized dictionary information (SDI) in MySQL Database
server in MySQL Database
server-side prepared statement in MySQL Database
service principal name in MySQL Database
service ticket in MySQL Database
servlet in MySQL Database
session temporary tablespace in MySQL Database
SET in MySQL Database
shared lock in MySQL Database
shared tablespace in MySQL Database
sharp checkpoint in MySQL Database
shutdown in MySQL Database
slave in MySQL Database
Slow Query Log in MySQL Database
slow shutdown in MySQL Database
snapshot in MySQL Database
sort buffer in MySQL Database
source in MySQL Database
space ID in MySQL Database
sparse file in MySQL Database
spin in MySQL Database
SPN in MySQL Database
Spring in MySQL Database
SQL in MySQL Database
SQLState in MySQL Database
SSD in MySQL Database
SSL in MySQL Database
ST in MySQL Database
startup in MySQL Database
statement interceptor in MySQL Database
statement-based replication in MySQL Database
statistics in MySQL Database
stemming in MySQL Database
stopword in MySQL Database
storage engine in MySQL Database
storage engine tiers in MySQL Database
stored generated column in MySQL Database
stored object in MySQL Database
Stored Procedure in MySQL Database
stored program in MySQL Database
stored routine in MySQL Database
strict mode in MySQL Database
sublist in MySQL Database
Subquery in MySQL Database
supremum record in MySQL Database
surrogate key in MySQL Database
synthetic key in MySQL Database
system tablespace in MySQL Database
T
Table in MySQL Database
table lock in MySQL Database
table scan in MySQL Database
table statistics in MySQL Database
table type in MySQL Database
tablespace in MySQL Database
Tcl in MySQL Database
temporary table in MySQL Database
temporary tablespace in MySQL Database
text collection in MySQL Database
TGS in MySQL Database
TGT in MySQL Database
The SQL parser in MySQL Database
thread in MySQL Database
ticket-granting server in MySQL Database
ticket-granting ticket in MySQL Database
Tomcat in MySQL Database
torn page in MySQL Database
TPS in MySQL Database
Transaction in MySQL Database
transaction ID in MySQL Database
transparent page compression in MySQL Database
transportable tablespace in MySQL Database
Triggers in MySQL Database
troubleshooting in MySQL Database
truncate in MySQL Database
truststore in MySQL Database
tuple in MySQL Database
two-phase commit in MySQL Database
U
undo in MySQL Database
undo buffer in MySQL Database
undo log in MySQL Database
undo log segment in MySQL Database
undo tablespace in MySQL Database
Unicode in MySQL Database
UNION in MySQL Database
Unique Constraint in MySQL Database
unique index in MySQL Database
unique key in MySQL Database
UPDATE in MySQL Database
UPN in MySQL Database
user principal name in MySQL Database
V
variable-length type in MySQL Database
victim in MySQL Database
View in MySQL Database
virtual column in MySQL Database
virtual generated column in MySQL Database
virtual index in MySQL Database
Visual Studio in MySQL Database
W
wait in MySQL Database
warm backup in MySQL Database
warm up in MySQL Database
workload in MySQL Database
write combining in MySQL Database
X
XA in MySQL Database
Y
young in MySQL Database
