Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-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 stage summary table that is ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
For other 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 statement summary table that ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. The ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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. To do this, on the replica, execute the ...
https://dev.mysql.com/doc/refman/8.4/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 ...