Search Results
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
In order to call mysql_execute_command (the function that executes a statement) for a prepared statement and not damage its parse tree, we backup and restore the active Query_arena of THD. In other words, the arena which was active when ...We don't ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is used. The scalar IN subquery will be replaced with an Item_in_optimizer item. On a value request (one of val, val_int, or val_str methods) it evaluates the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). Normally, mysqldumpslow groups queries that are similar except for the particular values of number and ...It ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-priority-queue.html
MySQL HeatWave uses a workload-aware, priority-based, automated scheduling mechanism to schedule concurrently issued queries for execution. MySQL 9.0.0 introduces a novel scheduler that a MySQL HeatWave Cluster uses to run multiple concurrent ...A ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
A Query instance represents a specific query with bound parameters. Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON ...The rpd_query_stats table has these columns: CONNECTION_ID The ID of the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/quan-advisor-ref.html
The possible values are: Yes: generate an event for each normalized query that exceeds a threshold No: generate a single event per MySQL Server summarizing all queries that exceed the thresholds. No: generate a single event, per MySQL server, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-slowquerylogging-category.html
Table 7.32 Slow Query Logging Configuration Metrics NameDescriptionLog Queries Not Using Indexes Enabled If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. Log Slow Queries ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-ui.html
To open the Query Analyzer, select Queries from the navigation menu. Figure 32.1 Default Query Analyzer View Table 32.2 Controls of the default Query Analyzer view Control Description Filters Query Analyzer: contains the following default, system ...
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 ...