MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 81 to 90 of 97 total results

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

If an index is not used for ORDER BY but a LIMIT clause is also present, the optimizer may be able to avoid using a merge file and sort the rows in memory using an in-memory filesort operation. If you need only a specified number of rows from a ...

8.1.6 Security Considerations for LOAD DATA LOCAL

https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html

It can accept multiple data files to merge into a single relational table, and automatically decompresses compressed files. The LOAD DATA statement loads a data file into a table. The statement can load a file located on the server host, or, if the ...

15.2.9 LOAD DATA Statement

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

This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write ...

26.1 Overview of Partitioning in MySQL

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

Partitioning cannot be used with storage engines that do not support it; these include the MyISAM, MERGE, CSV, and FEDERATED storage engines. This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning ...

17.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema

https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html

stage/innodb/alter table (merge sort): This stage is repeated for each index added by the ALTER TABLE operation. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different ...

7.8.1 Setting Up Multiple Data Directories

https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html

Even when the preceding precautions are observed, this kind of setup works only with MyISAM and MERGE tables, and not with any of the other storage engines. Each MySQL Instance on a machine should have its own data directory. There are different ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

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

All source tables named on the command line to be merged into big_tbl_name must exist. When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing ...

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 section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, ...

7.4.4.3 Mixed Binary Logging Format

https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html

When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). When one or more tables with AUTO_INCREMENT columns are updated and a ...

25.2.4 What is New in MySQL NDB Cluster 8.0

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html

The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release series. NDB Cluster 8.4 is also available for production; while NDB 8.0 is still supported, we ...

Displaying 81 to 90 of 97 total results