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/local-variable-scope.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ... The scope of a local variable is the BEGIN ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
The procedure used to populate the configuration directory with these files depends on the KMIP back end used with keyring_okv, as described elsewhere. Some pertinent information sources: Oracle Key Vault site Oracle Key Vault documentation In ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The value is one of 'EVENT' (Event Scheduler event), 'FUNCTION' (stored function), 'PROCEDURE' (stored procedure), 'TABLE' (base table), or 'TRIGGER' (trigger). The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
ROM sys_config | +-----------------------------------+ Subsequent invocations of format_statement() within the session continue to use the user-defined variable value (32), rather than the value stored in the table (64). diagnostics.include_raw, ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
parameter_type_elements: Information about stored procedure and function parameters, and about return values for stored functions. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the ...The following discussion further subdivides the set of system tables into smaller ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. Stored routines: ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
If a condition occurs for which no handler has been declared, the action taken depends on the condition class: For SQLEXCEPTION conditions, the stored program terminates at the statement that raised the condition, as if there were an EXIT handler.
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
Restoring Orphan File-Per-Table ibd Files This procedure describes how to restore orphan file-per-table .ibd files to another MySQL instance. You might use this procedure if the system tablespace is lost or unrecoverable and you want to restore .ibd ... Information about table definitions is stored in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
From that release, MySQL Server performs the entire MySQL upgrade procedure, disabling binary logging during the upgrade. Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
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 ...