PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...More ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
There are exceptions when you cannot switch the replication format at runtime: The replication format cannot be changed from within a stored function or a trigger. Where possible, rows stored in the binary log are grouped into events with a size not ... You can select the binary logging format explicitly by starting the MySQL server with ...