https://dev.mysql.com/general-thread-states.html
Waiting on cond A generic state in which the thread is waiting for a condition to become true. The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/glossary.html
When this assumption is true, the database does little unnecessary work; when requests do fail, extra work must be done to clean up and undo changes. These terms are commonly used in information about the MySQL database server. This glossary ...
https://dev.mysql.com/grant.html
This is also true in MySQL if you use DROP USER. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: ...
https://dev.mysql.com/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/group-replication-failure-detection.html
Later if the group agrees that the suspicions are probably true, then the group decides that a given server has indeed failed. Group Replication includes a failure detection mechanism that is able to find and report which servers are silent and as ...
https://dev.mysql.com/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/if.html
If a given search_condition evaluates to true, the corresponding THEN or ELSEIF clause statement_list executes. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() ...
https://dev.mysql.com/index-hints.html
This is true even if the hint is given for a non-FULLTEXT index. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 8.9.3, ...
https://dev.mysql.com/innodb-and-mysql-replication.html
This is true whether you are using statement-based or row-based replication. MySQL replication works for InnoDB tables as it does for MyISAM tables. It is also possible to use replication in a way where the storage engine on the slave is not the ...
https://dev.mysql.com/innodb-file-space.html
The 768-byte prefix is accompanied by a 20-byte value that stores the true length of the column and points into the overflow list where the rest of the value is stored. The data files that you define in the configuration file using the ...
