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/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as a written record of all events that modify database structure or content (data) from ...Each replica that connects to the source requests a copy of the binary ...See Section 10.14, “Examining Server Thread ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. In most cases, you can check whether MySQL data streams are unencrypted by ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
When binary log transaction compression is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). However, the effort required for data ...Compressed transaction payloads remain in a compressed state while they are sent in the replication stream to replicas, other Group Replication group members, or clients such as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
With this setting, the contents of the InnoDB redo log buffer are written out to the log file at each transaction commit and the log file is flushed to disk. However, the replica notices the network outage only after receiving no data from the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
(You must be using MySQL NDB Cluster with the NDB storage engine to create NDB tables.) InnoDB storage engine. CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux.html
Each NDB Cluster host computer must have the correct executable programs installed. Management nodes require the management server daemon (ndb_mgmd); data nodes require the data node daemon (ndbd or ndbmtd). It is not necessary to install the MySQL ... This section covers installation methods for NDB Cluster on Linux and other Unix-like operating ...For manual installation and setup ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
For the server, one exception applies: The mysqld-auto.cnf option file in the data directory is processed last, so it takes precedence even over command-line options. List the options in an option file that the program reads when it starts. It ...If ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log plugin must be enabled or an error occurs. In addition, the audit tables must exist or an error ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...If the plugin is installed without the accompanying audit tables and functions needed ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
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 the same for each group. The following discussion demonstrates functional ...