Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...Prior to version 8.0.29, this property was named 'parseInfoCacheFactory', which remains as an ...
https://dev.mysql.com/doc/connectors/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/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/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-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 ...