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/information-schema-innodb-trx-table.html
When this column and TRX_IS_READ_ONLY are both 1, InnoDB optimizes the transaction to reduce the overhead associated with transactions that change table data. The INNODB_TRX table provides information about every transaction currently executing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. From ...If the tablespace is greater than 1 extent but smaller than 32 extents in size, it is extended one extent at a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html
At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace files. The paths of discovered tablespace files are validated against the paths recorded in the data dictionary. If log_error_verbosity is set to 3, the ...If the paths do not match, the paths in the data dictionary are ...This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-logs.html
Note It is possible to encounter a concurrent transaction limit error before reaching the number of concurrent read-write transactions that InnoDB is capable of supporting. If another transaction needs to see the original data as part of a ...An ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
It specifies the directory in which files named in LOAD DATA LOCAL statements must be located. When --load-data-local-dir applies, the option value designates the directory in which local data files must be located. If the file does not exist or is ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-recovery.html
From MySQL 8.0.26, checkpoints and advancing the checkpoint LSN are not permitted until redo log recovery is complete and data dictionary dynamic metadata (srv_dict_metadata) is transferred to data dictionary table (dict_table_t) objects. If an ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
DATABASE_PAGES The number of pages in the InnoDB buffer pool containing data. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also ...Pages made “young” take longer to age out of the buffer pool, while pages made “not young” are moved much closer to the point of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
If the amount of data in an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an update operation, InnoDB attempts to merge the index page with the neighboring index page. The INNODB_INDEXES table ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
Each InnoDB table has a special index called the clustered index that stores row data. To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize ...When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered ...If there is no logical unique and non-null ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
If we regard a set of rows as a data item, the new phantom child would violate the isolation principle of transactions that a transaction should be able to run so that the data it has read does not change during the transaction. InnoDB performs ...