PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-encrypted-connections.html
This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables ...
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/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... To influence index usage for sorting or grouping rows, use ... Index hints give the optimizer information about how to choose indexes during query ...
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/string-type-syntax.html
(The practical limit is less than 3000.) A table can have no more than 255 unique element list definitions among its ENUM and SET columns considered as a group. A table can have no more than 255 unique element list definitions among its ENUM and SET ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread ...