Search Results
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. All subquery forms and operations that the SQL standard requires are ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: ref_or_null possible_keys: maybe_null_key key: maybe_null_key key_len: 5 ref: func rows: 2 Extra: Using where; Using index ... Triggered equalities can be used by ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. MySQL also implements certain ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html
Also, target hosts running the client application must have the Visual C++ Redistributable for Visual Studio 2015 installed. This section provides guidelines for compiling C programs that use the MySQL C API. Compiling MySQL Clients on Unix ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Table 8.26 Plugin and Library Names for WebAuthn Authentication Plugin or File Plugin or File Name Server-side plugin authentication_webauthn Client-side plugin authentication_webauthn_client Library file authentication_webauthn.so, ... Note ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.1-ndb-8.4.1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). ndbinfo Information Database: Added a type column to the transporter_details table in the ...