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/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. The following sections provide additional information about SQL syntax for statements related to these objects, ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The following sections describe the syntax for creating and dropping triggers, show some examples of how to use ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
These properties make this compression technique unsuitable for use in an update-intensive database system. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
Because installing and uninstalling the audit_api_message_emit component installs and uninstalls the audit_api_message_emit_udf() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. As of ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
A disadvantage of PERFORMANCE strategy is that it drops events when the buffer is full. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written ...