Search Results
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all platforms. On Unix-like systems, including Linux, you can check your system's ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
mysql> SELECT ST_GeoHash(180,0,10), ST_GeoHash(-180,-90,15); +----------------------+-------------------------+ | ST_GeoHash(180,0,10) | ST_GeoHash(-180,-90,15) | +----------------------+-------------------------+ | xbpbpbpbpb | 000000000000000 | ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more understandable and maintainable form. Note Because work on the MySQL optimizer is ongoing, not all of the optimizations that MySQL ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-upgrading.html
This section discusses upgrading MySQL Cluster Manager from a previous release to the latest release (currently 8.4.6), as well as providing basic guidance on upgrading the bundled MySQL NDB Cluster software. Notes Only upgrades from MySQL Cluster ...Create a configuration for the new installation such that it uses the previous installation's ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-process-commands.html
This section contains information about MySQL Cluster Manager client commands used to start and stop MySQL NDB Cluster processes, and to determine which processes are currently running. For a MySQL NDB Cluster under MySQL Cluster Manager control, ...These include but are not limited to the following ndb_mgm client commands (Commands in the NDB Cluster Management Client): START STOP RESTART SHUTDOWN ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/installation-source.html
They sometimes use a simulated Kubernetes client to verify whether requests sent by NDB Operator match expectations. To run the E2E tests in an existing Kubernetes cluster, pass the path to the kubeconfig file for this cluster to the run-e2e-test.go ... This section describes how to compile, install, and test NDB Operator from ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-general-editors.html
If the value of SqlMode is not set, the default value of the SQL_MODE session variable defined by the server stays unchanged during operations with the server. If you choose to not set the SqlMode property, ensure that the default SQL_MODE variable ...Figure 3.5 Preferences: General Editors SQL Parsing in Code Editors SQL properties that can be set include the SQL_MODE, case-sensitivity of identifiers, and the SQL delimiter ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
When the replication SQL (applier) thread has caught up on I/O, Seconds_Behind_Source displays 0; but when the replication I/O (receiver) thread is still queuing up a new event, Seconds_Behind_Source may show a large value until the replication ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query. For ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For example, the following query is not offloaded: mysql> SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; Primary keys with column prefixes. Queries that call a stored function are not supported before MySQL 9.5.0. As of MySQL 9.5.0, queries that ...For a list of supported SQL modes, see Section 5.2, “Supported SQL ...Comparison ...