MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 161 to 170 of 171 total results

https://dev.mysql.com/doc/refman/8.0/en/show-grants.html

SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...

15.6.7.5 SIGNAL Statement

https://dev.mysql.com/doc/refman/8.0/en/signal.html

SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...

15.6 Compound Statement Syntax

https://dev.mysql.com/doc/refman/8.0/en/sql-compound-statements.html

END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...

10.10.3 Caching of Prepared Statements and Stored Programs

https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html

(The sum of the number of prepared statements across all sessions.) Stored programs (stored procedures and functions, triggers, and events). For certain statements that a client might execute multiple times during a session, the server converts the ...

30.4.4.18 The ps_setup_show_enabled() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled.html

Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...

30.4.3.26 The schema_object_overview View

https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html

object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, PROCEDURE, TRIGGER, VIEW. This view summarizes the types of objects within each schema. Note For MySQL instances with a large number of objects, this view might take a ...

30.4 sys Schema Object Reference

https://dev.mysql.com/doc/refman/8.0/en/sys-schema-reference.html

The sys schema includes tables and triggers, views, and stored procedures and functions.

10.15.4 Tuning Trace Purging

https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html

Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

During this process, the server upgrades metadata for all database objects, including databases, tablespaces, system and user tables, views, and stored programs (stored procedures and functions, triggers, and Event Scheduler events). This section ...

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

This includes replication of CREATE statements for stored programs (stored procedures and functions, triggers, and events) that are executed while the current sql_mode value includes any of the removed modes. Before upgrading to MySQL 8.0, review ...

Displaying 161 to 170 of 171 total results