Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5095

Document new defaults in 8.0 for MYR and TDB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 8.0.x
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      See PS-4839

      • Changed default value of the rocksdb_default_cf_options to be :
      • block_based_table_factory= { * cache_index_and_filter_blocks=1; * filter_policy=bloomfilter:10:false; * whole_key_filtering=1}

        ;

      • level_compaction_dynamic_level_bytes=true;
      • optimize_filters_for_hits=true;
      • compaction_pri=kMinOverlappingRatio;
      • compression=kLZ4Compression;
      • bottommost_compression=kLZ4Compression;
      • Changed default rocksdb_max_total_wal_size from rocksdb default(0) to be 2G
      • Changed default rocksdb_block_size from rocksdb default(4K) to 16K
      • Changed/enforced existing default of rocksdb_table_cache_numshardbits to
      • current rocksdb default of 6
      • Changed/enforced existing default of rocksdb_max_background_jobs to
      • current rocksdb default of 2
      • Changed default tokudb_enable_partial_eviction to be false.
      • Changed default tokudb_block_size to be 512M.
      • Changed default tokudb_read_block_size to be 16K.
      • Changed default tokudb_row_format to be quicklz.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              borys.belinsky Borys Belinsky (Inactive)
              Reporter:
              george.lorch George Lorch
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours, 17 minutes
                  2h 17m

                    Smart Checklist