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/audit-log-file-formats.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ...Database options are stored in the data dictionary and can be examined by checking the Information Schema SCHEMATA ...
https://dev.mysql.com/doc/refman/8.0/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
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] ...