Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.16, “SHOW ENGINE Statement”, for a usage example and more detailed ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/en/performance-schema-tp-thread-group-state-table.html
CONNECT_THREAD_COUNT The number of threads that are processing or waiting to process connection initialization and authentication. There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity.
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server-troubleshooting.html
If you do not get an error message like telnet: Unable to connect to remote host: Connection refused, some other program is using the TCP/IP port that mysqld is trying to use. In this case, specify the same non-default port number for client ...