PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. If you do not use columns from all tables named in a query, MySQL stops scanning any unused tables as soon ... DISTINCT combined with ORDER BY needs a temporary table in many ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from character_set_server or collation_server. The stopword table must have a ... The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The MEMBER_STATE column shows one of the Section 17.4.1, “Group Replication Server States”, in this case it shows that all three members in this group are ONLINE, and the MEMBER_ROLE column shows that there are two secondaries, and a single ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and each table by one or more files in the appropriate ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collation-character-set-applicability-table.html
Notes The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement. The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. To see information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically optimized. It is very fast to reference the primary key columns in WHERE clauses, ORDER BY clauses, GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Change buffering is not supported for a secondary index if the index contains a descending index column or if the primary key includes a descending index column. Configuring Change Buffering When INSERT, UPDATE, and DELETE operations are performed ... The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. SET GLOBAL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
InnoDB sets an exclusive lock on the end of the index associated with the AUTO_INCREMENT column while initializing a previously specified AUTO_INCREMENT column on a table. InnoDB fetches the value of a previously initialized AUTO_INCREMENT column ...