Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-service-limits.html
Service Limits 21.2 Service Limits A service limit is the quota or allowance set on a resource. The MySQL HeatWave on AWS default service limits are shown below. To request a service limit increase, submit a My Oracle Support ticket, specifying ...
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/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...
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. 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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-autotune.html
autotune [--dryrun] [--sequential-restart] [--writeload=writeload] template cluster_name writeload: {low|medium|high} template: {web|realtime|test} The command autotune a number of parameters for the cluster according to the specified values for ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The rules for NULL handling are described later in this section. \Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 11.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
If a table contains no primary key, InnoDB automatically promotes the first UNIQUE NOT NULL index to the primary key. This is not supported for UNIQUE NOT NULL indexes that have functional key parts. A UNIQUE index permits multiple NULL values for ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
CertificateFile , Certificate File Default: null This option specifies the path to a certificate file in PKCS #12 format (.pfx). CertificatePassword , Certificate Password Default: null Specifies a password that is used in conjunction with a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
CertificateFile , Certificate File Default: null This option specifies the path to a certificate file in PKCS #12 format (.pfx). CertificatePassword , Certificate Password Default: null Specifies a password that is used in conjunction with a ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1, or if X is NULL. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...