PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
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/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
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 ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html
An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods supported by SqlResult are listed here: close(): Closes the result set. fetchAll(): Retrieves a list of all ...
https://dev.mysql.com/doc/refman/9.7/en/stop-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while ...
https://dev.mysql.com/doc/refman/9.7/en/stop-replica.html
] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. STOP REPLICA requires the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER privilege). Recommended best practice is to execute STOP ...
https://dev.mysql.com/doc/refman/9.7/en/structured-system-variables.html
A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely related. There might be several instances of a given type of structured ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.22, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/9.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...