Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
This table can be queried to obtain information about scheduled events which have been defined on the server. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When ...
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ANSI SQL 2003 specification for stored procedures? A.4.5. Is there a way to view all stored procedures and stored functions in a given ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Where can I find the documentation for MySQL 8.4 triggers? A.5.2. Is there a way to view all triggers in a given database? A.5.7. Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-member-stats.html
The information is shared between all the server instances that are members of the replication group, so information on all the group members can be queried from any member. Each member in a replication group certifies and applies transactions ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
The WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE column of the Performance Schema table replication_group_communication_information shows whether the group supports the use of a single leader, even if group_replication_paxos_single_leader is currently set ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Section 11.2.1, “Identifier Length Limits”, indicates ...
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
NUMBER_READ_AHEAD_EVICTED The number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries. The INNODB_BUFFER_POOL_STATS table provides much of the same ...