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/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
That is, it does not require coordination with the other members and does not have repercussions on their transactions. Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
To start, stop, and reset counters, set one of the system variables innodb_monitor_enable, innodb_monitor_disable, innodb_monitor_reset, or innodb_monitor_reset_all, using the name of the counter, the name of the module, a wildcard match for such a ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
The FLAG field provides bit level information about table format and storage characteristics. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
The combination of InnoDB tables and memcached offers advantages over using either by themselves. InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. The default settings represent a combination of high reliability and the fewest surprises for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
It can be any string of characters, with the exception of colons (:), which are not permitted. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
Presence of any string column with a maximum length larger than 512 (bytes for binary strings, characters for nonbinary strings) in the SELECT list, if UNION or UNION ALL is used. In some cases, the server creates internal temporary tables while ...