PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/en/mysql-cluster-ndb-api-statistics.html
Table 25.67 NDB API statistics counters Counter Name Description Status Variables (by statistic type): Session Slave (replica) 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/8.0/en/mysql-cluster-ndbinfo-cpudata.html
The cpudata table provides data about CPU usage during the last second.
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-cluster-programs-ndb-import.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --idlespin=# Command-Line Format --idlespin=# Type Integer Default Value 0 ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-performance-timers-table.html
For a cycle timer, the frequency is generally related to the CPU speed. TIMER_RESOLUTION Indicates the number of timer units by which timer values increase. If a timer has a resolution of 10, its value increases by 10 each time. TIMER_OVERHEAD The ...For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event ...