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/firewall-reference.html
MySQL Enterprise Firewall Stored Procedures MySQL Enterprise Firewall stored procedures perform tasks such as registering profiles with the firewall, establishing their operational mode, and managing transfer of firewall data between the cache and ...These procedures invoke administrative functions that provide an API for lower-level ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. Variable-length columns are an exception to the rule that column values are stored in B-tree index ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). CREATE ROUTINE Enables use of statements that create stored routines (stored procedures and functions). EXECUTE Enables use of statements ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
The statement executes a stored procedure that sets the new limit. This is also true for any statement inside a stored procedure; the statement is prepared once, when the stored procedure is first executed. A user variable referenced by a statement ...MySQL now incorporates a transactional data dictionary that stores information about database ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored ...DATA_TYPE If the routine is a stored function, the return value data ...The ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
The stored program definition cache partition exists in parallel with the stored procedure and stored function caches that are configured using the stored_program_cache option. The stored_program_cache option sets a soft upper limit for the number ... The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
If the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled, you can store 0 in AUTO_INCREMENT columns as 0 without generating a new sequence value. STORAGE For NDB tables, it is possible to specify whether the column is stored on disk or in memory by using a ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
As of MySQL 8.0.22, CREATE USER fails with an error if any account to be created is named as the DEFINER attribute for any stored object. (That is, the statement fails if creating an account would cause the account to adopt a currently orphaned ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Different storage engines represent data types and store raw data differently. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. DATETIME is packed more efficiently, requiring 5 rather ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
It does not apply to stored procedures and functions, or events. It does not affect statements that apply only to other database objects, such as stored routines. To filter statements operating on stored routines, use one or more of the ... This ...