Search Results
https://dev.mysql.com/doc/heatwave-aws/en/autopilot-index-advisor.html
The goal of Autopilot Index Advisor is to generate secondary index recommendations that optimize the overall workload performance. Autopilot Index Advisor 11 Autopilot Index Advisor Autopilot Index Advisor provides secondary index suggestions to ...
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
MySQL HeatWave GenAI In-database Vector Store 14.3 MySQL HeatWave GenAI In-database Vector Store The automated, in-database vector store enables customers to use MySQL HeatWave GenAI with their business documents without moving data to a separate ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
predicted_bp_size_gb: The predicted buffer pool size for optimal performance with this workload in GB. Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-creating.html
If you have not loaded data into your DB System, and you want to estimate the optimal MySQL HeatWave Cluster size, load data into the DB System before you create a MySQL HeatWave Cluster. Creating a MySQL HeatWave Cluster 4.1 Creating a MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Warning Changing privileges and permissions improperly on MySQL can potentially cause your server installation to have non-optimal security properties. This section explains the symptoms and resolutions for the most commonly encountered issues with ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Warning When using statement-based logging for replication, it is possible for the data on the source and replica to become different if a statement is designed in such a way that the data modification is nondeterministic; that is, it is left up to ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_autotune_concurrency Command-Line Format --clone-autotune-concurrency System Variable clone_autotune_concurrency Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON When clone_autotune_concurrency is enabled (the ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
If no type conversion is needed for the values in the IN() list, they are all non-JSON constants of the same type, and expr can be compared to each of them as a value of the same type (possibly after type conversion), an optimization takes place.
https://dev.mysql.com/doc/refman/8.4/en/counting-rows.html
See Section 14.19.1, “Aggregate Function Descriptions” for information about COUNT(expr) behavior and related optimizations. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because ...