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/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the ...This method of index creation is also known as a sorted index ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
Section 9.2.1, “Identifier Length Limits”, indicates the maximum length of each type of identifier. The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_log_status Command-Line Format --authentication-ldap-sasl-log-status=# Introduced 5.7.19 System Variable authentication_ldap_sasl_log_status Scope Global Dynamic Yes Type Integer Default Value 1 Minimum Value 1 Maximum Value ...If the base DN is ou=Admin,dc=example,dc=com: Searches find user entries only in the second ...Communication between the authentication ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down ...(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs.
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
If you use any of those statements but specify an xid value that does not correspond to some existing XA transaction, an error occurs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...