Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. The ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The configuration descriptions occur in order of increasing functionality and overhead. The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Its value is a pipeline of log filter and log sink components to be executed in left-to-right order when error events occur. Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
Assume a join query of the following form that is executed using a table join order of t1, t2, t3: SELECT ... The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-account-connect-attrs-table.html
ORDINAL_POSITION The order in which the attribute was added to the set of connection attributes. Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-connect-attrs-table.html
ORDINAL_POSITION The order in which the attribute was added to the set of connection attributes. Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED values. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
Longer instrument name strings take precedence over shorter pattern names, regardless of order. To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start ...