Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because ...For small numbers of tables (typically less than 7 to 10) this is not a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. To check the autocommit setting: mysql> SHOW VARIABLES LIKE 'autocommit'; +---------------+-------+ | Variable_name | Value | ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-deploying-query-privatelink.html
Figure 6-1 illustrates the different components that make up a Query PrivateLink connection from your AWS VPC to your MySQL HeatWave on AWS DB System. (Optional) For security purposes, remove public connectivity to your MySQL HeatWave on AWS DB ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: Choose this script to install the Rewriter plugin and its associated elements.
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-sample-queries.html
This section describes sample queries using the instruments and events for monitoring Group Replication memory usage. The memory data can be queried for individual events, for example: SELECT * FROM ...row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Errors can occur under these circumstances: Either the pattern or the replacement is an incorrect SQL statement that produces syntax errors. Rewriter_number_rewritten_queries The number of queries rewritten by the Rewriter query rewrite plugin since ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
The main queries enable you to retrieve data from the monitored server. When defining queries, the following restrictions apply: The query must be defined within a <![CDATA[]]> container. Do not define queries which take longer to run than the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-queries.html
Running MySQL HeatWave Queries 10.1 Running MySQL HeatWave Queries When a MySQL HeatWave Cluster is enabled and the data you want to query is loaded in MySQL HeatWave, queries that qualify are automatically offloaded from the MySQL DB System to the ...Simply run the query from the Query Editor, as described above, or from a MySQL client that is connected to the DB ...