Search Results
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-windows-binary.html
For this example, we refer to ndbd.exe as the data node executable, but you can install ndbmtd.exe, the multithreaded version of this program, instead, in exactly the same way. Note As with other Windows programs, NDB Cluster executables are named ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
Note:Click on the name of a system varuable in Table 19-7 to see its description in the MySQL Reference Manual. skip_name_resolve OFF sort_buffer_size 262144 sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ... User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. ALTER EVENT myevent ON ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. If the redo log files occupy less space than the specified value, dirty pages are flushed from the buffer pool to ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you monitor locking service locks acquired or waited for by examining the Performance Schema metadata_locks table. MySQL distributions ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-overview.html
When data is stored by the NDB storage engine, the tables (and table data) are stored in the data nodes. Such tables are directly accessible from all other MySQL servers (SQL nodes) in the cluster. NDB Cluster is a technology that enables ...
https://dev.mysql.com/doc/refman/9.7/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication.
https://dev.mysql.com/doc/refman/9.7/en/show-plugins.html
For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...