Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
Other mutexes have an instance per connection, or per page in various caches and data buffers, so the number of instances varies over time. Increasing the maximum number of connections or the maximum size of some buffers increases the maximum number ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
To use client programs, mysqld must be running, because clients gain access to databases by connecting to the server. MySQL client programs that connect to the MySQL server: mysql The command-line tool for interactively entering SQL statements or ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs.html
The replica's connection metadata repository contains information that the replication receiver thread needs to connect to the replication source server and retrieve transactions from the source's binary log. The replica's connection metadata ... A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.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. After you have performed this procedure, the replica connects to the source and ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
A global status variable may represent status for some aspect of the server itself (for example, Aborted_connects), or the aggregated status over all connections to MySQL (for example, Bytes_received and Bytes_sent). With a SESSION modifier, the ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. To check whether a mysqld server supports encrypted connections, examine the value of the tls_version ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-id.html
See Section 14.21, “Performance Schema Functions” Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Parameters in_connection_id BIGINT UNSIGNED: ... Note ps_thread_id() is deprecated, and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. unique_hosts The number of distinct hosts from which connections for the user have originated. The user_summary and x$user_summary views have these columns: user ...