PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
MEMORY tables can have up to 64 indexes per table, 16 columns per index and a maximum key length of 3072 bytes. (This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. The MEMORY storage ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
The checks ensure that the definitions of the tables and the parent MERGE table definition match by comparing column order, types, sizes and associated indexes. Because these checks take place when the tables are opened, any changes to the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
In this example, a middle_name column is added to the employees table of the employees sample database. mysql> ALTER TABLE employees.employees ADD COLUMN middle_name varchar(14) AFTER first_name; Query OK, 0 rows affected (9.27 sec) Records: 0 ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. After restarting the server, the ENABLED column of the Performance Schema setup_instruments table should report YES for memory instruments ... The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-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-ndbinfo-config-nodes.html
The node_type column displays one of the following three values: MGM: Management node. The node_hostname column shows the node host as specified in the config.ini file. The config_nodes table shows nodes configured in an NDB Cluster config.ini file. For each node, the table displays a row containing the node ID, the type of node (management node, data node, or API node), and the name or IP address of the host on which the node is configured to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...This is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, sh_req, sh_req_imm_ok, sh_wait_ok, and sh_wait_fail represent cumulative numbers of requests since the table or fragment was created, or since the last restart ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
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 ...