Search Results
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 16.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 HeatWave Cluster size, load data into the DB System before you create a HeatWave Cluster. Creating a HeatWave Cluster 4.1 Creating a HeatWave Cluster A HeatWave ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
It is also possible to create an index on a JSON column using the JSON_VALUE() function with an expression that can be used to optimize queries employing the expression. A secondary index defined on a virtual column is sometimes referred to as a ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
For more information, see Section 27.5.2, “View Processing Algorithms”, as well as Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”. If the view does not exist, ...