PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
For queries that select from either view fewer than 2 columns (the number named in the ORDER BY clause), an error occurs if the server evaluates the view using the MERGE algorithm. If the view does not exist, CREATE OR REPLACE VIEW is the same as ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. That way, applications can select from the view without performing masking in ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... The [AS] tbl_name clause is mandatory because every table in a ...
https://dev.mysql.com/doc/refman/5.7/en/distinct-optimization.html
Thus, for more details on the optimization possibilities for DISTINCT queries, see Section 8.2.1.15, “GROUP BY Optimization”. DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
How do I continue to send queries in the event that one of the SQL nodes fails? A.10.40. However, it also means that queries that could otherwise use range scans must be satisfied by other means, which can result in slower selects. How do I continue ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-thread-pool.html
This minimizes the overhead and expense of establishing and tearing down connections as queries are submitted to the MySQL server. By contrast, the Thread Pool operates on the MySQL server side and is designed to manage the execution of inbound ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
For example, the following two queries are equivalent: SELECT * FROM t1 USE INDEX (i1) IGNORE INDEX (i2) USE INDEX (i2); SELECT * FROM t1 USE INDEX (i1); For FULLTEXT searches, index hints work as follows: For natural language mode searches, index ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). Note The ...