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-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
For general tablespaces, keep in mind that dropping a table does not reduce the size of the general tablespace .ibd file, nor does it return disk space to the operating system. Compressed tables can be created in file-per-table tablespaces or in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file. Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-physical-structure.html
If the fill factor of an InnoDB index page drops below the MERGE_THRESHOLD, which is 50% by default if not specified, InnoDB tries to contract the index tree to free the page. With the exception of spatial indexes, InnoDB indexes are B-tree data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
Unlike the system tablespace, file-per-table tablespaces return disk space to the operating system when they are truncated or dropped. The system tablespace is the storage area for the change buffer. It may also contain table and index data if ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place operations. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to ...