MySQL Benchmark on FreeBSD and Ubuntu I'd like to benchmark two db servers, one is running Ubuntu the other FreeBSD. Unfortunately we are unable to install SysBench on the FreeBSD OS. Could anyone recommend any alternatives? Or should I look into creating some intense queries based on the schema?
In order to compile correctly SysBench 0.5 on a FreeBSD system you have to download the source code from launchpad.net (SysBench v0.5), see bug 1029088

Then, for benchmarking purposes, you can take a look into this post:


Stress test MySQL with queries captured with general log in MySQL


Or you can use the standard oltp test provided by SysBench