PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A stored routine is either a procedure or a function. A procedure is invoked using a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. It may occur for temporary tables created outside stored functions ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
For example, if parallel transactions affect index creation or an online buffer pool resizing operation, you can configure a transaction delay to reduce resource contention while those operations are running. Otherwise, the thread pool considers the ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE ... This is done to ensure ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Be aware that a remote cloning operation removes user-created tablespaces and data from the joining member before transferring the data from the donor. The default setting for the group_replication_clone_threshold Group Replication system variable ...If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
The value is large because it encodes the column sequence number and ordinal position. CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...