Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
To have passwords automatically expire after a specified number of days, add an entry similar to this under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf): default_password_lifetime=120 A setting of 120 means that the ...It ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of the number of rows returned COUNT(DISTINCT) Return the count of a number of different values ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
This topic provides information related to the SELECT statement clauses supported in MySQL HeatWave and describes how to use the GROUP BY and QUALIFY clauses to group or filter the processing results. GROUP BY clause A CUBE modifier in addition to ...Verify if the query is offloaded to MySQL HeatWave for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-endpoint.html
Security groups: Select the security groups in your account to associate with the endpoint. For more information, see Control traffic to your AWS resources using security groups. Creating an Endpoint for a Query PrivateLink 6.1.3 Creating an ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. The following commands add the mysql group and the mysql user. You might want to call the user and group ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
CREATE TABLESPACE Enable tablespaces and log file groups to be created, altered, or dropped. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
FOR UPDATE statement for each group of rows expected to be modified, even if the data change statements come later in the transaction. Advantages of table-level locking: Relatively little memory required (row locking requires memory per row or group ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Most of the reserved words in the list are forbidden by standard SQL as column or table names (for example, GROUP). Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...