RandomQueryGeneratorThird partyStorageEngines

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

=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

=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

Category:RandomQueryGenerator