Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
Important An NDB Cluster management node caches the configuration data that it reads from config.ini; once it has created a configuration cache, it ignores the config.ini file on subsequent starts unless forced to do otherwise. Once the NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
In this scheme, each transaction in a binary log file is annotated with a sequence_number (1, 2, 3, ...), and as well as the sequence number of the most recent binary log transaction that it depends on, to which we refer as last_committed. Within a ...To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...The elements of an instrument name ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
The relay log file name (Relay_Log_File) is set according to the relay_log_recovery setting, either a new file that was created at server start or the first relay log file present. Inconsistencies in the sequence of transactions from the relay log ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
To enable MySQL to startup and shutdown automatically, you should create a link between this file and the init script directories. The typical upgrade sequence is therefore: $> mysqladmin shutdown $> pkgrm mysql $> pkgadd -d ... You can install ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as with an ALTER TABLE ... This occurred for tables with a row format of Redundant or Compact and the row format was not explicitly defined in ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
If different passwords were used for different backups in a sequence of full and incremental backups, make sure the very password used to create an individual backup is supplied when performing an apply-log, apply-incremental-backup, or ... MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Rate at which redo data is generated Calculated from the values of the InnoDB logical sequence number at different points in time. Use the technique explained in Creating Incremental Backups Using Only the Redo Log. Before backing up a particular ...