Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-deploy.html
To deploy MySQL EE on Oracle Cloud Infrastructure, do the following: Open the OCI Marketplace and search for MySQL. See To create a Linux instance for information on how to complete the fields. By default, the MySQL server listens on port 3306 and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace.html
This chapter describes how to deploy MySQL Enterprise Edition as an Oracle Cloud Infrastructure (OCI) Marketplace Application. Note For more information on OCI marketplace, see Overview of Marketplace. The MySQL Enterprise Edition Marketplace ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
Indexes are used to find documents with specific field values quickly. Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. If a collection is large and queries on a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
Indexes are used to find documents with specific field values quickly. Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. If a collection is large and queries on a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-userguide.html
MySQL Shell is an advanced client and code editor for MySQL Server. In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. For ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
MySQL uses a cost-based optimizer to determine the best way to resolve a query. In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-storage-engines.html
In MySQL 8.4, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning handler. In MySQL 8.4, only the InnoDB and NDB storage engines provide native partitioning handlers.
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. Statement ...