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/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
The time a statement (or stage) takes to execute is in general orders of magnitude larger than the time it takes to execute a single wait. Performance Schema Timer Representation in Events Rows in Performance Schema tables that store current events ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backup tools include the mysqlbackup of MySQL Enterprise Backup for InnoDB or any other tables, or file system-level ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
It is safe to reduce TIME_WAIT greatly on LAN connections because there is little chance of packets arriving at very long delays, as they could through the Internet with its comparatively large distances and latencies. A MySQL client on Unix can ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
Using the clone plugin for provisioning is considerably faster and more efficient than replicating a large number of transactions. In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
Using the clone plugin for provisioning is considerably faster and more efficient than replicating a large number of transactions (see Section 7.6.7.7, “Cloning for Replication”). The clone plugin, introduced in MySQL 8.0.17, permits cloning ...
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 ...