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/sys-host-summary-by-statement-latency.html
max_latency The maximum single wait time of timed statements for the host. total_latency The total wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
max_latency The maximum single wait time of timed statements for the user. total_latency The total wait time of timed statements for the user. lock_latency The total time waiting for locks by timed statements for the user. The ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
KILL permits an optional CONNECTION or QUERY modifier: KILL CONNECTION is the same as KILL with no modifier: It terminates the connection associated with the given processlist_id, after terminating any statement the connection is executing. KILL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
If joe connects from hosta.example.com, the connection matches the second inserted row. The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. replication_connection_status Column SHOW SLAVE STATUS Column SOURCE_UUID Master_UUID THREAD_ID None SERVICE_STATE Slave_IO_Running ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
The following example shows how execution plans are affected by whether the optimizer uses extended secondary indexes. InnoDB automatically extends each secondary index by appending the primary key columns to it. It also defines a secondary index ...Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Typically, this is set up at the time one is provisioning a server to join the group. Group communication connections as well as recovery connections, are secured using SSL. Configuring SSL for Group Replication Recovery Recovery is performed ...