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/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
Even under conditions when index dives would otherwise be used, they are skipped for queries that satisfy all these conditions: A single-index FORCE INDEX index hint is present. Range Optimization of Row Constructor Expressions The optimizer is able ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
For more information about materialization, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”. This affects queries that use the STRAIGHT_JOIN modifier and a view with an IN subquery that can be converted to a semijoin. A ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. LOCK clauses are described below, in ...Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Two additional sources of information about pushed join performance are available: The status variables Ndb_pushed_queries_defined, Ndb_pushed_queries_dropped, Ndb_pushed_queries_executed, and Ndb_pushed_reads. Setting ndb_row_checksum to 0 means ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
The DTrace probes in the MySQL server are designed to provide information about the execution of queries within MySQL and the different areas of the system being utilized during that process. Support for DTrace is deprecated in MySQL 5.7 and is ...