PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. For information about time zone ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
One or more undo log files are assigned to a log file group, which is then assigned to a tablespace. NDB Cluster tablespaces and log file groups are not implemented as files. For example, you cannot have a tablespace and a log file group both named ... NDB Cluster Disk Data storage is implemented using a number of Disk Data ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. For optimizer purposes, an important statistic is the average value group size. The average value group size is related to table ...
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 ...