PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. In general, the rules governing event names are the same as those for names of stored routines. The ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This global parameter can be set only in the [ndbd default] section, and defines the number of fragment replicas for each table stored in the cluster. Warning Setting NoOfReplicas to 1 means that there is only a single copy of all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
(Single-threaded backups are restored as in previous versions of NDB.) It is also possible to restore backups taken in parallel using an ndb_restore binary from a previous version of NDB Cluster by modifying the usual restore procedure; Section ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. A key stored in the keyring by a given user can be manipulated later only by the same user. That is, ...MySQL Server also includes an SQL interface for keyring key management, implemented as a set of general-purpose functions that access the capabilities provided by the internal keyring ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--exclude-routines=routine_list Command-Line Format --exclude-routines=routine_list Type String Do not dump the events in routine_list, which is a list of one or more comma-separated routine (stored procedure or function) names. mysqlpump supports ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
The setup procedure also results in a store path of /v1/kv/mysql, which is the value to assign to keyring_hashicorp_commit_store_path. No key information is permanently stored in MySQL server local storage. (An optional in-memory key cache may be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
As of MySQL 8.0.28, the innodb_open_files limit can be set at runtime using a SELECT innodb_set_open_files_limit(N) statement, where N is the desired innodb_open_files limit; for example: mysql> SELECT innodb_set_open_files_limit(1000); The ...This ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
To avoid exposing these, applications can use stored procedures to encrypt and decrypt values on the server side. If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. If an application stores values from ...This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
For details of how stored programs (stored procedures and functions, triggers, and events) are handled when each binary logging format is set, see Section 27.7, “Stored Program Binary Logging”. Where possible, rows stored in the binary log are ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...