MySQL基本概念

ACID（An acronym standing for atomicity,consistency,isolation,and durability）

这是一个与InnoDB之事务（transaction）紧密相关的概念，使其遵循这一原则。

 

buffer

innodb_flush_log_at_trx_commit

innodb_log_file_size=48M

LRU

pages

 

commit

 It is the opposite of rollback, which undoes any changes made in the transaction.

rollback

concurrency

The ability of multiple operations (in database terminology, transactions) to run simultaneously, without interfering with each other.

crash

crash recovery

data dictionary

Metadata that keeps track of database objects such as tables, indexes, and table columns.

 

CRUD

Acronym for “create, read, update, delete”, a common sequence of operations in database applications. 

data dictionary

Metadata that keeps track of database objects such as tables, indexes, and table columns. 

DCL

Data control language, a set of SQL statements for managing privileges. In MySQL, consists of the GRANT and REVOKE statements. Contrast with DDL and DML.

DDL

Data definition language, a set of SQL statements for manipulating the database itself rather than individual table rows.Includes all forms of the CREATE, ALTER, and DROPstatements.

deadlock

A situation where different transactions are unable to proceed, because each holds a lock that the other needs. Because both transactions are waiting for a resource to become available, neither will ever release the locks it holds.

dirty page

A page in the InnoDB buffer pool that has been updated in memory, where the changes are not yet written (flushed) to the data files. The opposite of a clean page.

clean page

A page in the InnoDB buffer pool where all changes made in memory have also been written (flushed) to the data files. The opposite of a dirty page.

early adopter
A stage similar to beta, when a software product is typically evaluated for performance, functionality, and compatibility in a non-mission-critical setting.

See Also beta.

eviction

The process of removing an item from a cache or other temporary storage area, such as the InnoDB buffer pool.

exclusive lock

A kind of lock that prevents any other transaction from locking the same row.

extent

A group of pages within a tablespace. For the default page size of 16KB, an extent contains 64 pages.

Fast Index Creation

A capability first introduced in the InnoDB Plugin, now part of MySQL in 5.5 and higher, that speeds up creation of InnoDB secondary indexes by avoiding the need to completely rewrite the associated table. The speedup applies to dropping secondary indexes also.

fast shutdown

The default shutdown procedure for InnoDB, based on the configuration setting innodb_fast_shutdown=1. 

file-per-table

A general name for the setting controlled by the innodb_file_per_table option, which is an important configuration option that affects aspects of InnoDB file storage, availability of features, and I/O characteristics.

fixed row format

This row format is used by the MyISAM storage engine, not by InnoDB.

foreign key

A type of pointer relationship, between rows in separate InnoDB tables. The foreign key relationship is defined on one column in both the parent table and the child table.

FTS

In most contexts, an acronym for full-text search. Sometimes in performance discussions, an acronym for full table scan.