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-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are the members participating actively in the group at a given moment in time.
https://dev.mysql.com/doc/refman/9.7/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...However, GTIDs only provide a means to realize which transactions the joining member is ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-buffer-pool-flushing.html
This setting is recommended for non-rotational storage (SSD) devices where seek time is not a significant factor. When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/9.7/en/ldap-pluggable-authentication.html
With this plugin-loading method, the options must be given each time the server starts. After installing the plugins at runtime, the system variables that they expose become available and you can add settings for them to your my.cnf file to ... Note ...
https://dev.mysql.com/doc/refman/9.7/en/lock-tables.html
(This is a very convenient way to get backups if you have a file system such as Veritas that can take snapshots in time.) LOCK TABLE is a synonym for LOCK TABLES; UNLOCK TABLE is a synonym for UNLOCK TABLES. Multiple sessions can acquire a READ lock ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-api-statistics.html
Table 25.39 NDB API statistics counters Counter Name Description Status Variables (by statistic type): Session Replica (slave) Injector Server WaitExecCompleteCount Number of times thread has been blocked while waiting for execution of an operation ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cpudata.html
The cpudata table provides data about CPU usage during the last second.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-overview-requirements.html
In addition, to maintain consistency and service despite the silent failure of nodes, NDB Cluster uses heartbeating and timeout mechanisms which treat an extended loss of communication from a node as node failure. This recovery can take some time, ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldm-queries.html
There are two sets of queries, one run once at the start of the diagnostics, and another run iteratively for the defined number of iterations and the defined delay between each iteration.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-instrument-naming.html
This element also determines which event timer in the performance_timers table applies to the instrument. The TIMED column for the error row in the setup_instruments table is inapplicable because timing information is not collected. Memory ... An ...