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
Displaying 81 to 88
of 88 total results
- « Previous
- 7
- 8
- 9
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found. --correct-checksum Command-Line Format --correct-checksum ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
When encountering index tree corruption, InnoDB writes a corruption flag to the redo log, which makes the corruption flag crash-safe. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
R-tree pages, which are used for spatial indexes, are not compressed. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
If you require a custom binary, see Section 2.8.5, “Installing MySQL Using a Development Source Tree”. This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
PAGE_NO is the root page number of the index B-tree, and SPACE is the ID of the tablespace where the index resides. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
All InnoDB data and indexes are stored in B-trees, and their fill factor may vary from 50% to 100%. Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
Similarly, deletes and updates may affect secondary index pages that are not adjacently located in an index tree. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
If you are using this option to repair tables, it tries to repair only the index tree. The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other ...