PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-general.html
The auto_increment_increment value should be greater than the number of servers, and each server should have a unique offset. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
The profile-based protection afforded by the firewall enables implementation of strategies such as those listed here: If an application has unique protection requirements, have it use an account not used for any other purpose, and set up a group ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-natural-language.html
Relevance is computed based on the number of words in the row (document), the number of unique words in the row, the total number of words in the collection, and the number of rows that contain a particular word. By default or with the IN NATURAL ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-cloning.html
Group Replication also preserves the channel settings that relate to the use of SSL, so these are unique to the individual member. If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-connection-security.html
The combination of IP address and port for each member must be unique in the group. MySQL 9.7 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-ip-address-permissions.html
When and only when the XCom communication stack is used for establishing group communications (group_replication_communication_stack=XCOM), the Group Replication plugin lets you specify an allowlist of hosts from which an incoming Group ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-ipv6.html
When specified with a port number, an IPv6 address must be specified in square brackets, for example: group_replication_local_address= "[2001:db8:85a3:8d3:1319:8a2e:370:7348]:33061" The network address or host name specified in ... Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-summary.html
When a read/write transaction is ready to commit at the originating server, the server atomically broadcasts the write values (the rows that were changed) and the corresponding write set (the unique identifiers of the rows that were updated). Group ...