Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note This view is deprecated, and subject to removal in a future MySQL version. For example, use the VERSION() function to retrieve the MySQL server version. Applications that use ...
https://dev.mysql.com/doc/refman/8.4/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. You are comparing indexed columns with constant values and MySQL has calculated (based on the index tree) that the constants cover too large ...This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-installation.html
This section describes how to install MySQL Enterprise Thread Pool. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To do this, put these ...
https://dev.mysql.com/doc/refman/8.4/en/views.html
Additional Resources You may find the MySQL User Forums helpful when working with views. For answers to some commonly asked questions regarding views in MySQL, see Section A.6, “MySQL 8.4 FAQ: Views”. Views are stored queries that when invoked ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
For faster execution, MySQL always uses inverse aggregation when it is safe: For floating-point values, inverse aggregation is not always safe and might result in loss of precision. Window functions affect the strategies the optimizer considers: ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/preface.html
This is the user manual for the MySQL Enterprise Backup product. See the MySQL Enterprise Backup 8.4 License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in ...License Restrictions This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-import-config.html
import config requires a single argument, cluster_name, which is the name of the cluster created using MySQL Cluster Manager into which you wish to import the configuration of a MySQL NDB Cluster created externally. The cluster named in the command ... import config [--dryrun|-y] [--retry] cluster_name This command imports the configuration of an autonomous or “wild” cluster into the cluster named ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-data-structures.html
C API functions for processing a replication event stream from a server require a connection handler (a MYSQL * pointer) and a pointer to a MYSQL_RPL structure that describes the steam of replication events to read from the server binary log. int ...Connection handlers are described in Section 5.2, “C API Basic Data ...