Skip to content
This repository has been archived by the owner on Jun 12, 2020. It is now read-only.

Sqlbench tests

prohaska edited this page Sep 19, 2014 · 2 revisions

Sqlbench tests

The run.sql.bench.bash script runs all of the sql bench tests with TokuDB.

The primary reason for running these tests with TokuDB is to expose TokuDB to a wide range of SQL statements. Historically, running these tests have exposed several bugs in the TokuDB storage engine. Another reason for running these tests with TokuDB is to find performance changes between different versions of TokuDB software. Unfortunately, the database sizes are small compared to the size of memory so these tests measure in memory performance.

The test expects that a mysql build is installed in '/usr/local' and that mysqld is running on unix socket '/tmp/mysql.sock'. The install location and socket name can be overridden by a command line argument. The test runs all of the tests that it finds in the 'sql-bench' directory.

The test results are stored in Tokutek's subversion source control system.

Expected results: all tests pass.

Future work

  • The sql bench test times could be compared with other releases.
Clone this wiki locally