PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-midpoint_insertion.html
Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed again. Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table data in primary key order. The ...
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/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-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/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/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. Use the ...Session temporary tablespaces are recreated each time the server is ...A ...