Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance_schema_locker_lost How many events are “lost” or not recorded, due to the following conditions: Events are recursive (for example, waiting for A caused a wait on B, which caused a wait on C). Performance_schema_metadata_lock_lost The ...Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
With this method, also include a password so that if the account is unlocked later, it cannot be accessed with no password. (If the validate_password component is enabled, creating an account without a password is not permitted, even if the account ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
PURGE BINARY LOGS cannot be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of the backup lock by removing files from the server. PURGE BINARY LOGS { TO 'log_name' | BEFORE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its current binary log coordinates and dump its data, before permitting the source to continue executing statements. If you are using ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
Example: SELECT * INTO @myvar FROM t1; Before a trailing locking clause. The position before a locking clause is deprecated; expect support for it to be removed in a future version of MySQL. INTO form of SELECT enables a query result to be stored in ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options: DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE DISABLE_PSI_IDLE DISABLE_PSI_MEMORY ... The CMake ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
STOP GROUP_REPLICATION does not complete until either the situation is resolved (for example, by the lock being released), or the component timeout expires and the modules are shut down regardless of their status. This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/version-tokens.html
An application can use token locks to indicate to other cooperating applications that tokens are in use and should not be modified. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement. This might result in quicker lock release than the MERGE ... The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard ...