Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... 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/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected option file. MySQL users should use the following guidelines to keep passwords secure. When you run a client ...
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-locks-table.html
(This event might have occurred before this particular lock request occurred, if the data structure is used to store multiple locks.) EVENT_ID The Performance Schema event that caused the lock. For information about which lock requests are blocked ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-table.html
The events_stages_history table contains the N most recent stage events that have ended per thread. Stage events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-long-table.html
The events_statements_history_long table contains the N most recent statement events that have ended globally, across all threads. Statement events are not added to the table until they have ended. When the table becomes full, the oldest row is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-table.html
The events_statements_history table contains the N most recent statement events that have ended per thread. Statement events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, ...