MySQL Forge

Resources for the MySQL Community

Category: RandomQueryGenerator

RandomQueryGeneratorThird-partyStorageEngines

The RandomQueryGenerator can be run against a third-party storage engine loaded into the MySQL server:

[edit] Run a workload against a dynamically-loaded engine

$ perl runall.pl \
  --basedir=/build/mysql-5.1.30 \
  --mysqld=--plugin-dir=/build/pbxt-1.0.06-beta/src/.libs/ \
  --mysqld=--plugin-load=PBXT=libpbxt.so \
  --engine=PBXT \
  --grammar=conf/example.yy

[edit] Compare the results returned by two storage engines

$ perl runall.pl \
  --basedir=/build/mysql-5.1.30 \
  --mysqld1=--plugin-dir=/build/pbxt-1.0.06-beta/src/.libs/ \
  --mysqld1=--plugin-load=PBXT=libpbxt.so \
  --vardir1=/tmp/vardir1 \
  --vardir2=/tmp/vardir2 \
  --mysqld1=--default-storage-engine=PBXT \
  --mysqld2=--default-storage-engine=Innodb \
  --threads=1 \
  --grammar=conf/example.yy

Pre-packaged tests that you may find useful when testing your storage engine can be found here RandomQueryGeneratorTests