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/partitioning-management-exchange.html
The following example compares the difference between execution times when exchanging a partition with a nonpartitioned table, with and without validation. Table nt contains no foreign key references, and no other table has any foreign keys that ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. By limiting the search, it is possible to expend much less time and effort in finding matching rows than by ...When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
From MySQL 8.0.30, the functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the functions. The functions from the openssl_udf shared library are deprecated from that release, and ... In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. The following functions can be used to ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
The keyword STACKED means to retrieve information from the second diagnostics area, which is available only if the current context is a condition handler. The GET DIAGNOSTICS statement is typically used in a handler within a stored program. It is a ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
The default value of max_sort_length is 1024 and can be changed at server startup time or at runtime. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
[mgm] and [mgm default] are older aliases for these, supported for backward compatibility. All parameters in the following list are optional and assume their default values if omitted. Id Version (or later) NDB 8.0.13 Type or units unsigned Default ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. WHERE subquery_where) MySQL evaluates queries “from outside to inside.” ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. This is due to the fingerprinting mechanism used by the virus-scanning software, and the ...MySQL Installer Method The simplest and recommended method is to download MySQL Installer (for Windows) and let it install and configure a specific version of MySQL Server as follows: Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute ...