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/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. Rebuilding InnoDB Full-Text ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
The ability to restore the buffer pool at startup shortens the warmup period by reloading disk pages that were in the buffer pool before the restart rather than waiting for DML operations to access corresponding rows. Also, I/O requests can be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
Executing the entire transaction history can be time-consuming when the source server has processed a large number of transactions previously, and this can represent a major bottleneck when setting up a new replica. However, it may not always be ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names ... Some options are “boolean” and control behavior that can be turned on or ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8mb4 character set (where each character uses 4 bytes). Storing the string also results in ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
The following general considerations apply when choosing key lengths and encryption algorithms: The strength of encryption for private and public keys increases with the key size, but the time for key generation increases as well. For encrypting ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
However, the trade-off is that the time required to failover is then proportional to the size of the backlog, which on a correctly configured group should be small . In terms of distributed consistency guarantees, either in normal or failure repair ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
Waiting for the slave SQL thread to free enough relay log space From MySQL 8.0.26: Waiting for the replica SQL thread to free enough relay log space You are using a nonzero relay_log_space_limit value, and the relay logs have grown large enough that ...Monitoring tools that work with these instrumentation names might be ... The following list shows the most common states you see in ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
However, if the size of your data set is very large, mysqldump may be impractical. Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
MySQL on Windows Considerations Large Table Support If you need tables with a size larger than 4GB, install MySQL on an NTFS or newer file system. For example: Developer Default: Provides a setup type that includes the selected version of MySQL ...