MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 351 to 360 of 364 total results

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-function-argument-handling.html

Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where ...

27.3.8 Using JavaScript Libraries

https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html

This section provides information about and examples of use of JavaScript libraries in JavaScript stored programs as supported by the Multilingual Engine (MLE) in MySQL Enterprise Edition. First we create a database jslib, and make it the current ...

27.3.10.1 AnomalyDetector Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-anomalydetector.html

AnomalyDetector Constructor AnomalyDetector.train() AnomalyDetector.fit() AnomalyDetector.predict() AnomalyDetector.score() AnomalyDetector.unload() This class encapsulates the anomaly detection task as described in Detect Anomalies.

27.3.10.2 Classifier Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-classifier.html

Classifier Constructor Classifier.train() Classifier.fit() Classifier.predict() Classifier.predictProba() Classifier.score() Classifier.explain() Classifier.getExplainer() Classifier.unload() This class encapsulates the classification task as ...

27.3.10.4 Forecaster Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html

Forecaster Constructor Forecaster.train() Forecaster.fit() Forecaster.predict() Forecaster.score() Forecaster.unload() This class encapsulates the forecasting task as described in Generate Forecasts. Forecaster supports methods for loading, ...

27.3.6.12 MySQL Functions

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-mysql.html

The following SQL built-in functions can be called directly from the mysql namespace. These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 ...

27.3.10.6 Recommender Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-recommender.html

Recommender Constructor Recommender.train() Recommender.fit() Recommender.predictRatings() Recommender.predictItems() Recommender.predictUsers() Recommender.predictSimilarItems() Recommender.predictSimilarUsers() Recommender.score() ...

27.3.10.7 Regressor Class

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html

Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() Regressor.score() Regressor.explain() Regressor.getExplainer() Regressor.unload() This class is similar to Classifier and Forecaster in that it represents an AutoML ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. 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 ...

10.4.3.1 How MySQL Opens and Closes Tables

https://dev.mysql.com/doc/refman/9.7/en/table-cache.html

When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.

Displaying 351 to 360 of 364 total results