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/my-print-defaults.html
my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the mysqlcheck program reads the [mysqlcheck] and ...--defaults-extra-file=file_name, --extra-file=file_name, -e file_name Read this option file after the global option file but (on Unix) before the user option ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within the table. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * You can use mysql_library_init(0, NULL, NULL), and it * initializes the server using groups = { * "server", "embedded", NULL * }. These two example programs should work without any changes on a Linux or FreeBSD system. For other operating ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
GROUP_NAME If this server is a member of a group, shows the name of the group the server belongs to. This table shows the current status of the replication I/O thread that handles the replica's connection to the source. It contains values that ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Also, any program that uses libmysqlclient and reads option files can enable the plugin by including an enable-cleartext-plugin option in an option group read by the client library. A client-side authentication plugin is available that enables ...
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 <=>, >=, >, <=, <, ...