Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Each result set returned from the procedure should be used for a complete graph. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ... Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description ...
https://dev.mysql.com/doc/internals/en/required-server-code-patches.html
Currently procedures can only be compiled into the server staticly. There is no dynamic procedure for loading them dynamicly yet like we have for UDFs and plugins. The build system is not too clever about creating these symlinks for files added ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
(Optional) Remove sp_migrate_firewall_user_to_group(): DROP PROCEDURE IF EXISTS mysql.sp_migrate_firewall_user_to_group; If you installed MySQL Enterprise Firewall in a custom schema, make the appropriate substitution for your system. Grant the ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
These terms are commonly used in information about MySQL Enterprise Monitor. A access control MySQL Enterprise Monitor Access Control enables you to manage asset visibility, application administration, data access, roles, and users. advisor ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
CREATE, INSERT, DROP, and UPDATE on the tables mysql.backup_progress and mysql.backup_history, and also SELECT and ALTER on mysql.backup_history. DROP for dropping tables if the restore fails for some reasons. For creating tape backups using the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
This procedure applies whether you are using ndbd or ndbmtd binaries for the data node processes. In the event that you have API nodes using dynamically allocated node IDs and these IDs match node IDs that you want to use for new data nodes, it is ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-reload-saved.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables.
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
When the procedure returns, the variable has one of the following values to indicate whether the table exists: '': The table name does not exist as a base table, TEMPORARY table, or view. Tests whether a given table exists as a regular table, a ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. Stored routines: ...