PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Descending indexes are supported for ordinary (nongenerated) and generated columns (both VIRTUAL and STORED). MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/8.0/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition definitions associated with the dropped table. Be careful with this statement! For each table, it ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. DROP [UNDO] TABLESPACE tablespace_name ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
A row can become fragmented (stored in noncontiguous pieces) when it is made longer as a result of an update. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-c-api.html
What if I want to use the “NoSQL” X DevAPI? For C-language and X DevApi Document Store for MySQL, we recommend MySQL Connector/C++. What is “MySQL Native C API”? What are typical benefits and use cases? A.13.2. What if I want to use the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. Where can I obtain complete documentation for ...
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. To include the ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
In addition, since returned rows must be stored in memory, such a query can also lead to the local server swapping, or even hanging. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server ...