Learning and tips from performance assessment of duckdb in mariadb
Why this bog : I thought of sharing what I leanred from recent perforamance/benchmark assessment of duckdb storage engine for mariadb Setup First of all, if you want setup duckdb for mariadb , please refer 2 good blogs: 1.https://mariadb.org/duckdb-storage-engine-for-mariadb-when-the-sea-lion-learns-to-quack/ - In case, you want to build from source and install. Note : In case you find issue related to libcrypt you can try this: sed -i 's/libxcrypt-dev/libcrypt-dev/g' /test-data/clones/mdb-server/storage/duckdb/duckdb/build.sh (modify path as per you cloned path) USER="mysql" GROUP="mysql" DEFAULT_MDB_DATADIR=/var/lib/mysql/ INSTALL_PREFIX=/usr sudo chown "$USER:$GROUP" /run/mysqld sudo "$INSTALL_PREFIX/bin/mariadbd-safe" --datadir="$DEFAULT_MDB_DATADIR" & ( above , in case you want to shutdown and start mariadb again) 2. https://mariadb.org/mariadb-duckdb-a-new-playground-for-a...