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/group-replication-server-states.html
The state of a Group Replication group member shows its current role in the group. The Performance Schema table replication_group_members shows the state for each member in a group. If the group is fully functional and all members are communicating ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup-recovery.html
For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section 17.18.2, “InnoDB Recovery”. This section covers topics related to InnoDB backup and recovery. For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...INNODB_CMPMEM and INNODB_CMPMEM_RESET provide information about the way memory is allocated for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-linux-native-aio.html
With synchronous I/O, query threads queue I/O requests, and InnoDB background threads retrieve the queued requests one at a time, issuing a synchronous I/O call for each. InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
If the specific changes were different each time, you might have to construct a new complex ALTER TABLE for each slightly different scenario. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read view. InnoDB can avoid the overhead associated with setting up the transaction ID ...
https://dev.mysql.com/doc/refman/8.0/en/json-functions.html
The precise outcome of the sort is subject to change at any time; do not rely on it to be consistent between releases. The functions described in this section perform operations on JSON values. For discussion of the JSON data type and additional ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-check.html
This may take a long time for a large table that has many indexes. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. What it cannot find is corruption that involves only the data file (which is ...