Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-faq.html
The MySQL Query Analyzer collects queries and execution statistics with no dependence on the SQL Query Log, it captures all SQL statements sent to the MySQL server and provides an aggregated view into the most expensive queries in number of ... Note ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-savepoints.html
By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting the savepoint. To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting the savepoint. To create a savepoint, use the session.setSavepoint() operation, which maps to the SQL statement ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
Running Advisor involves issuing a CALL statement for the stored procedure with optional arguments. Running Auto Parallel Load involves issuing a CALL statement for the stored procedure, which takes a list of schemas and options as arguments. SELECT ... Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string column encoding and data placement key recommendations based on machine learning models, data analysis, and MySQL HeatWave query ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-iam-policy.html
Creating an IAM Policy to Access an Amazon S3 Bucket 21.5.1 Creating an IAM Policy to Access an Amazon S3 Bucket Use the AWS Management Console to create an IAM policy to access an Amazon S3 bucket. The name of the Amazon S3 bucket you want to ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The user interface to MySQL accounts consists of SQL statements such as CREATE USER, GRANT, and REVOKE. To see what privileges a given account has, use the SHOW GRANTS statement. Stage 2: Assuming that you can connect, the server checks each ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
To grant one of these privileges to a user account, use this statement: GRANT privilege ON *.* TO user; Alternatively, should you prefer to avoid granting the AUDIT_ADMIN or SUPER privilege while still permitting users to access specific filtering ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). To load delimited-text files, use the LOAD DATA statement or the ... This ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Decompression is also carried out during recovery, by mysqlbinlog when replaying transactions, and by the SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements. Setting binlog_transaction_compression or binlog_transaction_compression_level_zstd (or ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...