MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 671 to 680 of 687 total results

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html

Depending on how many threads are requesting a lock, and the nature of the locks requested, access can be either granted in shared mode, exclusive mode, shared-exclusive mode or not granted at all, waiting for other threads to finish first. The ...

4.2.2.5 Using Options to Set Program Variables

https://dev.mysql.com/doc/refman/5.7/en/program-variables.html

Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 5.1.8, “Using System Variables”. Most of these program variables also ...

13.1.3 ALTER FUNCTION Statement

https://dev.mysql.com/doc/refman/5.7/en/alter-function.html

(That privilege is granted automatically to the function creator.) If binary logging is enabled, the ALTER FUNCTION statement might also require the SUPER privilege, as described in Section 23.7, “Stored Program Binary Logging”. ALTER FUNCTION ...

13.1.6 ALTER PROCEDURE Statement

https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html

By default, that privilege is granted automatically to the procedure creator. ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL ...

4.2.2.1 Using Options on the Command Line

https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html

Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...

13.7.3.1 CREATE FUNCTION Statement for Loadable Functions

https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html

If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This ...

13.1.27 DROP PROCEDURE and DROP FUNCTION Statements

https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html

(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. DROP {PROCEDURE | ...

5.6.1 Installing and Uninstalling Loadable Functions

https://dev.mysql.com/doc/refman/5.7/en/function-loading.html

If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports ...

5.1.11.2 DNS Lookups and the Host Cache

https://dev.mysql.com/doc/refman/5.7/en/host-cache.html

In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and ...

24.4.25 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View

https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html

The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been requested and how many numbers are granted per request. The INNODB_SYS_TABLESTATS table provides a view of low-level status information about ...

Displaying 671 to 680 of 687 total results