PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Be aware that a remote cloning operation removes user-created tablespaces and data from the joining member before transferring the data from the donor. Cloning is therefore not suitable for groups where members run different minor MySQL Server ...If ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
Table 14.26 GTID Functions Name Description Deprecated GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. The functions described in this section are used with GTID-based replication. It is important to keep in mind ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
For other ways to reduce or tune I/O for table operations, see Section 10.5.8, “Optimizing InnoDB Disk I/O”. Increase the setting when processing large numbers of updates intended only for statistical analysis, where losing the last N updates in ... Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-migrate-keyring.html
To create or modify a login path file, use the mysql_config_editor utility. The --ssl-fips-mode option differs from other --ssl-xxx options in that it is not used to establish encrypted connections, but rather to affect which cryptographic ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
If you use mysqlbinlog --raw to back up the files, the --result-file option produces output file names as shown in the following table. Use mysqlbinlog to make a continuous backup of the binary log: mysqlbinlog --read-from-remote-server ... By ...
https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html
The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index entries act like pointers to the table rows, allowing the query to quickly determine which rows ...Indexes also add to the cost of inserts, updates, and deletes because each index must be ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. It is also possible to create normal indexes on spatial columns. Other storage engines support non-SPATIAL indexes, as ...The ...