MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 181 to 190 of 199 total results

https://dev.mysql.com/doc/refman/8.0/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/8.0/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.3.1 How MySQL Uses Indexes

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

Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...

6.5.6 mysqlpump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...

10.5.1 Optimizing Storage Layout for InnoDB Tables

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

Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...

26.3.5 Obtaining Information About Partitions

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

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

10.2.4 Optimizing Performance Schema Queries

https://dev.mysql.com/doc/refman/8.0/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 181 to 190 of 199 total results