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/end-markers-in-json-system-variable.html
When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's key, if it has one, near the closing bracket. Note If end_markers_in_json is ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. Where can I obtain complete documentation for ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-thread-pool.html
The Thread Pool plugin increases server performance by efficiently managing statement execution threads for large numbers of client connections, especially on modern multi-CPU/Core systems. What is the Thread Pool and what problem does it solve? ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-point.html
Point Examples Imagine a large-scale map of the world with many cities. A Point is a geometry that represents a single location in coordinate space. On a city map, a Point object could represent a bus stop.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-member-stats.html
Statistics regarding the certifier and applier procedures are useful to understand how the applier queue is growing, how many conflicts have been found, how many transactions were checked, which transactions are committed everywhere, and so on.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
If there is not a large transaction gap, or if the clone plugin is not installed, Group Replication proceeds directly to state transfer from a donor's binary log. When Group Replication's distributed recovery process is carrying out state transfer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html
Disabling path validation improves startup time on systems with a large number of tablespace files. At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace files. The paths of discovered tablespace files are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-io.html
Making a few large read requests for contiguous data can be more efficient than making several small, spread-out requests. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...