Search Results
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/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). First, let's create an example table, using the mysql client: mysql> ...The file bears the same name as the table, with an .frm ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
Note If the selected context is a cluster, the queries for the cluster's SQL nodes are displayed either for the specific node or for the cluster as an aggregate. Figure 32.8 Graph View Filter View Figure 32.9 Filter View The following are the ...
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-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/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-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 ...