Experimental database performance tools
This repo is to explore database performance tests with DDEV.
Importing large database has sometimes been an area of concern because they can take a long time and it's hard to understand why and what the differences are between DDEV versions and database types.
Areas of exploration:
- Creation and availability of large database dumps
- Scripts to compare import performance across database types and DDEV versions
- Scripts to compare snapshot restore performance
- create-large-db.sh - Allows creating or adding to existing database.
- compare-imports.sh - Minor adjustments allow comparing imports with different DDEV versions, database versions, and import files. It can be run against a variety of docker providers to compare docker provider performance.
These dumps have no confidential data and are entirely generated using publicly available information.
- Drupal CMS 100K node 100k.sql.gz (download with web browser, not curl). Created by
create-large-db.sh - Drupal CMS 1M node 1M.sql.gz
- Drupal CMS MariaDB 10.11 DDEV snapshot (download with web browser)