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/mysql-cluster-overview-requirements.html
Where communication latencies between data nodes are expected to be higher than would be expected in a LAN environment (on the order of 100 µs), timeout parameters must be increased to ensure that any allowed periods of latency periods are well ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
Important Before copying, verify that all the files relating to the existing replica actually are stored in the data directory. InnoDB tablespace files and file-per-table tablespaces might have been created in other directories. During copying, if ...To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
These keyring components are available: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host. These ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. For replication from NDB to a ...A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in ...This option can be used only in conjunction with the -o (--order) ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
If you are not in the database directory, you should specify the path name to the file. --backup, -b Command-Line Format --backup Make a backup of each table's data file using the name tbl_name.OLD. (myisampack creates an intermediate file named ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and initialize each one. mysql-8.0/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-8.0 --datadir=$PWD/data/s1 ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
The RECURSIVE keyword must be included if any CTE in the WITH clause is recursive. (If no CTE refers to itself, RECURSIVE is permitted but not required.) If you forget RECURSIVE for a recursive CTE, this error is a likely result: ERROR 1146 (42S02): ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...Common Table Expressions Recursive Common Table Expressions Limiting Common Table Expression Recursion Recursive Common Table Expression Examples Common Table Expressions ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
If you are removing unwanted transactions from that GTID set, use mysqlbinlog to examine the contents of the transactions to ensure that they have no value, contain no data that must be saved or replicated, and did not result in data changes on the ...Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed ...