PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Isolate and tune any part of the query, such as a function call, that takes excessive time. Depending on how the query is structured, a function could be called once for every row in the result set, or even once for every row in the table, greatly ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
Version Tokens is based on a plugin library that implements a version_tokens plugin and a set of loadable functions. X Plugin extends MySQL Server to be able to function as a document store. MySQL supports an plugin API that enables creation of ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
C API Session State Tracker Support To enable client applications to extract state-change information from OK packets returned by the server, the MySQL C API provides a pair of functions: mysql_session_track_get_first() fetches the first part of the ...A client can enable these trackers to receive notification of changes to its session ...
https://dev.mysql.com/doc/refman/5.7/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Conversion and caching occurs for these statements: Prepared statements, both those processed at the SQL level (using the PREPARE statement) and those processed using the binary client/server protocol (using the mysql_stmt_prepare() C API function).
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller. It is not permitted to assign the ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-elements.html
A set of loadable functions provides an SQL-level API for manipulating and inspecting the list of server version tokens maintained by the plugin. The SUPER privilege is required to call any of the Version Token functions. Version Tokens is based on ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Input File Character Set The file name must be given as a literal string. If you specify no FIELDS or LINES clause, the defaults are the same as if you had written this: FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY ...