1. 29 Nov, 2021 5 commits
    • Julien Muchembled's avatar
    • Julien Muchembled's avatar
      mariadb: build RocksDB without fallocate · e6c1bb74
      Julien Muchembled authored
      https://github.com/facebook/rocksdb/commit/7291a3f813e563efbd6870465b1063a115480373
      is not enough.
      
      Anway, given how SST files are written, fallocate
      is unlikely to be useful, even less on SSD.
      
      RocksDB seems to have options to disable at runtime (see env/io_posix.cc)
      but I see nothing for that in MariaDB configuration.
      
      Steps to reproduce:
      
      With a Btrfs partition (no specific mkfs option and for example 2GB size)
      and following MariaDB configuration:
      
        [mysqld]
        datadir = /tmp/datadir
        disable-log-bin
        plugin-load = ha_rocksdb
        rocksdb_default_cf_options = compression=kNoCompression;bottommost_compression=kZSTD
      
      execute the following queries with `mysql -uroot`:
      
      > USE test;
      > CREATE TABLE t(x MEDIUMBLOB) ENGINE=RocksDB;
      > INSERT INTO t VALUES(repeat('.',16777215));
      > INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;
      > INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;
      > INSERT INTO t SELECT x FROM t UNION ALL SELECT x FROM t;
      
      Disk usage can be checked with:
      
      > SHOW ENGINE RocksDB STATUS \G
      
      Level    Files   Size     ...
      ------------------------- ...
        L0      1/0   144.00 MB ...
        L2      1/0   288.00 MB ...
       Sum      2/0   432.00 MB ...
      
      and this can be compacted as follows:
      
      > SET GLOBAL rocksdb_compact_cf='default';
      
      > SHOW ENGINE RocksDB STATUS \G
      
      Level    Files   Size     ...
      ------------------------- ...
        L0      0/0    0.00 KB  ...
        L1      0/0    0.00 KB  ...
        L2      1/0   16.28 KB  ...
       Sum      1/0   16.28 KB  ...
      
      Now using `compsize` (on Debian, it's provided by btrfs-compsize package):
      
      # with -DWITH_FALLOCATE=NO
      
      $ compsize /tmp/datadir/#rocksdb/000029.sst
      Type       Perc     Disk Usage   Uncompressed Referenced
      TOTAL      100%       20K          20K          20K
      none       100%       20K          20K          20K
      
      # without -DWITH_FALLOCATE=NO
      
      $ compsize /tmp/datadir/#rocksdb/000029.sst
      Type       Perc     Disk Usage   Uncompressed Referenced
      TOTAL      100%       35M          35M          20K
      none       100%       35M          35M          20K
      e6c1bb74
    • Julien Muchembled's avatar
    • Julien Muchembled's avatar
      version up: MariaDB 10.3.32/10.4.22 · 4197c38d
      Julien Muchembled authored
      4197c38d
    • Julien Muchembled's avatar
      mariadb: small cleanup · 28e91852
      Julien Muchembled authored
      28e91852
  2. 26 Nov, 2021 2 commits
  3. 25 Nov, 2021 2 commits
  4. 24 Nov, 2021 2 commits
    • Łukasz Nowak's avatar
      caddy-frontend: Implement netloc-list · a9d98dd1
      Łukasz Nowak authored
      JSON schema uses simple string and internal process, and caddy instances are
      not kept simple and are not considered future-proof.
      a9d98dd1
    • Jérome Perrin's avatar
      software/powerdns: declare a minium gcc version · 428e32c2
      Jérome Perrin authored
      This software can use system gcc. On test nodes we observed successful
      builds when system gcc is 8.3.0 and failures with system gcc is 6.3.0:
      
          checking whether g++ supports C++17 features with -std=c++17... no
          checking whether g++ supports C++17 features with +std=c++17... no
          checking whether g++ supports C++17 features with -h std=c++17... no
          checking whether g++ supports C++17 features with -std=c++1z... no
          checking whether g++ supports C++17 features with +std=c++1z... no
          checking whether g++ supports C++17 features with -h std=c++1z... no
          configure: error: *** A compiler with support for C++17 language features is required.
          ...
          While:
            Installing powerdns.
      428e32c2
  5. 23 Nov, 2021 4 commits
  6. 22 Nov, 2021 25 commits