PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Used for storing text-based documents, with associated character set and collation order. descending index A type of index where index storage is optimized to process ORDER BY column DESC clauses. Unlike the binary log, which is used for ... These ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... To influence index usage for sorting or grouping rows, use ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
With ORDER BY, the server issues a first-key request followed by several next-key requests, whereas with ORDER BY DESC, the server issues a last-key request followed by several previous-key requests. Handler_read_next The number of requests to read ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-named-windows.html
If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, window_name AS (window_spec)] ... Windows can be defined and given names by which ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
When replication is used, adding an AUTO_INCREMENT column to a table might not produce the same ordering of the rows on the replica and the source. This occurs because the order in which the rows are numbered depends on the specific storage engine ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
A key_part specification can end with ASC or DESC to specify whether index values are stored in ascending or descending order. The multi-valued key part may be used in any order relative to the other parts of the key. In other words, the ALTER TABLE ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The string result is in the same order as the binary argument. The string result is in the same order as the binary argument. GROUPING() is permitted in the select list, HAVING clause, and (as of MySQL 8.0.12) ORDER BY clause. In this case, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
All --include-* and --exclude-* options are evaluated in the order passed to ndb_restore, from right to left. --rebuild-indexes Command-Line Format --rebuild-indexes Enable multithreaded rebuilding of the ordered indexes while restoring a native NDB ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
This option can be used only in conjunction with the -o (--order) option. --order=index_name, -o index_name Orders the output according to the index named index_name. --tupscan, -t Scan the table in the order of the tuples. ndb_select_all prints ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If you disable binary logging, either omit these options, or specify --log-slave-updates=OFF and --skip-slave-preserve-commit-order. If you specify --log-slave-updates or --slave-preserve-commit-order together with --skip-log-bin or ... Startup ...