{"id":123279,"date":"2023-04-26T21:02:52","date_gmt":"2023-04-26T15:32:52","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=123279"},"modified":"2024-04-12T14:22:28","modified_gmt":"2024-04-12T08:52:28","slug":"mysql-database-glossary","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/","title":{"rendered":"MySQL Database Glossary"},"content":{"rendered":"\n

Important definitions and terminologies used in MySQL Database<\/p>\n\n\n

<\/a><\/p>\n

A<\/a>A<\/a>B<\/a>C<\/a>D<\/a>E<\/a>F<\/a>G<\/a>H<\/a>I<\/a>J<\/a>K<\/a>L<\/a>M<\/a>N<\/a>O<\/a>P<\/a>Q<\/a>R<\/a>S<\/a>T<\/a>U<\/a>V<\/a>W<\/a>X<\/a>Y<\/a><\/p>\n

A<\/a><\/strong><\/h3>\n

.ARM file in MySQL Database<\/p>\n

.ARZ file in MySQL Database<\/p>\n

.cfg file in MySQL Database<\/p>\n

.frm file in MySQL Database<\/p>\n

.ibd file in MySQL Database<\/p>\n

.ibz file in MySQL Database<\/p>\n

.MRG file in MySQL Database<\/p>\n

.MYD file in MySQL Database<\/p>\n

.MYI file in MySQL Database<\/p>\n

.NET in MySQL Database<\/p>\n

.OPT file in MySQL Database<\/p>\n

.par file in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

A<\/a><\/strong><\/h3>\n

ACID in MySQL Database<\/p>\n

adaptive flushing in MySQL Database<\/p>\n

adaptive hash index in MySQL Database<\/p>\n

ADO.NET in MySQL Database<\/p>\n

Aggregate Function in MySQL Database<\/p>\n

AIO in MySQL Database<\/p>\n

Alias in MySQL Database<\/p>\n

ALTER in MySQL Database<\/p>\n

ANSI in MySQL Database<\/p>\n

API in MySQL Database<\/p>\n

application programming interface (API) in MySQL Database<\/p>\n

apply in MySQL Database<\/p>\n

AS in MySQL Database<\/p>\n

ASCII in MySQL Database<\/p>\n

ASP.net in MySQL Database<\/p>\n

assembly in MySQL Database<\/p>\n

asynchronous I\/O in MySQL Database<\/p>\n

atomic in MySQL Database<\/p>\n

atomic DDL in MySQL Database<\/p>\n

atomic instruction in MySQL Database<\/p>\n

authentication server in MySQL Database<\/p>\n

autocommit in MySQL Database<\/p>\n

auto-increment in MySQL Database<\/p>\n

auto-increment locking in MySQL Database<\/p>\n

availability in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

B<\/a><\/strong><\/h3>\n

backticks in MySQL Database<\/p>\n

Backup in MySQL Database<\/p>\n

Backup and Recovery in MySQL Database<\/p>\n

base column in MySQL Database<\/p>\n

beta in MySQL Database<\/p>\n

Binary and textual backups in MySQL Database<\/p>\n

binary log in MySQL Database<\/p>\n

binlog in MySQL Database<\/p>\n

blind query expansion in MySQL Database<\/p>\n

BLOB in MySQL Database<\/p>\n

Boolean in MySQL Database<\/p>\n

bottleneck in MySQL Database<\/p>\n

bounce in MySQL Database<\/p>\n

B-tree in MySQL Database<\/p>\n

buddy allocator in MySQL Database<\/p>\n

Buffer in MySQL Database<\/p>\n

buffer pool in MySQL Database<\/p>\n

buffer pool instance in MySQL Database<\/p>\n

built-in in MySQL Database<\/p>\n

business rules in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

C<\/a><\/strong><\/h3>\n

C API in MySQL Database<\/p>\n

C# in MySQL Database<\/p>\n

C++ in MySQL Database<\/p>\n

cache in MySQL Database<\/p>\n

cardinality in MySQL Database<\/p>\n

Cascade in MySQL Database<\/p>\n

CAST in MySQL Database<\/p>\n

change buffer in MySQL Database<\/p>\n

change buffering in MySQL Database<\/p>\n

CHAR in MySQL Database<\/p>\n

CHECK in MySQL Database<\/p>\n

checkpoint in MySQL Database<\/p>\n

checksum in MySQL Database<\/p>\n

child table in MySQL Database<\/p>\n

clean page in MySQL Database<\/p>\n

clean shutdown in MySQL Database<\/p>\n

Client in MySQL Database<\/p>\n

client libraries in MySQL Database<\/p>\n

Client Programs in MySQL Database<\/p>\n

Client\/Server in MySQL Database<\/p>\n

client-side prepared statement in MySQL Database<\/p>\n

CLOB in MySQL Database<\/p>\n

Clustered Index in MySQL Database<\/p>\n

cold backup in MySQL Database<\/p>\n

COLLATE in MySQL Database<\/p>\n

Column in MySQL Database<\/p>\n

column index in MySQL Database<\/p>\n

column prefix in MySQL Database<\/p>\n

command interceptor in MySQL Database<\/p>\n

COMMIT in MySQL Database<\/p>\n

compact row format in MySQL Database<\/p>\n

composite index in MySQL Database<\/p>\n

Composite Key in MySQL Database<\/p>\n

compressed backup in MySQL Database<\/p>\n

compressed row format in MySQL Database<\/p>\n

compressed table in MySQL Database<\/p>\n

compression in MySQL Database<\/p>\n

compression failure in MySQL Database<\/p>\n

concatenated index in MySQL Database<\/p>\n

concurrency in MySQL Database<\/p>\n

configuration file in MySQL Database<\/p>\n

connection in MySQL Database<\/p>\n

connection pool in MySQL Database<\/p>\n

connection string in MySQL Database<\/p>\n

connector in MySQL Database<\/p>\n

Connector\/C++ in MySQL Database<\/p>\n

Connector\/J in MySQL Database<\/p>\n

Connector\/NET in MySQL Database<\/p>\n

Connector\/ODBC in MySQL Database<\/p>\n

Connector\/PHP in MySQL Database<\/p>\n

consistent read in MySQL Database<\/p>\n

CONSTRAINT in MySQL Database<\/p>\n

Constraints in MySQL Database<\/p>\n

counter in MySQL Database<\/p>\n

covering index in MySQL Database<\/p>\n

CPU-bound in MySQL Database<\/p>\n

crash in MySQL Database<\/p>\n

crash recovery in MySQL Database<\/p>\n

CRUD in MySQL Database<\/p>\n

Cursor in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

D<\/a><\/strong><\/h3>\n

Data Definition in MySQL Database<\/p>\n

data definition language in MySQL Database<\/p>\n

Data Definition Language (DDL) in MySQL Database<\/p>\n

data dictionary in MySQL Database<\/p>\n

data directory in MySQL Database<\/p>\n

data files in MySQL Database<\/p>\n

data manipulation language in MySQL Database<\/p>\n

Data Manipulation Language (DML) in MySQL Database<\/p>\n

data recovery in MySQL Database<\/p>\n

Data Type in MySQL Database<\/p>\n

Data types in MySQL Database<\/p>\n

data warehouse in MySQL Database<\/p>\n

Database in MySQL Database<\/p>\n

Database Management System (DBMS) in MySQL Database<\/p>\n

Datetime in MySQL Database<\/p>\n

DCL in MySQL Database<\/p>\n

DDEX provider in MySQL Database<\/p>\n

DDL in MySQL Database<\/p>\n

Deadlock in MySQL Database<\/p>\n

deadlock detection in MySQL Database<\/p>\n

Default in MySQL Database<\/p>\n

DELETE in MySQL Database<\/p>\n

delete buffering in MySQL Database<\/p>\n

Denormalization in MySQL Database<\/p>\n

denormalized in MySQL Database<\/p>\n

descending index in MySQL Database<\/p>\n

dictionary object cache in MySQL Database<\/p>\n

dirty page in MySQL Database<\/p>\n

dirty read in MySQL Database<\/p>\n

disk-based in MySQL Database<\/p>\n

disk-bound in MySQL Database<\/p>\n

DISTINCT in MySQL Database<\/p>\n

DML in MySQL Database<\/p>\n

document id in MySQL Database<\/p>\n

doublewrite buffer in MySQL Database<\/p>\n

DROP in MySQL Database<\/p>\n

DSN in MySQL Database<\/p>\n

dynamic cursor in MySQL Database<\/p>\n

dynamic row format in MySQL Database<\/p>\n

dynamic SQL in MySQL Database<\/p>\n

dynamic statement in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

E<\/a><\/strong><\/h3>\n

early adopter in MySQL Database<\/p>\n

Eiffel in MySQL Database<\/p>\n

embedded in MySQL Database<\/p>\n

Entity in MySQL Database<\/p>\n

ERD in MySQL Database<\/p>\n

Error Handling in MySQL Database<\/p>\n

Error Log in MySQL Database<\/p>\n

Error Log in MySQL Database<\/p>\n

Escape Character in MySQL Database<\/p>\n

Event in MySQL Database<\/p>\n

eviction in MySQL Database<\/p>\n

exception interceptor in MySQL Database<\/p>\n

exclusive lock in MySQL Database<\/p>\n

EXISTS in MySQL Database<\/p>\n

Explicit table and advisory locking in MySQL Database<\/p>\n

Export in MySQL Database<\/p>\n

Expressions and joining in MySQL Database<\/p>\n

extent in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

F<\/a><\/strong><\/h3>\n

failover in MySQL Database<\/p>\n

Fast Index Creation in MySQL Database<\/p>\n

fast shutdown in MySQL Database<\/p>\n

Field in MySQL Database<\/p>\n

file format in MySQL Database<\/p>\n

Filegroup in MySQL Database<\/p>\n

file-per-table in MySQL Database<\/p>\n

fill factor in MySQL Database<\/p>\n

fixed row format in MySQL Database<\/p>\n

Float in MySQL Database<\/p>\n

flush in MySQL Database<\/p>\n

flush list in MySQL Database<\/p>\n

Foreign Key in MySQL Database<\/p>\n

FOREIGN KEY constraint in MySQL Database<\/p>\n

FTS in MySQL Database<\/p>\n

full backup in MySQL Database<\/p>\n

full table scan in MySQL Database<\/p>\n

FULLTEXT index in MySQL Database<\/p>\n

Full-Text Search in MySQL Database<\/p>\n

fuzzy checkpointing in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

G<\/a><\/strong><\/h3>\n

GA in MySQL Database<\/p>\n

GAC in MySQL Database<\/p>\n

gap in MySQL Database<\/p>\n

gap lock in MySQL Database<\/p>\n

general log in MySQL Database<\/p>\n

general query log in MySQL Database<\/p>\n

general tablespace in MySQL Database<\/p>\n

generated column in MySQL Database<\/p>\n

generated stored column in MySQL Database<\/p>\n

generated virtual column in MySQL Database<\/p>\n

Glassfish in MySQL Database<\/p>\n

global temporary tablespace in MySQL Database<\/p>\n

global transaction in MySQL Database<\/p>\n

GROUP BY in MySQL Database<\/p>\n

group commit in MySQL Database<\/p>\n

Grouping and aggregate functions in MySQL Database<\/p>\n

GUI in MySQL Database<\/p>\n

GUID in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

H<\/a><\/strong><\/h3>\n

hash index in MySQL Database<\/p>\n

HAVING in MySQL Database<\/p>\n

HDD in MySQL Database<\/p>\n

heartbeat in MySQL Database<\/p>\n

high-water mark in MySQL Database<\/p>\n

history list in MySQL Database<\/p>\n

hole punching in MySQL Database<\/p>\n

host in MySQL Database<\/p>\n

hot in MySQL Database<\/p>\n

hot backup in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

I<\/a><\/strong><\/h3>\n

I\/O-bound in MySQL Database<\/p>\n

ib_logfile in MySQL Database<\/p>\n

ibbackup_logfile in MySQL Database<\/p>\n

ibdata file in MySQL Database<\/p>\n

ib-file set in MySQL Database<\/p>\n

ibtmp file in MySQL Database<\/p>\n

ilist in MySQL Database<\/p>\n

implicit row lock in MySQL Database<\/p>\n

incremental backup in MySQL Database<\/p>\n

Index in MySQL Database<\/p>\n

index cache in MySQL Database<\/p>\n

index condition pushdown in MySQL Database<\/p>\n

index hint in MySQL Database<\/p>\n

index prefix in MySQL Database<\/p>\n

index statistics in MySQL Database<\/p>\n

indexes in MySQL Database<\/p>\n

infimum record in MySQL Database<\/p>\n

INFORMATION_SCHEMA in MySQL Database<\/p>\n

in-memory database in MySQL Database<\/p>\n

Inner Join in MySQL Database<\/p>\n

InnoDB in MySQL Database<\/p>\n

InnoDB, merge, innodb, memory, federated and cluster storage in MySQL Database<\/p>\n

innodb_autoinc_lock_mode in MySQL Database<\/p>\n

innodb_file_per_table in MySQL Database<\/p>\n

innodb_lock_wait_timeout in MySQL Database<\/p>\n

innodb_strict_mode in MySQL Database<\/p>\n

INSERT in MySQL Database<\/p>\n

insert buffer in MySQL Database<\/p>\n

insert buffering in MySQL Database<\/p>\n

insert intention lock in MySQL Database<\/p>\n

instance in MySQL Database<\/p>\n

instrumentation in MySQL Database<\/p>\n

INT in MySQL Database<\/p>\n

Integrity Constraints in MySQL Database<\/p>\n

intention exclusive lock in MySQL Database<\/p>\n

intention lock in MySQL Database<\/p>\n

intention shared lock in MySQL Database<\/p>\n

interceptor in MySQL Database<\/p>\n

intrinsic temporary table in MySQL Database<\/p>\n

inverted index in MySQL Database<\/p>\n

IOPS in MySQL Database<\/p>\n

Isolation Level in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

J<\/a><\/strong><\/h3>\n

J2EE in MySQL Database<\/p>\n

Java in MySQL Database<\/p>\n

JBoss in MySQL Database<\/p>\n

JDBC in MySQL Database<\/p>\n

JNDI in MySQL Database<\/p>\n

Join in MySQL Database<\/p>\n

JSON in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

K<\/a><\/strong><\/h3>\n

KDC in MySQL Database<\/p>\n

Key in MySQL Database<\/p>\n

key distribution center in MySQL Database<\/p>\n

KEY_BLOCK_SIZE in MySQL Database<\/p>\n

keystore in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

L<\/a><\/strong><\/h3>\n

latch in MySQL Database<\/p>\n

LEFT JOIN in MySQL Database<\/p>\n

libmysql in MySQL Database<\/p>\n

libmysqlclient in MySQL Database<\/p>\n

libmysqld in MySQL Database<\/p>\n

lifecycle interceptor in MySQL Database<\/p>\n

LIKE in MySQL Database<\/p>\n

list in MySQL Database<\/p>\n

load balancing in MySQL Database<\/p>\n

localhost in MySQL Database<\/p>\n

Lock in MySQL Database<\/p>\n

lock escalation in MySQL Database<\/p>\n

lock mode in MySQL Database<\/p>\n

Locking in MySQL Database<\/p>\n

locking read in MySQL Database<\/p>\n

log in MySQL Database<\/p>\n

Log and status files in MySQL Database<\/p>\n

log buffer in MySQL Database<\/p>\n

log file in MySQL Database<\/p>\n

log group in MySQL Database<\/p>\n

logical in MySQL Database<\/p>\n

logical backup in MySQL Database<\/p>\n

Logical Operator in MySQL Database<\/p>\n

loose_ in MySQL Database<\/p>\n

low-water mark in MySQL Database<\/p>\n

LRU in MySQL Database<\/p>\n

LSN in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

M<\/a><\/strong><\/h3>\n

master in MySQL Database<\/p>\n

master thread in MySQL Database<\/p>\n

MDL in MySQL Database<\/p>\n

medium trust in MySQL Database<\/p>\n

memcached in MySQL Database<\/p>\n

merge in MySQL Database<\/p>\n

Metadata in MySQL Database<\/p>\n

metadata lock in MySQL Database<\/p>\n

metrics counter in MySQL Database<\/p>\n

midpoint insertion strategy in MySQL Database<\/p>\n

mini-transaction in MySQL Database<\/p>\n

mixed-mode insert in MySQL Database<\/p>\n

MM.MySQL in MySQL Database<\/p>\n

Mono in MySQL Database<\/p>\n

more in MySQL Database<\/p>\n

mtr in MySQL Database<\/p>\n

multi-core in MySQL Database<\/p>\n

Multiple Servers in MySQL Database<\/p>\n

multiversion concurrency control in MySQL Database<\/p>\n

mutex in MySQL Database<\/p>\n

MVCC in MySQL Database<\/p>\n

my.cnf in MySQL Database<\/p>\n

my.ini in MySQL Database<\/p>\n

MyODBC drivers in MySQL Database<\/p>\n

mysql in MySQL Database<\/p>\n

MySQL Architecture in MySQL Database<\/p>\n

mysql cluster in MySQL Database<\/p>\n

MySQL distributions in MySQL Database<\/p>\n

MySQL Enterprise Backup in MySQL Database<\/p>\n

MySQL Service in MySQL Database<\/p>\n

MySQL storage engines in MySQL Database<\/p>\n

mysqladmin in MySQL Database<\/p>\n

mysqlbackup command in MySQL Database<\/p>\n

mysqlclient in MySQL Database<\/p>\n

mysqld in MySQL Database<\/p>\n

MySQLdb in MySQL Database<\/p>\n

mysqldump in MySQL Database<\/p>\n

mysqlimport in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

N<\/a><\/strong><\/h3>\n

N\/A in MySQL Database<\/p>\n

native C API in MySQL Database<\/p>\n

natural key in MySQL Database<\/p>\n

neighbor page in MySQL Database<\/p>\n

next-key lock in MySQL Database<\/p>\n

nonblocking I\/O in MySQL Database<\/p>\n

non-locking read in MySQL Database<\/p>\n

non-repeatable read in MySQL Database<\/p>\n

normalized in MySQL Database<\/p>\n

NoSQL in MySQL Database<\/p>\n

NOT NULL in MySQL Database<\/p>\n

NOT NULL constraint in MySQL Database<\/p>\n

NULL in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

O<\/a><\/strong><\/h3>\n

ODBC in MySQL Database<\/p>\n

off-page column in MySQL Database<\/p>\n

OLTP in MySQL Database<\/p>\n

ON in MySQL Database<\/p>\n

online in MySQL Database<\/p>\n

online DDL in MySQL Database<\/p>\n

open light in MySQL Database<\/p>\n

optimistic in MySQL Database<\/p>\n

Optimization in MySQL Database<\/p>\n

optimizer in MySQL Database<\/p>\n

option in MySQL Database<\/p>\n

option file in MySQL Database<\/p>\n

ORDER BY in MySQL Database<\/p>\n

overflow page in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

P<\/a><\/strong><\/h3>\n

page in MySQL Database<\/p>\n

page cleaner in MySQL Database<\/p>\n

page size in MySQL Database<\/p>\n

parent table in MySQL Database<\/p>\n

partial backup in MySQL Database<\/p>\n

partial index in MySQL Database<\/p>\n

partial trust in MySQL Database<\/p>\n

Performance Schema in MySQL Database<\/p>\n

Perl in MySQL Database<\/p>\n

Perl API in MySQL Database<\/p>\n

persistent statistics in MySQL Database<\/p>\n

pessimistic in MySQL Database<\/p>\n

phantom in MySQL Database<\/p>\n

PHP in MySQL Database<\/p>\n

PHP API in MySQL Database<\/p>\n

physical in MySQL Database<\/p>\n

physical backup in MySQL Database<\/p>\n

PITR in MySQL Database<\/p>\n

plan stability in MySQL Database<\/p>\n

point-in-time recovery in MySQL Database<\/p>\n

port in MySQL Database<\/p>\n

prefix in MySQL Database<\/p>\n

prepared backup in MySQL Database<\/p>\n

prepared statement in MySQL Database<\/p>\n

Primary Key in MySQL Database<\/p>\n

principal in MySQL Database<\/p>\n

Procedure in MySQL Database<\/p>\n

process in MySQL Database<\/p>\n

pseudo-record in MySQL Database<\/p>\n

Pthreads in MySQL Database<\/p>\n

purge in MySQL Database<\/p>\n

purge buffering in MySQL Database<\/p>\n

purge lag in MySQL Database<\/p>\n

purge thread in MySQL Database<\/p>\n

Python in MySQL Database<\/p>\n

Python API in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

Q<\/a><\/strong><\/h3>\n

Query in MySQL Database<\/p>\n

query execution plan in MySQL Database<\/p>\n

query log in MySQL Database<\/p>\n

quiesce in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

R<\/a><\/strong><\/h3>\n

RAID in MySQL Database<\/p>\n

random dive in MySQL Database<\/p>\n

raw backup in MySQL Database<\/p>\n

RDBMS in MySQL Database<\/p>\n

READ COMMITTED in MySQL Database<\/p>\n

read phenomena in MySQL Database<\/p>\n

READ UNCOMMITTED in MySQL Database<\/p>\n

read view in MySQL Database<\/p>\n

read-ahead in MySQL Database<\/p>\n

read-only transaction in MySQL Database<\/p>\n

Record in MySQL Database<\/p>\n

record lock in MySQL Database<\/p>\n

redo in MySQL Database<\/p>\n

redo log in MySQL Database<\/p>\n

redo log archiving in MySQL Database<\/p>\n

redundant row format in MySQL Database<\/p>\n

Referential Integrity in MySQL Database<\/p>\n

relational in MySQL Database<\/p>\n

relevance in MySQL Database<\/p>\n

REPEATABLE READ in MySQL Database<\/p>\n

repertoire in MySQL Database<\/p>\n

replica in MySQL Database<\/p>\n

Replication in MySQL Database<\/p>\n

restore in MySQL Database<\/p>\n

RIGHT JOIN in MySQL Database<\/p>\n

Rollback in MySQL Database<\/p>\n

rollback segment in MySQL Database<\/p>\n

Row in MySQL Database<\/p>\n

row format in MySQL Database<\/p>\n

row lock in MySQL Database<\/p>\n

row-based replication in MySQL Database<\/p>\n

row-level locking in MySQL Database<\/p>\n

R-tree in MySQL Database<\/p>\n

Ruby in MySQL Database<\/p>\n

Ruby API in MySQL Database<\/p>\n

rw-lock in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

S<\/a><\/strong><\/h3>\n

savepoint in MySQL Database<\/p>\n

scalability in MySQL Database<\/p>\n

scale out in MySQL Database<\/p>\n

scale up in MySQL Database<\/p>\n

Scaling in MySQL Database<\/p>\n

Schema in MySQL Database<\/p>\n

SDI in MySQL Database<\/p>\n

search for words or phrases in a large amount of text in MySQL Database<\/p>\n

search index in MySQL Database<\/p>\n

secondary index in MySQL Database<\/p>\n

Security in MySQL Database<\/p>\n

segment in MySQL Database<\/p>\n

SELECT in MySQL Database<\/p>\n

selectivity in MySQL Database<\/p>\n

semi-consistent read in MySQL Database<\/p>\n

SERIALIZABLE in MySQL Database<\/p>\n

serialized dictionary information (SDI) in MySQL Database<\/p>\n

server in MySQL Database<\/p>\n

server-side prepared statement in MySQL Database<\/p>\n

service principal name in MySQL Database<\/p>\n

service ticket in MySQL Database<\/p>\n

servlet in MySQL Database<\/p>\n

session temporary tablespace in MySQL Database<\/p>\n

SET in MySQL Database<\/p>\n

shared lock in MySQL Database<\/p>\n

shared tablespace in MySQL Database<\/p>\n

sharp checkpoint in MySQL Database<\/p>\n

shutdown in MySQL Database<\/p>\n

slave in MySQL Database<\/p>\n

Slow Query Log in MySQL Database<\/p>\n

slow shutdown in MySQL Database<\/p>\n

snapshot in MySQL Database<\/p>\n

sort buffer in MySQL Database<\/p>\n

source in MySQL Database<\/p>\n

space ID in MySQL Database<\/p>\n

sparse file in MySQL Database<\/p>\n

spin in MySQL Database<\/p>\n

SPN in MySQL Database<\/p>\n

Spring in MySQL Database<\/p>\n

SQL in MySQL Database<\/p>\n

SQLState in MySQL Database<\/p>\n

SSD in MySQL Database<\/p>\n

SSL in MySQL Database<\/p>\n

ST in MySQL Database<\/p>\n

startup in MySQL Database<\/p>\n

statement interceptor in MySQL Database<\/p>\n

statement-based replication in MySQL Database<\/p>\n

statistics in MySQL Database<\/p>\n

stemming in MySQL Database<\/p>\n

stopword in MySQL Database<\/p>\n

storage engine in MySQL Database<\/p>\n

storage engine tiers in MySQL Database<\/p>\n

stored generated column in MySQL Database<\/p>\n

stored object in MySQL Database<\/p>\n

Stored Procedure in MySQL Database<\/p>\n

stored program in MySQL Database<\/p>\n

stored routine in MySQL Database<\/p>\n

strict mode in MySQL Database<\/p>\n

sublist in MySQL Database<\/p>\n

Subquery in MySQL Database<\/p>\n

supremum record in MySQL Database<\/p>\n

surrogate key in MySQL Database<\/p>\n

synthetic key in MySQL Database<\/p>\n

system tablespace in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

T<\/a><\/strong><\/h3>\n

Table in MySQL Database<\/p>\n

table lock in MySQL Database<\/p>\n

table scan in MySQL Database<\/p>\n

table statistics in MySQL Database<\/p>\n

table type in MySQL Database<\/p>\n

tablespace in MySQL Database<\/p>\n

Tcl in MySQL Database<\/p>\n

temporary table in MySQL Database<\/p>\n

temporary tablespace in MySQL Database<\/p>\n

text collection in MySQL Database<\/p>\n

TGS in MySQL Database<\/p>\n

TGT in MySQL Database<\/p>\n

The SQL parser in MySQL Database<\/p>\n

thread in MySQL Database<\/p>\n

ticket-granting server in MySQL Database<\/p>\n

ticket-granting ticket in MySQL Database<\/p>\n

Tomcat in MySQL Database<\/p>\n

torn page in MySQL Database<\/p>\n

TPS in MySQL Database<\/p>\n

Transaction in MySQL Database<\/p>\n

transaction ID in MySQL Database<\/p>\n

transparent page compression in MySQL Database<\/p>\n

transportable tablespace in MySQL Database<\/p>\n

Triggers in MySQL Database<\/p>\n

troubleshooting in MySQL Database<\/p>\n

truncate in MySQL Database<\/p>\n

truststore in MySQL Database<\/p>\n

tuple in MySQL Database<\/p>\n

two-phase commit in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

U<\/a><\/strong><\/h3>\n

undo in MySQL Database<\/p>\n

undo buffer in MySQL Database<\/p>\n

undo log in MySQL Database<\/p>\n

undo log segment in MySQL Database<\/p>\n

undo tablespace in MySQL Database<\/p>\n

Unicode in MySQL Database<\/p>\n

UNION in MySQL Database<\/p>\n

Unique Constraint in MySQL Database<\/p>\n

unique index in MySQL Database<\/p>\n

unique key in MySQL Database<\/p>\n

UPDATE in MySQL Database<\/p>\n

UPN in MySQL Database<\/p>\n

user principal name in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

V<\/a><\/strong><\/h3>\n

variable-length type in MySQL Database<\/p>\n

victim in MySQL Database<\/p>\n

View in MySQL Database<\/p>\n

virtual column in MySQL Database<\/p>\n

virtual generated column in MySQL Database<\/p>\n

virtual index in MySQL Database<\/p>\n

Visual Studio in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

W<\/a><\/strong><\/h3>\n

wait in MySQL Database<\/p>\n

warm backup in MySQL Database<\/p>\n

warm up in MySQL Database<\/p>\n

workload in MySQL Database<\/p>\n

write combining in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

X<\/a><\/strong><\/h3>\n

XA in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>

Y<\/a><\/strong><\/h3>\n

young in MySQL Database<\/p>\n

Go to Top<\/a><\/p>\n

<\/p>","protected":false},"excerpt":{"rendered":"

Important definitions and terminologies used in MySQL Database AABCDEFGHIJKLMNOPQRSTUVWXY 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…<\/p>\n","protected":false},"author":10,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[284],"tags":[],"class_list":["post-123279","page","type-page","status-publish","hentry","category-mysql-db-administrator"],"acf":[],"yoast_head":"\nMySQL Database Glossary - Tutorial<\/title>\n<meta name=\"description\" content=\"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Database Glossary - Tutorial\" \/>\n<meta property=\"og:description\" content=\"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:52:28+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/\",\"name\":\"MySQL Database Glossary - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-04-26T15:32:52+00:00\",\"dateModified\":\"2024-04-12T08:52:28+00:00\",\"description\":\"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Database Glossary\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Database Glossary - Tutorial","description":"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Database Glossary - Tutorial","og_description":"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:52:28+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/","name":"MySQL Database Glossary - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-04-26T15:32:52+00:00","dateModified":"2024-04-12T08:52:28+00:00","description":"What is MySQL Database? MySQL Database glossary page lists important terms, terminologies and definitions in MySQL Database listed with brief details. Enrich your knowledge and skills in MySQL Database","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/mysql-database-glossary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"MySQL Database Glossary"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/123279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=123279"}],"version-history":[{"count":3,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/123279\/revisions"}],"predecessor-version":[{"id":123391,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/123279\/revisions\/123391"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=123279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=123279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=123279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}