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/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. A new row event is created for a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
In NDB 8.0, the maximum permitted size of any one row is 30000 bytes (increased from 14000 bytes in previous releases). In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that ...
https://dev.mysql.com/doc/refman/8.0/en/replica-sql-thread-states.html
Monitoring tools that work with these instrumentation names might be impacted. This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. Making temporary file (append) before ... The ...
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 ...