PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-membership.html
If the president fails or becomes disconnected, the current node expects the node whose ID is shown in the successor column to become the new president. The succession_order column shows the place in the succession queue that the current node views ... The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memoryusage.html
The memoryusage table contains the following columns: node_id The node ID of this data node. Notes The total column represents the total amount of memory in bytes available for the given resource (data memory or index memory) on a particular data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
The processes table contains the following columns: node_id The node's unique node ID in the cluster node_type Type of node (management, data, or API node; see text) node_version Version of the NDB software program running on this node. The ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-operations.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
Use the directional arrows to move each product from the Available Products column to the Products To Be Installed column. The Reconfigure link in the Quick Action column next to each installed server loads the current configuration values for the ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
You also cannot use this statement to change the partitioning expression or column. Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
This column can be modified, although setting ENABLED has no effect for instruments that have already been created. This column can be modified, although setting TIMED has no effect for instruments that have already been created. For memory ... The ...
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
ANALYSE() examines the result from a query and returns an analysis of the results that suggests optimal data types for each column that may help reduce table sizes. PROCEDURE ANALYSE([max_elements,[max_memory]]) For example: SELECT col1, col2 FROM ... ANALYSE([max_elements[,max_memory]]) Note PROCEDURE ANALYSE() is deprecated as of MySQL 5.7.18, and is removed in MySQL ...