PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/query-attribute-components.html
As of MySQL 8.0.23, a component service provides access to query attributes (see Section 11.6, “Query Attributes”). The query_attributes component uses this service to provide access to query attributes within SQL statements. Purpose: ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
In MySQL 8.0.31 and later, this plugin also supports a privilege (SKIP_QUERY_REWRITE) that protects a given user's queries from being rewritten. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event information to select from the events available after pre-filtering has been applied. Pre-filtering ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-installation.html
Note If installed, the Rewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script ...
https://dev.mysql.com/doc/refman/8.0/en/query-issues.html
...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | ...| ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
connection_memory_limit: Maximum amount of memory that can be consumed by any one user connection before all queries by this user are rejected. When exceeded by Global_connection_memory, all queries from regular users are rejected. log_slow_extra: ... Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
Read queries which set locks also cause operation records to be created. When queries make use of the unique hash index, there are actually two operation records used per record in the transaction. (NDB 8.0.13) For queries using a unique hash index, ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
You can control the general query and slow query logs during runtime. You can tell the server to write general query and slow query entries to log tables, log files, or both. For details, see Section 7.4.1, “Selecting General Query Log and Slow ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
--log-short-format Command-Line Format --log-short-format[={OFF|ON}] Type Boolean Default Value OFF Log less information to the slow query log, if it has been activated. --slow-start-timeout=timeout Command-Line Format --slow-start-timeout=# Type ...