Search Results
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
This enables users to set sort_buffer_size to larger values to speed up larger sorts, without concern for excessive memory use for small sorts. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation ...
https://dev.mysql.com/doc/refman/8.4/en/password-security.html
The following sections provide guidelines that enable end users and administrators to keep these passwords secure and avoid exposing them. In addition, the validate_password plugin can be used to enforce a policy on acceptable password.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... The Performance Schema maintains the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
PRIVILEGE_CHECKS_USER The user account that provides the security context for the channel (CHANGE REPLICATION SOURCE TO option: PRIVILEGE_CHECKS_USER). This table shows the configuration parameters that affect transactions applied by the replica.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: users_lost METER: mysql.perf_schema METRIC_TYPE: ASYNC COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: The number of times a row could not be added to the users table because it was full ... The setup_metrics table ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
Memory Caches: Different applications respond better to some memory caching strategies than others, so although some memory caches are common to all storage engines (such as those used for user connections), others are uniquely defined only when a ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...