Search Results
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. DROP FUNCTION [IF EXISTS] function_name This statement drops the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-elements.html
Stored procedures perform tasks such as registering firewall profiles, establishing their operational mode, and managing transfer of firewall data between the cache and persistent storage. MySQL Enterprise Firewall is based on a plugin library that ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be stored in the InnoDB transactional storage engine (for details of why, see Section 20.3.1, “Group Replication Requirements”).
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
User credentials set using CHANGE REPLICATION SOURCE TO are stored in plain text in the replication metadata repositories on the server, but user credentials specified on START GROUP_REPLICATION are saved in memory only, and are removed by a STOP ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
Choosing between an in-place or logical upgrade depends on the amount of data stored in the group. Group Replication includes compatibility policies that enable you to safely combine members running different versions of MySQL in the same group ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release.
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Note InnoDB does not support databases that are restored using third-party backup tools. Use the following ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Modifying the configuration after InnoDB is initialized may involve non-trivial procedures. Global Temporary Tablespace Configuration The global temporary tablespace stores rollback segments for changes made to user-created temporary tables. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. The percentage of recently used pages that is ...