PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin.html
The clone plugin permits cloning data locally or from a remote MySQL server instance. Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. The cloned data comprises a ...
https://dev.mysql.com/doc/refman/9.7/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-using-dns-srv.html
MySQL supports use of DNS SRV records to connect to servers in these contexts: Several MySQL Connectors implement DNS SRV support; connector-specific options enable requesting DNS SRV record lookup both for X Protocol connections and for classic ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component-configuration.html
Both external_user@example.com and proxy_user@example.com must have valid entries in the mysql.user system table and a proxy relationship between them must be defined in the mysql.proxies_priv system table (see Section 8.2.19, “Proxy Users”).
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component-installation.html
The Connection Control Component is available in both the Community and Enterprise distributions of MySQL. While it can be used with the default settings, you may wish to tune its operations to meet conditions specific to your environment. The next ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component.html
URN: file://component_connection_control component_connection_control was introduced in MySQL 9.2.0 as a single replacement for both Connection Control plugins, which are now deprecated (see Section 8.4.3, “Connection Control Plugins”, for more ... The Connection Control component for MySQL (component_connection_control) makes it possible to introduce an increasing delay in the MySQL server's response to connection attempts after an arbitrary number of consecutive failed ...
https://dev.mysql.com/doc/refman/9.7/en/connection-options.html
To ensure that a new, unrelated connection opens after session reuse fails silently, invoke MySQL client programs with both the --ssl-session-data and --ssl-session-data-continue-on-failed-reuse command-line options. This section describes options ...
https://dev.mysql.com/doc/refman/9.7/en/constant-folding-optimization.html
Previously, this was handled by treating both operands as the larger type, but now, since any allowed value for c is less than the constant, the WHERE expression can instead be folded as WHERE 1, so that the query is rewritten as SELECT * FROM t ...
https://dev.mysql.com/doc/refman/9.7/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. Because of this, constraint handling is a bit different in MySQL than in other DBMSs. We must handle the case when you have ...
https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html
Both schema_name and root_table_name must follow the usual rules for MySQL identifiers. CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] ...