Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-querydomaintype.html
The domain type validates property names that are used to filter results. 4.3.3.5.1 Synopsis public interface QueryDomainType<E> extends, QueryDefinition<E> {// Public Methods public abstract PredicateOperand get(String propertyName); public ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-feeding.html
The MySQL Query Analyzer retrieves data from the Performance Schema. The Performance Schema supplies the statistical information about the queries, execution times, result counts and other data to display and analyze on the Query Analyzer page.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statments currently being executed in all MySQL active connections on the network. The pre-authenticated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table is offloaded and loaded into the MySQL HeatWave Cluster Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ... To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries.html
This section provides Information Schema and Performance Schema queries that you can use to retrieve MySQL HeatWave metadata. Note For queries that monitor MySQL HeatWave node status, memory usage, data loading, change propagation, and queries, see ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-query.html
Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information depending on what kind of query was executed. If the query is a SELECT statement, the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query.html
Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information depending on what kind of query was executed. If the query is a SELECT statement, the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/refman/8.4/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-query.html
int mysql_query(MYSQL *mysql, const char *stmt_str) Description Executes the SQL statement pointed to by the null-terminated string stmt_str. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or \g. If ...