PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-migration.html
This may seem more complicated, but ultimately saves time and trouble. Where can I find information on how to upgrade or downgrade MySQL? A.8.2. How has storage engine (table type) support changed in MySQL 5.7 from previous versions? A.8.1. Where ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
Depending on why the member is lagging behind, other members in the group may have to save more or less replication context to be able to fulfil potential data transfer requests from the slow member. Group Replication ensures that a transaction ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-usage-advice-and-limitations-of-distributed-recovery.html
This minimizes the length of phase 1 and reduces the impact on the donor server, since it has to save and transfer less binary logs. It is based on classic asynchronous replication and as such it may be slow if the server joining the group is not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
Tables stored in individual tablespace data files can save time and improve chances for a successful recovery when data corruption occurs, when backups or binary logs are unavailable, or when the MySQL server instance cannot be restarted. A ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer ...
https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html
As system root, open the file /etc/sysctl.conf in a text editor, and add the line shown here, where P is the number of large pages obtained in the previous step: vm.nr_hugepages=P Using the actual value obtained previously, the additional line ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
After you have copied over the MySQL database files from the previous installation and have successfully started the new server, you should consider removing the old installation files to save disk space. You should keep the following issues and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
This cannot be recovered so you must save this password for the initial login to MySQL. The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. Note Before proceeding with the ...