Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
Each wait event summary table has one or more grouping columns to indicate how the table aggregates events. The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements. The MySQL Performance Schema is a feature for ...
https://dev.mysql.com/doc/refman/8.4/en/preface.html
This is the Reference Manual for the MySQL Database System, for the 8.4.6 LTS release. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 8.4 and previous ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
The following sections list the possible Command values, and State values grouped by category. The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 7.1.9, “Using System Variables”. Most of these program variables also ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
my_print_defaults A utility that shows which options are present in option groups of option files. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
To replace the value of gtid_purged with a specified GTID set, use the following statement: SET @@GLOBAL.gtid_purged = 'gtid_set'; Group Replication must be stopped before changing the value of gtid_purged. The MySQL Server system variables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
Instead, ensure that the default encryption setting on a replica matches the encryption status of the tablespaces that it replicates, and that replication group members have the same default encryption setting, so that the privilege is not needed.