Search Results
https://dev.mysql.com/doc/internals/en/implementing-commit.html
If the server is in auto-commit mode, the storage engine should automatically commit all read-only statements such as SELECT. Increment the count for every call to external_lock(), decrement when external_lock() is called with an argument of F_UNLCK. During a commit operation, all changes made during a transaction are made permanent and a rollback operation is not possible after ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
These checks include the following: Automatically detect tables and columns that cannot be loaded. These adjustments are similar to those performed by Autopilot during Lakehouse Auto Parallel Load. For MySQL 9.1.2 and later, you can also review the ... 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 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-managing-hw-data.html
Refreshing Lakehouse Data: Your MySQL HeatWave Lakehouse data can be refreshed by a Lakehouse Incremental Load. Data is loaded into MySQL HeatWave from the associated DB System. If you have not loaded data into the DB System, see Importing Data.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb_metadata_check: Enable auto-detection of NDB metadata changes with respect to MySQL data dictionary; enabled by default. The following list includes command-line options, system variables, and status variables applicable within mysqld when it ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
Running ndb_index_stat with the --update option causes sampleVersion to be incremented. --delete Command-Line Format --delete Delete the index statistics for the given table, stopping any auto-update that was previously configured. --update ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
One event normally corresponds to one SQL statement in the binary log, but note that statements that use AUTO_INCREMENT or LAST_INSERT_ID() count as two events in the binary log. For instructions to do this, see Section 9.5, “Point-in-Time ... If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
minimal: Log only those columns in the before image that are required to identify the row to be changed; log only those columns in the after image where a value was specified by the SQL statement, or generated by auto-increment. Existing binary log ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16057) Support for use of the AUTO_INCREMENT modifier with FLOAT and DOUBLE columns was deprecated in MySQL 8.0, and is now removed. (Bug #36054355) Replication: With binlog_format=ROW and gtid_mode=OFF, deadlocks were sometimes reported among ...For MySQL distributions compiled using OpenSSL, the MySQL server can perform automatic generation of missing SSL and RSA files at ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
The output echoes all the parameters used by the backup operation, including several that are retrieved automatically using the database connection. The final output section repeats the location of the backup data and provides the LSN values that ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb_metadata_check: Enable auto-detection of NDB metadata changes with respect to MySQL data dictionary; enabled by default. ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: ...