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/copying-databases.html
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 the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
A full merge of the change buffer can be forced as part of a slow server shutdown using --innodb-fast-shutdown=0. What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-virtualization.html
The usual ones are related to performance, performance degradations, slowness, or unpredictability of disk, I/O, network, and memory. Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Large transactions can also cause the system to slow due to problems with memory allocation. Limit on Group Size Limits on Transaction Size The following known limitations exist for Group Replication. Note that the limitations and issues described ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
Consider increasing the value of group_replication_member_expel_timeout from the default in the following scenarios: The network is slow and the default 5 or 10 seconds before expulsion is not long enough for group members to always exchange at ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
The Group Replication flow control mechanism minimizes the difference between fast and slow members, and so reduces the chances of this happening if it is activated and properly tuned. In single-primary mode ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
Group Replication is an eventual consistency system, meaning that as soon as the incoming traffic slows down or stops, all group members have the same data content. Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined ...