PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/group-replication-frequently-asked-questions.html
User credentials set using CHANGE REPLICATION SOURCE TO | CHANGE MASTER 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 ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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 ...