Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
IGNORE | REPLACE The IGNORE and REPLACE options indicate how to handle rows that duplicate unique key values when copying a table using a SELECT statement. For a unique index, an error occurs regardless of SQL mode because reducing the index length ...| [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
In the following discussion, “client connection” is shorthand for a connection to the server originating from any source for which compression is supported, unless context indicates a specific connection type. Note X Protocol connections to a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
A busy server could be writing a page at the same moment that mysqlbackup is reading it. A busy server could be writing a page at the same moment that mysqlbackup is reading it. When an incremental backup is restored with the --skip-binlog option, ...--limit-memory=MB Command-Line Format --limit-memory=MB Type Numeric Default Value 100 for apply-log (without uncompression), 400 for other operations Minimum Value 0 Maximum Value 999999 Unit megabyte Specify maximum memory in megabytes that can be used by ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Suppose that jeffrey connects and issues the following query: mysql> SELECT CURRENT_USER(); +----------------+ | CURRENT_USER() | +----------------+ | @localhost | +----------------+ The result shown here indicates that the matching user table row ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-general.html
Each MySQL server used for replication in either cluster must be uniquely identified among all the MySQL replication servers participating in either cluster (you cannot have replication servers on both the source and replica clusters sharing the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Default frequency 00:05:00 Default auto-close enabled no In-Memory Temporary Table Size Limited By Maximum Heap Table Size If the space required to build a temporary table exceeds either tmp_table_size or max_heap_table_size, MySQL creates a ...If ...Default frequency 06:00:00 Default auto-close enabled yes Binary Log Debug Information Disabled The binary log captures DML, DDL, and security changes that occur and stores these changes in a binary ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
MySQL Enterprise Backup does not include the .pem files from the server into the backup. When a file of an unrecognized file type exists under a subdirectory in the server's data directory, it will be backed up by mysqlbackup unless the ... Please ...If autocommit is turned off, and both InnoDB tables and non-transactional tables are modified within the same transaction, data can be written to the non-transactional table before the binary log position is ...
https://dev.mysql.com/doc/connectors/en/connector-net-connections-string.html
The following is a sample connection string: "server=127.0.0.1;uid=root;pwd=12345;database=test" In this example, the MySqlConnection object is configured to connect to a MySQL server at 127.0.0.1, with a user name of root and a password of 12345.
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-string.html
The following is a sample connection string: "server=127.0.0.1;uid=root;pwd=12345;database=test" In this example, the MySqlConnection object is configured to connect to a MySQL server at 127.0.0.1, with a user name of root and a password of 12345.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-membership.html
In MySQL Group Replication, a set of servers forms a replication group. To counter this possibility, MySQL Group Replication checks for the situation where a new incarnation of the same server is trying to join the group while its old incarnation ...The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...