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-logbuffers.html
The logbuffers table contains the following columns: node_id The ID of this data node. The logbuffer table provides information on NDB Cluster log buffer usage. One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-logspaces.html
The logspaces table contains the following columns: node_id The ID of this data node. log_id The log ID; for Disk Data undo log files, this is the same as the value shown in the LOGFILE_GROUP_NUMBER column of the Information Schema FILES table as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-restart-info.html
The restart_info table contains the following columns: node_id Node ID in the cluster node_restart_status Node status; see text for values. Each entry in the table corresponds to a node restart status report in real time from a data node with the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-transactions.html
(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The state column can have any one of the values CS_ABORTING, CS_COMMITTING, CS_COMMIT_SENT, CS_COMPLETE_SENT, CS_COMPLETING, CS_CONNECTED, ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-threadblocks.html
The threadblocks table contains the following columns: node_id Node ID thr_no Thread ID block_name Block name block_instance Block instance number Notes The value of the block_name in this table is one of the values found in the block_name column ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 21.7.5, “Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The SQL statements used to grant and revoke privileges on NDB tables, databases containing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
Unlike the case with the SHOW ENGINES statement, it is possible to filter the results using a LIKE clause, and to select specific columns to obtain information that may be of use in scripts. Please use performance_schema.global_variables instead | ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
For example: UPDATE tbl_name SET not_key_column=val WHERE key_column=val; UPDATE tbl_name SET not_key_column=val LIMIT 1; Setting sql_select_limit to 1,000 causes the server to limit all SELECT result sets to 1,000 rows unless the statement includes ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
mysql_upgrade checks mysql.user system table rows and, for any row with an empty plugin column, sets that column to 'mysql_native_password' or 'mysql_old_password' depending on the hash format of the Password column value. Each time you upgrade ...