Search Results
https://dev.mysql.com/doc/internals/en/strings-directory.html
Often the MySQL changes are attempts to optimize the standard libraries. It doesn't seem that anyone tried to optimize for recent Pentium class processors, though. But again, they look like optimizations for old members of the Intel processor family. Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
All traces have the same basic structure, but if a statement uses subqueries, there are several join preparations/optimizations/executions, subquery-specific transformations not shown here... The statement's execution is naturally made of "steps": ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
In addition, queries are optimized to detect whether columns of the primary key are specified as part of the query criteria, and if so, a primary key lookup or scan is executed as a strategy to implement the query. As with primary keys, if a query ...To insert a new row into the table, first create a new instance of ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb-cluster-connection.html
set_data_node_neighbour() Sets a neighbor node for for optimal transaction coordinator placement set_max_adaptive_send_time() Set timeout to elapse before adaptive send forces the sending of all pending signals. This section provides information ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
The Auto Parallel Load utility facilitates the process of loading data by automating required steps and optimizing the number of parallel load threads. After running a number of queries, use the MySQL HeatWave Autopilot Advisor to optimize the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
The optimizer uses both types of statistics when possible, and neither fully replaces the other. Therefore, they can help query optimization when a table is being filtered using ranges, equalities, inequalities, and IN() or NOT IN() with constants ... As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
expr IN (value,...) comparisons where the expression is a single value and compared values are constants of the same data type and encoding are optimized for performance. What's Next Learn how to perform the following tasks: Run queries Modify ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
These columns are typically not needed for analytic queries and are therefore omitted to optimize memory usage and performance. What's Next Workload Optimization for OLAP Workload Optimization for OLTP . In MySQL HeatWave, you can explicitly ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
To avoid offloading inexpensive queries to MySQL HeatWave, the optimizer uses a query cost estimate threshold value. The query cost threshold unit value is the same unit value used by the MySQL optimizer for query cost estimates. Solution A: Your ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-models.html
It can identify common anomaly types, such as local, global, and clustered anomalies, and can achieve an AUC score that is similar to, or better than, when identifying the following: Global anomalies compared to KNN, with an optimal k hyperparameter ... You can use the following anomaly detection model types: GkNN (Generalized kth Nearest Neighbors) PCA (Principal Component Analysis) (As of MySQL 8.4.0) GLOF (Generalized Local Outlier Factor) (As of MySQL 8.4.0) GkNN Model Generalized kth Nearest Neighbors (GkNN) is an algorithm model developed at ...