PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/role-names.html
It is possible for a row in the mysql.user system table to serve as both an account and a role. Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
When run concurrently with STOP REPLICA, SHOW REPLICA STATUS returns without waiting for STOP REPLICA to finish shutting down the replication SQL (applier) thread or replication I/O (receiver) thread (or both). SQL_AFTER_GTIDS if the replication ...
https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. InnoDB performs a bulk load instead of inserting one index record at a time when ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-convenience-functions.html
If both geometry parameters are valid Cartesian Point or MultiPoint values in SRID 0, the return value is shortest distance between the two geometries on a sphere with the provided radius. If both geometry parameters are valid Point or MultiPoint ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
Calling this function with no arguments continues to work as it did in previous versions of MySQL, clearing both stderr and stdout, as well as clearing the stack trace and resetting the session time zone. For general information about stored ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-classifier.html
This method acts as a wrapper for both sys.ML_TRAIN and sys.ML_MODEL_LOAD, but is specific to the MySQL HeatWave AutoML classification task. Classifier Constructor Classifier.train() Classifier.fit() Classifier.predict() Classifier.predictProba() ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-forecaster.html
This method acts as a wrapper for both sys.ML_TRAIN and sys.ML_MODEL_LOAD, but is specific to MySQL HeatWave AutoML forecasting. Forecaster Constructor Forecaster.train() Forecaster.fit() Forecaster.predict() Forecaster.score() Forecaster.unload() ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
If semijoin and materialization are both on, semijoins also use materialization where applicable. If semijoin and materialization are both on, semijoins also use materialization where applicable. Its value is a set of flags, each of which has a ...
https://dev.mysql.com/doc/refman/9.7/en/symbolic-links-to-tables.html
Note The path used with either or both of the DATA DIRECTORY and INDEX DIRECTORY options may not include the MySQL data directory. Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are ...