PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-howto.html
Binary logs containing transactions without GTIDs cannot be used on servers where GTIDs are enabled, so backups taken before this point cannot be used with your new configuration. If you use binary logs for anything other than replication, for ...
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
To enable it, specify a value greater than 0; this value also becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test ... When ...
https://dev.mysql.com/doc/refman/9.7/en/source-configuration-options.html
(The default value is 0, which disables Debug Sync.) N becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test Synchronization.
https://dev.mysql.com/doc/refman/9.7/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 single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.
https://dev.mysql.com/doc/refman/9.7/en/alter-table.html
The exception referred to earlier is that ALTER TABLE blocks reads (not just writes) at the point where it is ready to clear outdated table structures from the table and table definition caches. ALTER TABLE tbl_name [alter_option [, alter_option] ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
For pruning based on rotated log file age, the pruning point is the current time minus the value of audit_log.prune_seconds. The audit log component uses file name timestamps to determine which files contain only events older than the pruning point, ... This section describes how to configure audit logging characteristics, such as the file to which the audit log component writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/9.7/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode.html
BMP characters have these characteristics: Their code point values are between 0 and 65535 (or U+0000 and U+FFFF). Supplementary characters lie outside the BMP: Their code point values are between U+10000 and U+10FFFF). The Unicode Standard ...
https://dev.mysql.com/doc/refman/9.7/en/choosing-types.html
For high precision, you can always convert to a fixed-point type stored in a BIGINT. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
If the typed array column is set to NULL, the storage engine stores a single record containing NULL that points to the data record. (USING BTREE is supported as usual.) Spatial Indexes The MyISAM, InnoDB, NDB, and ARCHIVE storage engines support ...