This glossary originated as a reference for terminology about the Inno DB storage engine, and the majority of definitions are Inno DB-related. When a transaction makes multiple changes to the database, either all the changes succeed when the transaction is committed, or all the changes are undone when the transaction is rolled back.The database remains in a consistent state at all times — after each commit or rollback, and while transactions are in progress.This isolation is achieved through the , when they can be sure that the transactions really do not interfere with each other.
The adaptive flushing algorithm extends this process by estimating the optimal rate to perform these periodic flushes, based on the rate of flushing and how fast that are frequently accessed.
In a sense, the adaptive hash index configures My SQL at runtime to take advantage of ample main memory, coming closer to the architecture of main-memory databases. My SQL can build a hash index on a prefix of any length of the key defined for the B-tree, depending on the pattern of searches against the index.
Durability typically involves writing to disk storage, with a certain amount of redundancy to protect against power failures or software crashes during write operations.
(In at once, My SQL periodically flushes small sets of modified pages.
If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new values.
Transactions are protected (isolated) from each other while they are in progress; they cannot interfere with each other or see each other's uncommitted data.