MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 68 of 68 total results

« Previous
5
6
7
Next »

10.13.3 Measuring Performance with performance_schema

https://dev.mysql.com/doc/refman/9.7/en/monitoring-performance-schema.html

You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.

25.4.3.4 Defining Computers in an NDB Cluster

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-computer-definition.html

The [computer] section has no real significance other than serving as a way to avoid the need of defining host names for each node in the system. Id Version (or later) NDB 9.7.0 Type or units string Default [...] Range ... Restart Type Initial ...

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-config-starting.html

NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...

25.6 Management of NDB Cluster

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-management.html

More detailed information about NDB Cluster operations is available in real time through an SQL interface using the ndbinfo database. Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB Cluster. This ...

25.2.6.1 Differences Between the NDB and InnoDB Storage Engines

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-innodb-engines.html

The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...

25.2.6.3 NDB and InnoDB Feature Usage Summary

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-innodb-usage.html

When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...

25.6.15.53 The ndbinfo restart_info Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-restart-info.html

Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...

25.4.3.9 MySQL Server Options and Variables for NDB Cluster

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html

The real (internal) name of the table can be seen in the output of SHOW CREATE TABLE. Ndb_conflict_trans_row_reject_count Used in NDB Cluster Replication conflict resolution, this status variable shows the total number of rows realigned due to being ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...