PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids.html
A general procedure for setting up and starting GTID-based replication (see Section 19.1.3.4, “Setting Up Replication Using GTIDs”). Stored functions that you can use to work with GTIDs (see Section 19.1.3.8, “Stored Function Examples to ...