PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table. KILL [CONNECTION | ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
Typographical and Syntax Conventions This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, table, and column names; program listings and source code; and environment variables. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
With a nonconstant initializer argument (such as a column name), the seed is initialized with the value for each invocation of RAND(). One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help performance. If you have data that does not conform well to a ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. When MRR is used, the Extra column in EXPLAIN output shows Using MRR. Reading rows using a range scan on a secondary index can result in many random ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-5.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_default_column_format: Sets default row format and column format (FIXED or DYNAMIC) used for ...Parameters Introduced in NDB 7.5 The following node configuration parameters have been added in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
For reads, this is proportional to the number of columns requested. For inserts and updates, this is proportional to the number of columns written, and the size of their data. Attribute information sent to describe columns to read for scans, or to ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The state column can have any one of the values CS_ABORTING, CS_COMMITTING, CS_COMMIT_SENT, CS_COMPLETE_SENT, CS_COMPLETING, CS_CONNECTED, CS_DISCONNECTED, CS_FAIL_ABORTED, CS_FAIL_ABORTING, CS_FAIL_COMMITTED, CS_FAIL_COMMITTING, CS_FAIL_COMPLETED, ... The cluster_transactions table shows information about all ongoing transactions in an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
node_id ID of the node in the cluster config_param The parameter's internal ID number config_value Current value of the parameter Notes This table's config_param column and the config_params table's param_number column use the same parameter ... The ...