1. 30 Nov, 2021 5 commits
    • Julien Muchembled's avatar
      mariadb: build RocksDB without fallocate · dc16dc04
      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
      dc16dc04
    • Julien Muchembled's avatar
    • Julien Muchembled's avatar
      version up: MariaDB 10.3.32/10.4.22 · 3a8f0ca7
      Julien Muchembled authored
      3a8f0ca7
    • Julien Muchembled's avatar
      mariadb: small cleanup · 404e82c3
      Julien Muchembled authored
      404e82c3
    • Łukasz Nowak's avatar
      65c3c69e
  2. 29 Nov, 2021 1 commit
  3. 26 Nov, 2021 2 commits
  4. 25 Nov, 2021 2 commits
  5. 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
  6. 23 Nov, 2021 4 commits
  7. 22 Nov, 2021 24 commits