Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
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 partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...
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-component-scheduler-tasks-table.html
The component_scheduler_tasks table contains a row for each scheduled task. Each row contains information about the ongoing progress of a task that applications, components, and plugins can implement, optionally, using the scheduler component (see ...
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
The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks table. Held locks in data_locks appear in data_lock_waits only if they ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of server errors, see Server Error Message Reference. Collection of error information is controlled by the error ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...