PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/audit-log-installation.html
To ensure that your tables are up to date for upgrades from earlier versions of MySQL 8.0, perform the MySQL upgrade procedure, making sure to use the option that forces an update (see Chapter 3, Upgrading MySQL). This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
If you follow the RSA configuration procedure given later in this section, it also supports encrypted password exchange using RSA over unencrypted connections. To enable use of an RSA key pair for password exchange during the client connection ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
This helps the MySQL upgrade procedure detect and upgrade tables containing old temporal columns. If avoid_temporal_upgrade is enabled, FOR UPGRADE ignores the old temporal columns present in the table; consequently, the upgrade procedure does not ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
If you store data in other storage engines, adjust your data size estimate accordingly. The procedure for cloning to a named directory is the same procedure described in Cloning Remote Data with one exception: The CLONE INSTANCE statement must ...