Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
EXCHANGE PARTITION statement must meet the conditions required for them to be stored in the target partition; otherwise, the statement fails. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME, ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Persisting Sensitive System Variables MySQL 8.4 has the capability to store persisted system variable values containing sensitive data such as private keys or passwords securely, and to restrict viewing of the values. In the mysqld-auto.cnf option ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
(There is also a limit on how long the text of DECIMAL literals can be; see Section 14.24.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary format that packs nine decimal digits into 4 bytes. DECIMAL columns do not ... This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range of DECIMAL columns The declaration syntax for a DECIMAL column is ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
Modifications that the current transaction made to rows after the savepoint was set are undone in the rollback, but InnoDB does not release the row locks that were stored in memory after the savepoint. (For a new inserted row, the lock information ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Example: "SCRAM-SHA 1 SCRAM-SHA-256 GSSAPI" Binlog_cache_disk_use The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. Binlog_stmt_cache_disk_use The number of nontransaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
When retrieved, values stored in a SET column are displayed using the lettercase that was used in the column definition. MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. For ... A ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
This is the total number of bytes of data that can be stored in the table, given the data pointer size used. For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. For NDB tables, Data_length ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other spatial data types hold collections of values: MULTIPOINT MULTILINESTRING MULTIPOLYGON ... MySQL has ...