Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
Applications that require properly formatted data, but not necessarily the original data, can synthesize sample data. Example: An application developer who is testing data validators but has no access to original data may synthesize random data with ... Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
The joining member transfers all the transactions that took place in the group before it joined or while it was away, which are provided by the existing member (called the donor). Next, the joining member applies the transactions that took place in ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The following limitations are generally applicable to online DDL operations on large tables that involve rebuilding the table: There is no mechanism to pause an online DDL operation or to throttle I/O or CPU usage for an online DDL operation. For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
In mixed workloads where most of the activity is OLTP type with periodic batch reporting queries which result in large scans, setting the value of innodb_old_blocks_time during the batch runs can help keep the working set of the normal workload in ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
Oracle also makes available MySQL Cluster Manager, which provides an advanced command-line interface simplifying many complex NDB Cluster management tasks, such restarting an NDB Cluster with a large number of nodes. Regardless of the transporter ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
You should be aware that the methods described previously in this section are not optimized for very large data sets or large transactions. It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in memory. At the TCP level this ...(It is possible to reduce this requirement using Disk Data tables—see Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information about these.) You can obtain information about memory usage by data nodes by viewing the ndbinfo.memoryusage table, or the output of the REPORT MemoryUsage command in the ndb_mgm ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. For example, to retrieve a BLOB might require a large sequential disk read that is better suited to a traditional hard drive than to an SSD device. Do not use this ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
Dropping and re-creating the index is necessary and might take some time if the system has a large number of users and privileges. Check and repair operations can be time-consuming, particularly for large tables. Installing a new version of MySQL ...