PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-configuring.html
Decryption Support By Component Functions For Legacy Functions By default, the functions provided by the component_enterprise_encryption component from MySQL 8.0.30 do not decrypt encrypted text, or verify signatures, that were produced by the ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the variables from its outer context. For UNCACHEABLE SUBQUERY, the subquery is re-evaluated for each row of the outer context. There is no single ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table ...The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. For information about the default InnoDB stopword list and how to define your own stopword lists, see Section ...This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
Support for variable-length data types (including BLOB and TEXT) not supported by MEMORY. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-configuration.html
The configuration file should be located in the /etc directory and can be edited using any text editor. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but any text editor ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types. The NDB storage engine does not support FULLTEXT indexes, which are possible for MyISAM and InnoDB tables only. ON DELETE CASCADE is also not supported where ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...