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/index-btree-hash.html
In other words, to be able to use an index, a prefix of the index must be used in every AND group. Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
You can also perform these actions for a group of counters using their common module name. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a comparison operator, it has the same precedence as <=>, >=, >, <=, <, ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. For character and string columns, follow these guidelines: Use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Example file I/O event summary ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A table can have no more than 255 unique element list definitions among its ENUM and SET columns considered as a group. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values ...
https://dev.mysql.com/doc/refman/5.7/en/sys-latest-file-io.html
These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections).
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
The unobfuscated format of the .mylogin.cnf login path file consists of option groups, similar to other option files. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, user, ...