https://dev.mysql.com/table-locking.html
To specify that all updates issued in a specific connection should be done with low priority, set the low_priority_updates server system variable equal to 1. InnoDB tables use row-level locking so that multiple sessions and applications can read ...
https://dev.mysql.com/test-pluggable-authentication.html
To uninstall it, use UNINSTALL PLUGIN: UNINSTALL PLUGIN test_plugin_server; To use the test authentication plugin, create an account and name that plugin in the IDENTIFIED WITH clause: CREATE USER 'testuser'@'localhost' IDENTIFIED WITH ... MySQL ...
https://dev.mysql.com/thread-information.html
Each process list entry contains several pieces of information: Id is the connection identifier for the client associated with the thread. When you are attempting to ascertain what your MySQL server is doing, it can be helpful to examine the ...
https://dev.mysql.com/thread-pool-tuning.html
If a long-running statement was permitted to block a thread group, all other connections assigned to the group would be blocked and unable to start execution until the long-running statement completed. This section provides guidelines on setting ...
https://dev.mysql.com/tp-thread-state-table-old.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA ...
https://dev.mysql.com/upgrading.html
SQL statements can be executed using the mysql command-line client (connect as root to ensure that you have the necessary privileges). This section describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up ...
https://dev.mysql.com/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...
https://dev.mysql.com/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...
https://dev.mysql.com/what-is-crashing.html
This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...
