MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 111 to 120 of 129 total results

25.6.16.46 The ndbinfo memory_per_fragment Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html

memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...

25.4.3.9 MySQL Server Options and Variables for NDB Cluster

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html

This variable affects only the number of AUTO_INCREMENT IDs that are fetched between statements; within a given statement, at least 32 IDs are obtained at a time. This section provides information about MySQL server options, server and status ...

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

https://dev.mysql.com/doc/refman/8.0/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 ...

25.5.25 ndb_select_all — Print Rows from an NDB Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html

ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...

22.3.5 Documents in Tables

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html

In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...

22.4.5 Documents in Tables

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-in-tables.html

10.5.1 Optimizing Storage Layout for InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html

(See Section 17.6.2.1, “Clustered and Secondary Indexes”.) Create an AUTO_INCREMENT column as the primary key if your primary key is long, or index a prefix of a long VARCHAR column instead of the entire column. Once your data reaches a stable ...

26.6.1 Partitioning Keys, Primary Keys, and Unique Keys

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html

This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...

26.3.3 Exchanging Partitions and Subpartitions with Tables

https://dev.mysql.com/doc/refman/8.0/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.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html

This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...

Displaying 111 to 120 of 129 total results