# DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1

DevFeed: [DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1](<https://devfeed.tech/articles/dbtrail-analytical-reports-on-your-mysql-data-without-running-them-on-mysql-part-1-65637.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/dbtrail-analytical-reports-on-your-mysql-data-without-running-them-on-mysql-part-1/>)

Author: Vadim Tkachenko

Published: 2026-10-06T16:28:16Z

Content type: article

Language: en

Sources: [Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [streaming data to S3 with Parquet](<https://devfeed.tech/topics/streaming-data-to-s3-with-parquet.md>)

Tags: [apache](<https://devfeed.tech/tags/apache.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [database](<https://devfeed.tech/tags/database.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>)

## AI overview

The article tests DBTrail, an open-source approach for querying MySQL data with DuckDB while transactional workloads continue. DBTrail copies tables into Parquet files, then follows MySQL's binary log to apply changes. In the reported tests, the initial copy caused a brief latency increase, while subsequent reporting queries ran against DuckDB. The article also reports the test setup and performance measurements.

## Source excerpt

MySQL is very good at serving application workloads, but things get more complicated when somebody decides to run a large report on the same server. A scan can push hot pages out of the buffer pool. A long-running read can hold back purge. A GROUP BY over millions of rows can start writing temporary tables ... Continued The post DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL - Part 1 appeared first on Percona.