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/server-options.html
For a sufficiently high value of --log-error-verbosity, it also logs a note with a streamlined table definition listing only those expressions that potentially contain SQL functions. Note This must be the first option on the command line if it is ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
If the clause is not given, or a symbol is not included following the CONSTRAINT keyword, MySQL automatically generates a constraint name, with the exception noted below. Note If the CONSTRAINT symbol clause is not given in a foreign key definition, ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group Replication. Note that tables without PK can cause performance problems in row-based replication, so please consult ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. Note On Microsoft Windows, the server plugin for SASL-based LDAP authentication is not supported, but the client plugin is supported.
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Note Due to a known limitation, Created_tmp_disk_tables does not count on-disk temporary tables created in memory-mapped files. For notes about the relationship between this status variable and its corresponding system variable, see the description ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
Table 15.1 Index Types Per Storage Engine Storage Engine Permissible Index Types InnoDB BTREE MyISAM BTREE MEMORY/HEAP HASH, BTREE NDB HASH, BTREE (see note in text) The index_type clause cannot be used for FULLTEXT INDEX or (prior to MySQL 8.0.12) ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Before running CHECK TABLE on InnoDB tables, see CHECK TABLE Usage Notes for InnoDB Tables. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
However, note that the variable is not intended for users to set; it is set automatically by the replication infrastructure. Note that when a release number is set by the original server, the value of the variable is reset to 0 if the immediate ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
Note For JSON-format log files, rotation also occurs when the value of the audit_log_format_unix_timestamp system variable is changed at runtime. Note If compression or encryption are enabled, log file names include suffixes that signify the enabled ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...