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/performance-schema-quick-start.html
Tables in the performance_schema database can be grouped according to the type of information in them: Current events, event histories and summaries, object instances, and setup (configuration) information. For detailed information about the tables ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. The number of applier threads on a replica or Group Replication group member is set by the replica_parallel_workers or ...For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
Tables that contain information about Group Replication members: replication_group_members: Provides network and status information for group members. replication_group_member_stats: Provides statistical information about group members and ...This ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/semijoins.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.0/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.0/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.0/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.0/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, ...