Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
This section describes how to set up your application to view MySQL trace information. The first thing you need to do is create a suitable app.config file for your application. The switch level in this case is set to Verbose to display the maximum ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
prefetch Prefetch from server by _ rows at a time 0 When set to a non-zero value N, causes all queries in the connection to return N rows at a time rather than the entire result set. Useful for queries against very large tables where it is not ...On ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made faster. With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. It ...
https://dev.mysql.com/doc/internals/en/prepared-stored.html
Conventional statements, that is, SQL queries sent in COM_QUERY protocol packet, are the only statements present in MySQL server prior to version 4.1. Let us start with a general description of the MySQL statement processing workflow in order to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-best-hybrid-ref.html
Users are assigned to roles with varying access to the groups. Development is the group of MySQL instances where the product is developed and tested. Production is the group of MySQL instances to which the finished product is deployed for customers ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-performance-schema.html
Note The maximum space available for digest computation is 1024 bytes by default; queries exceeding this length are truncated. Query Analyzer data is automatically collected and displayed by monitoring MySQL Server 5.6.14 or greater, using the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This offloading speeds up the execution of long-running and complex queries. However, if the SELECT query returns a large result set, queries that produce large result sets performance may be limited because inserting the data into the DB System ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
Identify all of the tables that your queries access to ensure that you load all of them into MySQL HeatWave. To minimize the number of MySQL HeatWave nodes required for your data, exclude table columns that are not accessed by your queries. Reserve ... This topic describes how to prepare your data for loading into MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-monitoring.html
mysql> SHOW GLOBAL STATUS LIKE 'rapid_ml_status'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | rapid_ml_status | ON | +-----------------+-------+ The following example queries the the rapid_ml_status status ...