With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle.
For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench . I was able to change just the connection string and run tests.
The diff of my two scripts where:
---
> my $user = $opt{u} || "appuser";
> my $pass = $opt{p} || "password";
> my $port = $opt{P} || 3306;
> my $dsn = "DBI:mysql:$db:$host;port=$port";
---
< my $user = $opt{u} || "root";
< my $pass = $opt{p} || "";
< my $port = $opt{P} || 4427;
< my $dsn = "DBI:drizzle:$db:$host;port=$port";
---
It’s too early to tell what improvement Drizzle will make. Just running my first test with single and multi thread tests shows an improvement in all figures in Drizzle via MySQL, however I will need to run this on various different versions of MySQL including the latest 5.0 to confirm.
