Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-service-limits.html
The MySQL HeatWave on AWS default service limits are shown below. To request a service limit increase, submit a My Oracle Support ticket, specifying "MySQL HeatWave on AWS" as the product. Tip:Even when connections to DB Systems are blocked, you can ... Service Limits 21.2 Service Limits A service limit is the quota or allowance set on a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
If set to an explicit time zone then it must be one that either the JVM or both the JVM and MySQL support. If set to "SERVER" then the driver attempts to detect the session time zone from the values configured on the MySQL server session variables ... connectionTimeZone Configures the connection time zone which is used by Connector/J if conversion between the JVM default and a target time zone is needed when preserving instant temporal ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html
Configuration properties define how Connector/J will make a connection to a MySQL server. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object. If you specify a configuration property in the URL without ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
NETWORK_NAMESPACE = 'namespace' The network namespace to use for TCP/IP connections to the replication source server or, if the MySQL communication stack is in use, for Group Replication’s group communication connections. A divergence based on the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone within a series such as MySQL 8.4.1 and MySQL 8.4.13.
https://dev.mysql.com/doc/refman/8.4/en/counting-rows.html
COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> SELECT COUNT(*) FROM pet; +----------+ | COUNT(*) | +----------+ | 9 | +----------+ Earlier, you retrieved the names of the people who owned pets.
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
The event_name must be a valid MySQL identifier with a maximum length of 64 characters. The DEFINER clause specifies the MySQL account to be used when checking access privileges at event execution time. If the DEFINER clause is present, the user ...
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
mysql> SET @poly = ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7,5 5))'); mysql> SELECT ST_GeometryType(@poly),ST_AsText(ST_Centroid(@poly)); +------------------------+--------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...