Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-validation.html
(Executing the preceding example with the option order reversed produces a message that --defaults-file itself is unknown.) . MySQL supports a --validate-config option that enables the startup configuration to be checked for problems without ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
If both --defaults-file and --local-service are given following the service name, they can be in any order. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
Since nontransactional statements cannot be rolled back, in order to guarantee crash-safe replication, only transactional tables should be used. The server shutdown process takes place as follows: The shutdown process is initiated. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
If more than one of the Key values applies to a given column of a table, Key displays the one with the highest priority, in the order PRI, UNI, MUL. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Note The SHOW PROFILE and SHOW PROFILES statements are ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
The right-most leaf page at the necessary B-tree depth is allocated and entries are inserted according to their sorted order. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
ST_Distance_Sphere() handles its arguments as described in the introduction to this section, with these exceptions: Supported geometry argument combinations are Point and Point, or Point and MultiPoint (in any argument order). The functions in this ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
Observe that the order of coordinates depends on the SRID used. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-operator-functions.html
Up to one strategy of each type may be specified, and they may be given in any order. OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable ...