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/partitioning-hash.html
You should be aware that, if a table has any unique keys, every column used in the partitioning expression for this table must be part of every unique key, including the primary key. This has to do with the fact that the more nonlinear an expression ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. The FEDERATED storage ...To include the FEDERATED storage engine if you build MySQL from source, invoke CMake with the -DWITH_FEDERATED_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
A “record” in the keystore consists of data (the key itself) and a unique identifier through which the key is accessed. The function stores into it a pointer to the buffer containing the fetched key data. The type and length values must be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-gr-memory-monitoring-ps-instruments.html
Gcs_message_data::m_buffer: Memory allocated for the transaction data payload sent to the network. certification_data_gc: Memory allocated for the GTID_EXECUTED sent by each member for garbage collection. transaction_data: Memory allocated for ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...On ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
On Unix, the same manager thread also handles Unix socket file connection requests. In this connection thread model, there are as many threads as there are clients currently connected, which has some disadvantages when server workload must scale to ... This section describes aspects of how the MySQL server manages client ...On all platforms, an additional network ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not found, the statement fails with an error (partition 'partition_name' doesn't exist). Partition ... Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
With neither of these modifications, REVOKE either succeeds for all named users and roles, or rolls back and has no effect if any error occurs; the statement is written to the binary log only if it succeeds for all named users and roles. To use the ...[IGNORE UNKNOWN USER] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names” } The REVOKE statement enables system administrators to revoke privileges and roles, which can be revoked from user accounts and ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
An error occurs if the argument is not a valid JSON document. An error occurs if the json_doc argument is not a valid JSON document or the path argument is not a valid path expression. Prior to MySQL 8.0.26, an error is also raised if the path ...An ...