PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/performance-schema-transaction-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each transaction summary table that is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
Statements that work with nontransactional engines have no effect on the transaction state of the connection. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
Examples: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; SET PERSIST_ONLY back_log = 100; SET @@PERSIST_ONLY.back_log = 100; MySQL also provides a RESET PERSIST statement for removing persisted system variables from ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
Static global privileges and passwords are unaffected for a connected client. Any user can connect and perform any operation, which is insecure. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for transmission, and should therefore be protected in transit by the use of connection encryption (see Section 8.3, “Using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. You must be able to connect to the source MySQL server using TCP/IP. The CHANGE REPLICATION SOURCE TO | CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. On each replica that you want to connect to the source, you must configure a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 8.0. Create a suitable user account on all the sources that ... A multi-source replication topology requires at least two sources and one replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If the replica is running, check whether it established a connection to the source. If the receiver thread state says Connecting to master, check the following: Verify the privileges for the replication user on the source. Check that the host name ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...