Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The tag is a user-defined string used to identify a specific group of transactions; see the ...This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. With these privileges, the ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
We specify some of the connection information for the database using the --user and --host options (and, with the --password option, tell mysqlbackup to prompt for a user password). The unique ID for this backup job is recorded in special tables ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
(Bug #37049014) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on Windows. This fix also adds a warning to inform API users that deleting ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-details.html
CREATING: Resources are being reserved for the MySQL HeatWave Cluster, and the cluster is being created. ACTIVE: The MySQL HeatWave Cluster was successfully created and is ready to be used. FAILED: An error condition prevented the creation or ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
To create a differential backup, simply follow the instructions below for performing incremental backups, and make sure you specify a full backup as the base of your incremental backup; you should also ignore any instructions that only apply to the ...In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
Users connected to this MySQL server are allowed to create, edit, and use these shared snippets. The My Snippets option stores custom snippets in a file under the MySQL Workbench user's configuration directory. Table 8.1 Default Local Snippet File ... The Snippets secondary tab includes built-in, local, and shared custom ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...