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/data-masking-plugin-functions.html
Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string return values are binary strings. If a MySQL Enterprise Data Masking and De-Identification function is invoked ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Indexes that have descending key parts are not used for MIN()/MAX() optimization of queries that invoke aggregate functions but do not have a GROUP BY clause. MySQL supports descending indexes: DESC in an index definition is no longer ignored but ...
https://dev.mysql.com/doc/refman/8.0/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-components.html
The following sections describe individual log components, grouped by component type: Filter Error Log Components Sink Error Log Components Component descriptions include these types of information: The component name and intended purpose. This ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
On Windows, there is currently a limit to the number of (logical) processors that mysqld can use: a single processor group, which is limited to a maximum of 64 logical processors. Why did MySQL version numbering skip versions 6 and 7 and go straight ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in octal export UMASK_DIR mysqld_safe & For additional details, see Section 6.9, “Environment Variables”. If you have problems with ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note To use MySQL Enterprise Firewall in the context of source/replica replication, Group Replication, or InnoDB Cluster, you must prepare the replica nodes ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax.
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
This occurs if the WHERE, ORDER BY, or GROUP BY clause refers to an expression that matches the definition of some indexed generated column. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is ...
https://dev.mysql.com/doc/refman/8.0/en/gis-property-functions.html
Each function that belongs to this group takes a geometry value as its argument and returns some quantitative or qualitative property of the geometry. Such functions return NULL if the argument is of an incorrect geometry type. For example, the ...