PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
Note ECDSA ciphers only work in combination with an SSL certificate that uses ECDSA for the digital signature, and they do not work with certificates that use RSA. MySQL Server’s automatic generation process for SSL certificates does not generate ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
SELECT CAST(c2 as unsigned integer) FROM demo_test; # Since there could be numeric values of 0, can't disqualify them. SELECT AVG(cast(c2 as unsigned integer)) FROM demo_test WHERE c2 BETWEEN '0' and '9999999999'; # Views let you hide the complexity ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
After the user has performed the appropriate device action (for example, touching the device or performing a biometric scan) the FIDO device generates a public/private key pair, a key handle, an X.509 certificate, and a signature, which is returned ... Note FIDO pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
For more information, see Section 15.7.6.1, “SET Syntax for Variable Assignment”. To benefit from this effect, the replica servers must have replica_parallel_type=LOGICAL_CLOCK (from MySQL 8.0.26) or slave_parallel_type=LOGICAL_CLOCK set, and ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR (MySQL 8.0.22 and later) YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
In many cases, the equal sign can be replaced with another arithmetic comparison, including <, >, <=, >=, and <>. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
row *************************** LOGGED: 2020-08-06 09:25:02.936146 THREAD_ID: 0 PRIO: Warning ERROR_CODE: MY-010068 SUBSYSTEM: Server DATA: CA certificate /var/mysql/sslinfo/cacert.pem is self signed. Many Performance Schema tables other than ... Of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
INSTALL PLUGIN plugin_a; The server detects that the 40 instruments are already defined, so no new instruments are created, and previously assigned internal memory buffers are reused. The Performance_schema_mutex_classes_lost status variable is the ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. To verify the signature for a specific package, you first need to obtain a copy of our public GPG build key, which you can download from ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. (In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and ...The prepared statement is executed with EXECUTE and released with DEALLOCATE ...