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/information-schema-tables-extensions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. The TABLES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
This mode of operation might be unfamiliar if you have experience with other database systems, where it is standard practice to issue a sequence of DML statements and commit them or roll them back all together. If autocommit mode is enabled, each ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
Limiting Buffer Flushing During Idle Periods As of MySQL 8.0.18, you can use the innodb_idle_flush_pct variable to limit the rate of buffer pool flushing during idle periods, which are periods of time that database pages are not modified. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Excluding buffer pool pages may also be desirable from a security perspective if you have concerns about dumping database pages to core files that may be shared inside or outside of your organization for debugging purposes. A core file records the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
On disk, the change buffer is part of the system tablespace, where index changes are buffered when the database server is shut down. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU utilization. Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 10.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
The mysql system tablespace contains the mysql system database and MySQL data dictionary tables. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo logs. As ...