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-programs-ndb-select-all.html
--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
Group: Used for group proximity; smaller value is interpreted as being closer. Group: Used for group proximity; smaller value is interpreted as being closer. The listings in this section provide information about parameters used in the [computer], ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. A global transaction involves several actions that are transactional in themselves, but that all must either complete successfully ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For example: SELECT MIN(key_part2),MAX(key_part2) FROM tbl_name WHERE key_part1=10; To sort or group a table if the sorting or grouping is done on a leftmost prefix of a usable index (for example, ORDER BY key_part1, key_part2). See Section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
Tables that contain information about replication group members: replication_group_members: Provides network and status information for group members. replication_group_member_stats: Provides statistical information about group members and ...This ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Each statement summary table has one or more grouping columns to indicate how the table aggregates events. (The DIGEST_TEXT column contains the corresponding normalized statement digest text, but is neither a grouping nor a summary column.) The ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
This occurs if the WHERE, ORDER BY, or GROUP BY clause refers to an expression that matches the definition of some indexed generated column. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
It is very fast to reference the primary key columns in WHERE clauses, ORDER BY clauses, GROUP BY clauses, and join operations. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...