PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Enabling innodb_buffer_pool_dump_now triggers the recording action but does not alter the variable setting, which always remains OFF or 0. To view buffer pool dump status after triggering a dump, query the Innodb_buffer_pool_dump_status variable.
https://dev.mysql.com/doc/refman/8.0/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. Triggers and events have no SQL SECURITY characteristic and ...The privileges applicable to execution of a stored object are controlled by its DEFINER attribute and SQL SECURITY ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” functions. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
You must have this privilege for a table to create, drop, execute, or display triggers for that table. When a trigger is activated (by a user who has privileges to execute INSERT, UPDATE, or DELETE statements for the table associated with the ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
To create or drop a trigger, you must have the TRIGGER privilege for the table, not the trigger. The permissible priv_type values at the table level are ALTER, CREATE VIEW, CREATE, DELETE, DROP, GRANT OPTION, INDEX, INSERT, REFERENCES, SELECT, SHOW ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of time. While this is essentially correct, we prefer to use the term events to avoid confusion with ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Triggers and events have no option to define the SQL SECURITY characteristic, so for these objects, CURRENT_USER() returns the account for the user who defined the object. Within the body of a stored routine (procedure or function) or a trigger, the ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Beginning with MySQL 8.0.29, the following statements support an IF NOT EXISTS option: CREATE FUNCTION CREATE PROCEDURE CREATE TRIGGER For CREATE FUNCTION when creating a stored function and CREATE PROCEDURE, this option prevents an error from ...