Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Also, a deletion is treated internally as an update ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Client applications that access the servers to retrieve and update data, choosing servers according to the purposes assigned them. For example, a client should not send an update to a read-only server. If at some point the management application ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-switchover.html
Now that the Rome cluster is a replica cluster, the member servers or the complete cluster can safely be taken offline if required to carry out the maintenance work. For example: mysql-js> myclusterset.setRoutingOption('Rome1', 'target_cluster', ...
https://dev.mysql.com/doc/connectors/en/connector-j-fips.html
This can be done by setting the following connection properties: fipsCompliantJsse: Set to true to overcome the above-mentioned issue with FIPS mode. Note When set to true, Connector/J always performs server certificate validation (even if sslMode ...The issue can be overcome by telling Connector/J not to use its custom TrustManager implementation, but use your own security providers ...
https://dev.mysql.com/doc/connector-j/en/connector-j-fips.html
This can be done by setting the following connection properties: fipsCompliantJsse: Set to true to overcome the above-mentioned issue with FIPS mode. Note When set to true, Connector/J always performs server certificate validation (even if sslMode ...The issue can be overcome by telling Connector/J not to use its custom TrustManager implementation, but use your own security providers ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and PROCEDURE. The WITH CHECK OPTION clause can be given to ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #37370439) An UPDATE subsequent to an INSERT affecting a table which had a BEFORE INSERT trigger was sometimes rejected with a null value error when the INSERT had set a NOT NULL column to NULL, even though this should have been allowed by the ...WARN flags the issues, but allows the user to continue in interactive mode while addressing the ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
The TIMESTAMP and DATETIME types have special automatic updating behavior, described in Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. By setting the SQL mode to the appropriate value, you can specify more ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. Updates ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...