PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
A new savepoint level is created when a stored function is invoked or a trigger is activated. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored. SAVEPOINT identifier ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Data Masking and De-Identification, implemented as a plugin library containing a plugin and a set of functions. MySQL Enterprise Data Masking and De-Identification functions enable masking existing ...
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 ...