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/connection-compression-control.html
Because enabling compression decreases performance, its benefits occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. Configuration ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
For large tables, this is much faster than simply using mysqldump. In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to ...
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 ...