https://dev.mysql.com/wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 26.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...
https://dev.mysql.com/while.html
[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...
https://dev.mysql.com/windows-create-option-file.html
This is particularly true under the following circumstances: The installation or data directory locations are different from the default locations (C:\Program Files\MySQL\MySQL Server 8.0 and C:\Program Files\MySQL\MySQL Server 8.0\data). If you ...
https://dev.mysql.com/windows-postinstallation.html
If that is not true, adjust the command path names accordingly. GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data ...
https://dev.mysql.com/working-with-null.html
In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...
https://dev.mysql.com/writing-audit-plugins.html
This is also true if an audit plugin uses the my_message() function to terminate a nonterminable event. This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL ...
https://dev.mysql.com/writing-authentication-plugins.html
For example, this might be true if the server plugin authenticates only local clients and uses some property of the operating system rather than the information sent by the client plugin. MySQL supports pluggable authentication, in which plugins ...
https://dev.mysql.com/writing-password-validation-plugins.html
This section describes how to write a server-side password-validation plugin. The instructions are based on the source code in the plugin/password_validation directory of MySQL source distributions. The validate_password.cc source file in that ...
https://dev.mysql.com/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. XA transaction support is limited to the InnoDB storage engine. For “external XA,” ...
https://dev.mysql.com/xml-functions.html
Table 12.15 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
