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/group-replication-restarting-group.html
The replication group must therefore be restarted beginning with the most up to date member, that is, the member that has the most transactions executed and certified. It is not correct to assume that the last known primary member of the group is ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-status-variables.html
Gr_latest_primary_election_by_most_uptodate_member_timestamp This timestamp is updated whenever a new primary is chosen using the most-up-to-date selection method. Gr_latest_primary_election_by_most_uptodate_members_trx_delta The difference in the ... This section describes the status variables providing information about Group ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-understanding-consistency-guarantees.html
If data is synchronized at the time of a read, the current client session waits until a given point, which is the point in time that all preceding update transactions have been applied, before it can start executing. For a group that has ... In ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
If up-to-date statistics are required immediately, run ANALYZE TABLE to initiate a synchronous (foreground) recalculation of statistics. For a histogram with AUTO UPDATE enabled (see Histogram Statistics Analysis), automatic recalculation of ... The ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
To update invisible columns for UPDATE statements, name them and assign a value, just as for visible columns. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-apt-repo.html
Although this is not required for each update, it does update MySQL repository information to include the current information, which includes adding a new LTS series. Update package information from the MySQL APT repository with the following ...
https://dev.mysql.com/doc/refman/9.7/en/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> ...Suppose that your pet records can be described as shown ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-add-node-example.html
You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql client. In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-functions.html
For these reasons, you should always use the Option Tracker functions for modifying option usage data instead of attempting to update either of these tables directly. The caller must have the OPTION_TRACKER_UPDATER privilege; this privilege must ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...