Brown University Benchmark

MgBench is a new analytical benchmark for machine-generated log data, Andrew Crotty.

Download the data:

Unpack the data:

Create the database and tables:

Insert data:

Run benchmark queries:

Query 3.5 below uses a UNION. Set the mode for combining SELECT query results. The setting is only used when shared with UNION without explicitly specifying the UNION ALL or UNION DISTINCT.

The data is also available for interactive queries in the Playground, example.