PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog ...Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
An important point for both IndexMemory and DataMemory is that the total database size is the sum of all data memory and all index memory for each node group. (NDB 8.0.13) When true, enable partial local checkpoints: This means that each LCP records ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
These InnoDB enhancements were added: The current maximum auto-increment counter value is written to the redo log each time the value changes, and saved to an engine-private system table on each checkpoint. InnoDB also writes in-memory corruption ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
The most typical operations are: Point queries that search for all objects that contain a given point Region queries that search for all objects that overlap a given region MySQL uses R-Trees with quadratic splitting for SPATIAL indexes on spatial ... For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
Approximate-value data types and numeric literals are handled as floating-point numbers. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The DECIMAL data type is a fixed-point ... The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
At this point, the plugin is still writing to the current log file, which has been renamed to audit.log.1. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Do the preceding limitations affect the ability of MySQL to do point-in-time recovery? A.4.28. If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
This function processes geometry collections by computing the centroid point for components of highest dimension in the collection. Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...However, GTIDs only provide a means to realize which transactions the joining member is ...