MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 101 to 110 of 115 total results

25.3.5 NDB Cluster Example with Tables and Data

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-example-data.html

Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...

25.6.15.26 The ndbinfo dict_obj_tree Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-dict-obj-tree.html

The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...

25.5.9 ndb_desc — Describe NDB Tables

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-desc.html

ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...

25.4.1 Quick Test Setup of NDB Cluster

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

To familiarize you with the basics, we describe the simplest possible configuration for a functional NDB Cluster. After this, you should be able to design your desired setup from the information provided in the other relevant sections of this ...

10.5.5 Bulk Data Loading for InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html

For example: CREATE TABLE t1 ( FTS_DOC_ID BIGINT unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL DEFAULT '', text mediumtext NOT NULL, PRIMARY KEY (`FTS_DOC_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE UNIQUE INDEX ... These ...

26.3.5 Obtaining Information About Partitions

https://dev.mysql.com/doc/refman/9.7/en/partitioning-info.html

This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...

26.3.3 Exchanging Partitions and Subpartitions with Tables

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

Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...

26.5 Partition Selection

https://dev.mysql.com/doc/refman/9.7/en/partitioning-selection.html

Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...

29.6 Performance Schema Instrument Naming Conventions

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

Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...

10.2.4 Optimizing Performance Schema Queries

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

Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...

Displaying 101 to 110 of 115 total results