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/mysql-cluster-privilege-distribution.html
The first step in enabling distributed privileges is to load this script into a MySQL Server that functions as an SQL node (which we refer to after this as the target SQL node or MySQL Server). To verify that the conversion was successful, you can ... NDB Cluster supports distribution of MySQL users and privileges across all SQL nodes in an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
For example, thread/sql/one_connection corresponds to the thread function in the code responsible for handling a user connection, and thread/sql/main stands for the main() function of the server. This is the same value displayed in the ID column of ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/5.7/en/return.html
RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a stored function. There may be more than one if the function has multiple ...This statement is not used in stored procedures, triggers, or ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. The SQL SECURITY Characteristic For stored routines ...The ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Terminology used in this document reflects the stored object hierarchy: Stored routines include stored procedures and functions. This chapter discusses ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
It may occur for temporary tables created outside stored functions and referred to across multiple calling and callee functions. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
There are exceptions when you cannot switch the replication format at runtime: From within a stored function or a trigger. With mixed replication, temporary tables are usually logged; exceptions happen with loadable functions and with the UUID() ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
For stored procedure, stored function, and trigger objects, the relevant sql_mode value is the one in effect when the object was created. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...