Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-features-qrti.html
Reading QRTi Values The queries listed on the Query Analyzer page also have a color-coded pie chart representing a breakdown of the values used in the QRTi calculation; green representing the optimal percentage, yellow the acceptable percentage, and ...It is a "quality of service" measurement for each query, and uses the Apdex formula for that calculation: Apdex on ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
By default, MySQL retrieves cached values for those columns from the mysql.index_stats and mysql.innodb_table_stats dictionary tables when the columns are queried, which is more efficient than retrieving statistics directly from the storage engine.
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you combine LIMIT ... If ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. Verify if the query is offloaded to MySQL HeatWave for processing. mysql> CREATE MATERIALIZED VIEW airport_US AS SELECT airport.* FROM ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using.html
The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution times. Similar queries with different literal values are combined for reporting ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Verify if the query is offloaded to MySQL HeatWave for processing. To ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-endpoint.html
Creating an Endpoint for a Query PrivateLink 6.1.3 Creating an Endpoint for a Query PrivateLink Use the AWS Management Console to create an endpoint in the same region and availability zone as the DB System. A VPC with subnet(s) in the same ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-explanation.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('classification_use_case', NULL); Use the ML_EXPLAIN_TABLE routine to generate explanations for predictions made in the test ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
mysql> SELECT JSON_PRETTY(model_explanation) FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle='regression_use_case'; +------------------------------------------------------------------------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
To write queries for these tables most efficiently, take advantage of their indexes. Tables that do not are those that normally contain few rows or are unlikely to be queried frequently. To see whether a given Performance Schema table has indexes ...