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/checking-gpg-signature.html
The signature file has the same name as the distribution file with an .asc extension, as shown by the examples in the following table. Here are explanations for these warnings: gpg: no ultimately trusted keys found: This means that the specific key ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... ANALYSE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/drop-logfile-group.html
The log file group must already exist or an error results. DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 15.1.16, ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
The number of parallel threads that sort and load data is controlled by the innodb_ddl_threads variable, introduced in MySQL 8.0.27. The actual number of threads that scan the clustered index is the number defined by the innodb_parallel_read_threads ...The maximum setting is 256, which is the maximum number for all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
The following command options support channel specific replication filters using this format: --replicate-do-db=channel:database_id --replicate-ignore-db=channel:database_id --replicate-do-table=channel:table_id ...Channel specific replication ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
This column is reserved for future use, in case new error conditions must be reported, and if preserving the backward compatibility and structure of the host_cache table is required. While HOST_VALIDATED is NO, DNS resolution is attempted for each ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
System Variable server_uuid Scope Global Dynamic No SET_VAR Hint Applies No Type String When starting, the MySQL server automatically obtains a UUID as follows: Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir ...For servers that are used in a replication topology, you must specify a unique server ID for each replication server, in the range from 1 to 232 − ...Options and variables ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. You might ...Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump includes the contents of the gtid_executed set in the dump to transfer these to the new ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...Synonym for JSON_MERGE_PRESERVE(); ...