Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
The exception is for “mixed-mode inserts”, where the user provides explicit values for an AUTO_INCREMENT column for some, but not all, rows in a multiple-row “simple insert”. Specifying NULL or 0 for the AUTO_INCREMENT column In all lock ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
The information returned from a query is called the result set in the remainder of this section. The definitions apply primarily for columns of result sets such as those produced by SELECT statements. Tip To view the MYSQL_FIELD member values for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Scenario 2: For a data set that applies many writes, you want to perform occasional reads without concerns about reading stale data. You can choose the scope for which the consistency level is enforced by setting group_replication_consistency with ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. BYTES, ENUM ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-file-io.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. ios The total number of file I/O events for the user. io_latency The total ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
@census_model is the name of the user-defined session variable that stores the model handle for the duration of the connection. For example: mysql> CALL sys.ML_PREDICT_TABLE('census_data.`census_test`', @census_model, ...For example: mysql> CALL ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-data-drift-detection.html
@census_model is the name of the user-defined session variable that stores the model handle for the duration of the connection. For example: mysql> CALL sys.ML_PREDICT_TABLE('census_data.`census_test`', @census_model, ...For example: mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
mysql> SELECT @@innodb_max_undo_log_size; +----------------------------+ | @@innodb_max_undo_log_size | +----------------------------+ | 1073741824 | +----------------------------+ When the innodb_undo_log_truncate variable is enabled: Default and ...The location of all undo tablespace files including user-defined undo tablespaces created using CREATE UNDO TABLESPACE syntax can be determined by querying the Information Schema FILES table: SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; Rollback segments are reactivated so that they can be assigned to new ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-upgrading-mysql-8.0-8.4.html
Note:For backward compatibility, if the mysql_native_password authentication method is used by any existing users, the upgrade will enable the deprecated mysql_native_password authentication plugin. As the mysql_native_password authentication has ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. Users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this ...