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/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
server_id=1 gtid_mode=ON enforce_gtid_consistency=ON These settings configure the server to use the unique identifier number 1, to enable Section 19.1.3, “Replication with Global Transaction Identifiers”, and to allow execution of only ... This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
Follow this procedure to restart a replication group safely after every member shuts down. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-throttling.html
This means that every member has an established write quota based on the available capacity, in other words a number of transactions it can safely issue for the next period. Based on the metrics gathered across all servers in the group, a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade.html
Group Replication includes compatibility policies that enable you to safely combine members running different versions of MySQL in the same group during the upgrade procedure. This section explains how to upgrade a Group Replication setup. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
The safest network configuration for Cluster is one which isolates connections between Cluster nodes from any other network communications. This network setup is safest because no packets can reach the cluster's management or data nodes from outside ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise.html
Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...