PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/persisted-system-variables.html
Persisting Sensitive System Variables From MySQL 8.0.29, MySQL Server has the capability to securely store persisted system variable values containing sensitive data such as private keys or passwords, and restrict viewing of the values. In the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/server-options.html
Note For MySQL Keyring, this option is used only when the keystore is managed with a keyring plugin. If keystore management uses a keyring component rather than a plugin, specify component loading using a manifest file; see Section 8.4.4.2, ... When ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
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 ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/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 ...