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/connection-control-component-configuration.html
The Connection Control component exposes the following system variables: component_connection_control.failed_connections_threshold: This is the number of consecutive failed connection attempts by a given account which are allowed before the server ...
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
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 attempts. This ...
https://dev.mysql.com/doc/refman/9.7/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
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
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] [schema_name.]view_name AS json_duality_select_statement json_duality_select_statement: SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...
https://dev.mysql.com/doc/refman/9.7/en/create-resource-group.html
CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...