PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.3Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. Local variables are treated like stored routine parameters with respect to data type and overflow checking. To provide a default value for a variable, include a ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/8.0/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. Session ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
These tables are set up automatically in all install, upgrade, and build-from-source procedures. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
Prior to MySQL 8.0.19, index key part sort order information is not stored to the .cfg metadata file used during a tablespace import operation. On Windows, InnoDB stores database, tablespace, and table names internally in lowercase. Internals The ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. LOCK TABLES and UNLOCK TABLES cannot be used within stored programs. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
If the ndb_apply_status table does not exist on the replica, ndb_restore re-creates it. This information is captured in an NDB online backup, but (by design) it is not restored by ndb_restore. In some cases, it can be helpful to restore this ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. This section discusses current restrictions and limitations on MySQL partitioning support. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored procedures. The replication tables store errors on a per-thread basis without loss of information. This is similar to the information ...