https://dev.mysql.com/dbug-package.html
May be followed by a list (containing only one modifier) giving a numeric maximum trace level, beyond which no output occurs for either debugging or tracing macros. The MySQL server and most MySQL clients are compiled with the DBUG package ...
https://dev.mysql.com/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/error-summary-tables.html
Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of ...
https://dev.mysql.com/extensions-to-ansi.html
MySQL Server supports some extensions that you probably will not find in other SQL DBMSs. Be warned that if you use them, your code will not be portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/fips-mode.html
On the server side, numeric ssl_fips_mode values of 0, 1, and 2 are equivalent to OFF, ON, and STRICT, respectivey. MySQL supports FIPS mode, if compiled using OpenSSL, and an OpenSSL library and FIPS Object Module are available at runtime. FIPS ...
https://dev.mysql.com/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join ...
https://dev.mysql.com/group-replication-options.html
group_replication_consistency Property Value Command-Line Format --group-replication-consistency=value Introduced 8.0.14 System Variable group_replication_consistency Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/host-cache-table.html
MySQL does not perform matching of Host column values in the mysql.user system table against host names for which one or more of the initial components of the name are entirely numeric, such as 1.2.example.com. The host_cache table provides access ...
https://dev.mysql.com/innodb-adaptive-hash.html
If there are numerous threads waiting on RW-latches created in btr0sea.c, consider increasing the number of adaptive hash index partitions or disabling the adaptive hash index feature. The adaptive hash index feature enables InnoDB to perform more ...
