MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 101 to 110 of 119 total results

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

Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's data. For these reasons, it is not possible to offer a single configuration ...

21.6.2.1 NDB Cluster: Messages in the Cluster Log

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-cluster-log.html

The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 21.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...

21.6.15.26 The ndbinfo memoryusage Table

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memoryusage.html

Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP 1000. The memoryusage table contains the following columns: node_id The node ID of this data node.

21.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html

This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...

21.5.16 ndb_move_data — NDB Data Copy Utility

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html

Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...

21.5.28 ndb_size.pl — NDBCLUSTER Size Requirement Estimator

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 ...

21.6.17 Quick Reference: NDB Cluster SQL Statements

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html

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 itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...

4.5.1.6 mysql Client Tips

https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html

This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using ...

8.5.8 Optimizing InnoDB Disk I/O

https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html

If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. If the Unix top tool or the Windows Task Manager shows ...

22.2.1 RANGE Partitioning

https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html

A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...

Displaying 101 to 110 of 119 total results