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/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +--------------+---------------------+ | VERSION() | sys.version_major() | +--------------+---------------------+ | 8.0.26-debug | 8 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +--------------+---------------------+ | VERSION() | sys.version_minor() | +--------------+---------------------+ | 8.0.26-debug | 0 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
To persist a global system variable to the mysqld-auto.cnf file (and set the runtime value), use the SET PERSIST statement, which requires the SYSTEM_VARIABLES_ADMIN or SUPER privilege. To persist a global system variable to the mysqld-auto.cnf file ...(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent ...
https://dev.mysql.com/doc/refman/8.0/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...
https://dev.mysql.com/doc/refman/8.0/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-restrictions.html
MySQL does not support these window function features: DISTINCT syntax for aggregate window functions. As of MySQL 8.0.28, a maximum of 127 windows is supported for a given SELECT. The SQL standard imposes a constraint on window functions that they ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-sha2-cache-plugin.html
X Plugin supports MySQL user accounts created with the caching_sha2_password authentication plugin. The X Plugin authentication cache is maintained by the mysqlx_cache_cleaner plugin, which is enabled by default, and has no related system variables ...For more information on this plugin, see Section 8.4.1.2, “Caching SHA-2 Pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
COMPRESS_OPS The number of times a B-tree page of size PAGE_SIZE has been compressed. COMPRESS_OPS_OK The number of times a B-tree page of size PAGE_SIZE has been successfully compressed. COMPRESS_TIME The total time in seconds used for attempts to ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...