Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
You can delete all rows from one or more selected partitions using ALTER TABLE ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' GROUP BY store_id;, MySQL can quickly determine that only partition p2 needs to be scanned because the remaining ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-component-scheduler-tasks-table.html
For example, the audit_log server plugin utilizes the scheduler component to run a regular, recurring flush of its memory cache: mysql> select * from performance_schema.component_scheduler_tasks\G *************************** 1. 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-filtering.html
To enable or disable a consumer, set its ENABLED value to YES or NO. If you disable a consumer, the server does not spend time maintaining destinations for that consumer. For example, if you do not care about historical event information, disable ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-lock-waits-table.html
Example data lock wait information: mysql> SELECT * FROM performance_schema.data_lock_waits\G *************************** 1. The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
Example error event summary information: mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_RAISED <> 0\G *************************** 1. The Performance Schema maintains summary tables for aggregating ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
Consequently, values selected from the DIGEST_TEXT column of statement event tables may appear to exceed the performance_schema_max_digest_length value. SELECT_FULL_JOIN Like the Select_full_join status variable, but specific to the statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so ...