Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Blocking also occurs after rollbacks that are written to the binary log, which occurs when a transaction that modifies nontransactional tables is rolled back. The rolled-back transaction is logged even though it has no effect for transactional ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
When these Performance Schema instrument stages are enabled the events_stages_current table shows stages for applier threads and their progress. For background information, see Section 29.12.5, “Performance Schema Stage Event Tables”. The ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
RESET PERSIST affects the contents of the Performance Schema persisted_variables table because the table contents correspond to the contents of the mysqld-auto.cnf file. On the other hand, because RESET PERSIST does not change variable values, it ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column Properties. It is possible for a row in the mysql.user system table to serve as both an account and a role. MySQL role ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/8.4/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like ...