Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-restrictions-async-exec.html
Therefore, only those specific SQL operations that are supported inside events are supported for creating asynchronous tasks. Any SQL operation that depends on the return value of the SESSION_USER() or USER() function might behave differently when ...When an asynchronous task attempts to obtain a lock on a database resource, but it unable to get it as another transaction holds a conflicting lock, an error is generated and the following message is displayed: Cannot acquire ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-granting-privileges-bulk-ingest.html
However, if a user is importing data using the bulk ingest feature, the LOAD_FROM_S3 privilege is required. Do the following to grant the LOAD_FROM_S3 privilege to a user: Connect to the DB System. Grant the LOAD_FROM_S3 privilege to the user: GRANT ... Granting Privileges to Bulk Ingest Data From Amazon S3 7.2.2.1 Granting Privileges to Bulk Ingest Data From Amazon S3 By default, a DB System administrator has the LOAD_FROM_S3 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-sign-procedure.html
Sign-up Procedure 2.2.2 Sign-up Procedure To sign up for MySQL HeatWave on AWS: Create an Oracle Cloud Account (or proceed to Step 2 below if you already have one): Navigate to https://cloud.mysql.com and click Sign Up. Note: The OCI user account ...In the verification email, click Verify email to verify the email address and continue the account setup ...
https://dev.mysql.com/doc/connector-j/en/connector-j-using-openID.html
Connector/J supports authentication for users created on a MySQL server using the authentication_openid_connect plugin. If no server user name is specified in the connection string or during the creation of the Connection object, the implementation ... OpenID Connect is an authentication protocol based on the OAuth 2.0 framework, providing a simplified and interoperable ways of authentication for enhanced ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
However, enabling FIPS mode does not require that an encrypted connection must be used, or that user credentials must be encrypted. MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system.
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
cat t1.ibd | innochecksum --write=crc32 - > a.ibd Running innochecksum on Multiple User-defined Tablespace Files The following examples demonstrate how to run innochecksum on multiple user-defined tablespace files (.ibd files). On Windows systems, ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
Such a server could access any file on the client host to which the client user has read access. In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the ... The LOAD DATA statement loads a data file into a ...