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/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. err_symbol The event error symbol, as a string (for example, 'ER_DUP_KEY'). An event field may be classified as core, optional, or ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
If you do use external locking option to enable updates to MyISAM tables from many MySQL processes, do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any shared tables. The ...
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. FIPS mode on the server side applies to cryptographic operations performed by the server. This includes replication (source/replica ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
To suppress logging, specify the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. It also resets the counters for key caches (default and named) to zero and sets Max_used_connections to the current number of open connections. | tables_option ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
For Group Replication, note the following key points and differences: The donor (an existing group member) and the recipient (the joining member) must have the clone plugin installed and active. The donor and the recipient must have the Group ...If ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
For example, internally generated foreign key and CHECK constraint names consist of the table name plus _ibfk_ or _chk_ and a number. The following table describes the maximum length for each type of identifier. For constraint definitions that ...
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/information-schema-tables-table.html
For ANALYZE TABLE operations that update the key distribution, failure may occur even if the operation updates the table itself (for example, if it is a MyISAM table). The information_schema_stats_expiry system variable defines the period of time ...