MariaDB Performance Tuning¶

SeaTable's default MariaDB configuration works well for small installations. For larger deployments or when you notice slow database queries, tuning MariaDB can significantly improve performance.

Key settings¶

The most impactful setting is innodb_buffer_pool_size — the memory area where InnoDB caches table data and indexes. As a rule of thumb, set it to 50–70% of your server's available RAM after accounting for SeaTable and other services.

Apply custom settings¶

1. Create a configuration file¶

Create /opt/seatable-compose/99-mariadb-custom.cnf with your tuned values. Adjust innodb_buffer_pool_size to match your server's RAM:

[mariadb]
innodb_buffer_pool_size = 2G
innodb_log_file_size    = 256M
max_connections         = 200

2. Mount the configuration file¶

Create a custom-mariadb.yml in /opt/seatable-compose/:

---
services:
  mariadb:
    volumes:
      - "./99-mariadb-custom.cnf:/etc/mysql/conf.d/99-mariadb-custom.cnf"

Add custom-mariadb.yml to the COMPOSE_FILE variable in your .env file.

3. Restart MariaDB¶

cd /opt/seatable-compose
docker compose up -d mariadb

4. Verify the settings¶

Confirm that your settings were applied:

docker exec -it mariadb mariadb -uroot -p${MARIADB_PASSWORD} -e "SHOW VARIABLES LIKE 'innodb_buffer_pool_size';"

Sizing examples¶