Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-fault.html
Warning For a remote cloning operation, user-created tablespaces and data on the recipient (the joining member) are dropped before the remote cloning operation begins to transfer the data from the donor. If the remote cloning operation starts but ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The VALUE column is empty if there is no user-defined stopword table. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. If you query data and then insert or update related data within the same ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
Too many active purge threads in this scenario can cause contention with user threads, so manage the innodb_purge_threads setting accordingly. The reason that a long running transaction can cause the History list length to increase is that under a ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ... my_print_defaults displays the options that are present in option groups of option ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
For more information about the files and directories created by local checkpoints and global checkpoints, see NDB Cluster Data Node File System Directory. Because it is ubiquitous, most users employ TCP/IP over Ethernet for NDB Cluster. NDBCLUSTER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED. Other sources of information about user-defined partitioning in MySQL include the following: MySQL ...Note Table partitioning differs from partitioning as used by window ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Attribute names that begin with an underscore (_) are reserved for internal use and should not be created by application programs. Some MySQL client programs define additional attributes: mysql: os_user: The name of the operating system user running ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...