PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/metadata-locking.html
For example, a second session blocks if it attempts any of these operations: DROP TABLE t; ALTER TABLE t ...; DROP TABLE nt; ALTER TABLE nt ...; LOCK TABLE t ... MySQL uses metadata locking to manage concurrent access to database objects and to ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
Because waits are timed in picoseconds (trillionths of a second) by default, wait times are divided by 1000000000 to show wait times in milliseconds. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-api-definition.html
ArbitrationDelay Version (or later) NDB 9.7.0 Type or units milliseconds Default 0 Range 0 - 4294967039 (0xFFFFFEFF) Restart Type Node Restart: Requires a rolling restart of the cluster. (NDB 9.7.0) Setting this parameter to any other value than 0 ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-basics.html
Global Checkpoint (GCP): A GCP occurs every few seconds, when transactions for all nodes are synchronized and the redo-log is flushed to disk. NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-config-example.html
To support NDB Cluster, you should update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. Note The options shown here should not be confused with those that are used ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-log-statistics.html
Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) and the local query handler (LQH), and written to the cluster log. The NDB management client's CLUSTERLOG ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-logs-event-buffer.html
The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ndb_report_thresh_binlog_epoch_slip server variable. NDB uses one or more memory buffers for events received ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-management.html
The second method involves studying the contents of the cluster log ndb_node_id_cluster.log; this is usually found in the management server's DataDir directory, but this location can be overridden using the LogDestination option. Managing an NDB ...