Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connection-control.html
The connection-control plugin library enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed attempts. This capability provides a deterrent that slows down ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN queries. Runtime estimates for queries that fail due to an out-of-memory error. Runtime data can be used for query optimization, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for each node that participates in the query. For MySQL HeatWave AutoML routines that include ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to optimize for JOIN and GROUP BY query performance. Apply these optimizations manually, or ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-27-u2.html
Functionality Added or Changed MySQL HeatWave now supports querying views. For MySQL HeatWave queries that join large and small relations, bloom filters reduce the amount of data processed by early filtering and the amount of memory used during ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-workload-perf-data.html
MySQL HeatWave Workload Performance Data 17.2.2.1 MySQL HeatWave Workload Performance Data The HeatWave Workload tab provides the following performance data for your MySQL HeatWave Clusters: Information is shown for the last 1000 query executions.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-session-variables.html
Session Variables 19.9 Session Variables Session variables remain in effect during the session until the variable changes or the session ends. For new connections, a session variable value is initialized with the corresponding global system ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-shape-dependent-system-variables.html
Shape-Dependent System Variables 19.8 Shape-Dependent System Variables Shape-dependent global system variables are linked to, and tuned for, a specific MySQL shape.