PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is disabled within a session with SET autocommit = 0, the session always has a transaction ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-spin_lock_polling.html
That number is generated by randomly selecting an integer ranging from 0 up to but not including the innodb_spin_wait_delay value, and multiplying that value by 50. An innodb_spin_wait_delay setting of 5 results in a set of five possible values ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
In addition, if --ndb-nodeid is used, then either a matching node ID must be found in a [mysqld] or [api] section of config.ini, or there must be an “open” [mysqld] or [api] section in the file (that is, a section without a NodeId or Id ...For ...For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. When you issue a consistent read (that is, an ordinary SELECT statement), InnoDB gives your transaction a timepoint ...If ...The query sees the changes made by transactions that committed before that point in time, and no changes made by later or uncommitted ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
For InnoDB and MyISAM tables, you have some control over collection of table statistics by means of the innodb_stats_method and myisam_stats_method system variables, respectively. The innodb_stats_method system variable has a global value; the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The adaptive ...Based on the observed pattern of searches, a hash index is built using a prefix of the index ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Running SHOW TABLE STATUS, SHOW INDEX, or querying the Information Schema TABLES or STATISTICS tables with the innodb_stats_on_metadata option enabled. Optimizer statistics are persisted to disk by default, enabled by the innodb_stats_persistent ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. Note Prior to MySQL 8.0.20, InnoDB also uses a First In First Out (FIFO) algorithm to schedule transactions, and the ...