PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-secure-installation.html
For example, to connect to the local server over IPv6 using port 3307, use this command: mysql_secure_installation --host=::1 --port=3307 mysql_secure_installation supports the following options, which can be specified on the command line or in the ... This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
When Group Replication is started on a server, the value of auto_increment_increment is changed to the value of group_replication_auto_increment_increment, which defaults to 7, and the value of auto_increment_offset is changed to the server ID. If ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and replicas. Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
It consists of several actions that are transactional in themselves, but that all must either complete successfully as a group, or all be rolled back as a group. group commit An InnoDB optimization that performs some low-level I/O operations (log ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description Introduced accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. --defaults-group-suffix=str Read not only the usual option groups, but also groups with the usual names and a suffix of str. If this option is given as ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. Query result rows are determined from ...The query rows related to the current row over which function evaluation occurs comprise the window for the current ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
A WHERE clause predicate that contains only inner references is not eligible for transformation, since it can be evaluated before the grouping. This is made possible by adding a cardinality check without grouping in the derived table. A correlated ... A correlated subquery is a subquery that contains a reference to a table that also appears in the outer ...