Search Results
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views.html
The discussion in the next few sections describes the syntax for creating, altering, and dropping JSON duality views, shows some examples of how to use them, and provides information about obtaining related metadata. Also known as JSON relational ...
https://dev.mysql.com/doc/refman/9.7/en/key-space.html
In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
Note component_keyring_kmip is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) Keyring component is intended to replace the keyring_okv Keyring plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/en/known-issues.html
Creation of a table of type MERGE does not check whether the underlying tables are compatible types. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging ...
https://dev.mysql.com/doc/refman/9.7/en/loop.html
Example: CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END; . [begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a ...
https://dev.mysql.com/doc/refman/9.7/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-optimization-tips.html
If possible, classify reports as “live” or as “statistical”, where data needed for statistical reports is created only from summary tables that are generated periodically from the live data. This section lists a number of miscellaneous tips ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-memory.html
Memory is not allocated until the component is activated by creating or executing a stored program that uses JavaScript. Memory allocation and usage information for the MLE component can be obtained by checking the values of the mle_heap_status and ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/9.7/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored ...