Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Where can I find the documentation for MySQL 8.4 triggers? A.5.2. Is there a way to view all triggers in a given database? A.5.7. Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. COMPRESS_OPS The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release. As such, the implementation of SHOW PROCESSLIST which uses this table is also deprecated. It is recommended to use the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product. component_keyring_oci is part of the component infrastructure that communicates with Oracle Cloud Infrastructure Vault for ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients.
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...