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/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. When an application or authenticated user wants to access encrypted tablespace data, InnoDB uses a master encryption key to decrypt the tablespace key. The decrypted version of a tablespace key never changes, but the master encryption key can be changed as ... InnoDB supports data-at-rest ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html
SSL certificate and key files enable MySQL to support encrypted connections using SSL. RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password or ... The following ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-secretsfile-reader.html
ndb_secretsfile_reader gets the encryption key from an NDB encryption secrets file, given the password. Usage ndb_secretsfile_reader options file The options must include one of --filesystem-password or --filesystem-password-from-stdin, and the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--get-server-public-key Command-Line Format --get-server-public-key Type Boolean Request from the server the public key required for RSA key pair-based password exchange. For that plugin, the server does not send the public key unless requested. If ... 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/partitioning-overview.html
-MAXVALUE represents the greatest lower bound.) For [LINEAR] KEY, RANGE COLUMNS, and LIST COLUMNS partitioning, the partitioning expression consists of a list of one or more columns. For [LINEAR] KEY partitioning, the partitioning function is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is KEYHASH). ndb-log-exclusive-reads: Log primary key reads with exclusive locks; allow conflict resolution based on read conflicts. The following list ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
This would be the case, for example, were custid a primary key of customers. Disabling ONLY_FULL_GROUP_BY is useful primarily when you know that, due to some property of the data, all values in each nonaggregated column not named in the GROUP BY are ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...