Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
The default CommandType type, Text, is used for executing queries and other SQL commands. The MySqlCommand class represents a SQL statement to execute against a MySQL database. Class methods enable you to perform the following database operations: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-add-attribute.html
Syntax: cursor.add_attribute(name, value) Adds a new named query attribute to the list, as part of MySQL server's Query Attributes functionality. name: The name must be a string, but no other validation checks are made; attributes are sent as is to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/custom-xml-reference.html
For more information, see Section 31.2.2.2, “Main Queries” attributes Enables you to label the types of data returned by the query. For example, the precondition query can be used to check the version of the MySQL server. It is also possible to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
MySQL HeatWave tracks the amount of base relation data scanned by all queries collectively and by individual queries. To view a cumulative total of data scanned (in MB) by all successfully executed MySQL HeatWave queries from the time the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges.
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This offloading reduces execution time, especially for long-running and complex queries. However, it may not be beneficial for SELECT queries that produce large result sets, as the large volume of DML operations on the DB System can limit ... This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Auto Query Time Estimation provides runtime information for successfully executed queries and runtime estimates for EXPLAIN queries, queries cancelled with Ctrl+C, and queries that fail due to out of memory errors. The recommendations are based upon ... Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to optimize for JOIN and GROUP BY query ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification. This can be done using either of the functions detailed in this section, both of which take two arguments, a JSON schema, and a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...