PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-initial-start.html
(For more information, see Section 25.3.2.4, “Installing NDB Cluster Processes as Windows Services”.) Do not start the SQL node yet; it cannot connect to the cluster until the data nodes have finished starting, which may take some time. You can ... Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-installation.html
As of NDB 8.0.22, NDB supports IPv6 for connections between all NDB Cluster nodes. In NDB 8.0.21 and earlier releases, all network addresses used for connections to or from data and management nodes must use or be resolvable using IPv4, including ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-single-user-mode.html
When entering single user mode, connections to all other API nodes are closed gracefully and all running transactions are aborted. Note When the preceding command is invoked, all transactions running on the designated node are aborted, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...See Section 15.7.7.15, “SHOW ENGINE Statement”, for a usage example and more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Replicas store the password for the replication source server in their connection metadata repository, which by default is a table in the mysql database named slave_master_info. The use of a file in the data directory for the connection metadata ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
For example, the statement/com/Connect and statement/com/Init DB instruments correspond to the COM_CONNECT and COM_INIT_DB commands. The instruments associated with listening sockets for TCP/IP or Unix socket file connections have a socket_type ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
For example, the wait/synch/mutex/sql/THD::LOCK_query_plan mutex is created each time a session connects, and destroyed when the session disconnects. Due to constraints on name lengths with respect to potentially large numbers of connections, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
For example, if there is an instrument for a mutex that is created for each connection, there are as many instances as there are connections. For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the source. If you are using a large number of replicas connected to one source, and that source is ...Also, as each replica must receive a full copy of the source's binary log, the network load on the source may also increase and create a ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. This enables assignment of sets of privileges to accounts and ...