Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
Each statement summary table has one or more grouping columns to indicate how the table aggregates events. (The DIGEST_TEXT column contains the corresponding normalized statement digest text, but is neither a grouping nor a summary column. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-summary-tables.html
The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
It must not contain any aggregate functions (whether it is explicitly or implicitly grouped). A GROUP BY clause is permitted but ignored, unless the subquery also contains one or more aggregate functions. FirstMatch: When scanning the inner tables ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
MySQL distributions include loadable functions that implement, in whole or in part, these server capabilities: Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data ... MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and resolution, and group membership services all built-in. MySQL supports an ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ROLE and SET ROLE set the default role and current role for user accounts. Descriptions for those forms that ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
As with other aggregate functions, GROUP BY may be used to group arguments into subsets. MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. Limit Optimization Flags prefer_ordering_index (default ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. A global transaction involves several actions that are transactional in themselves, but that all must either complete successfully ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
Note For Linux and other Unix-like platforms, the mysql user was typically created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group ... For Linux and other Unix-like platforms: mysqlbackup does not record file ownership or permissions of the files that are backed ...