MySQL Benchmark on FreeBSD and Ubuntu

Question

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?

score 1 · Answer 1 · edited Apr 13 '17 at 12:42

1

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

edited Apr 13 '17 at 12:42

Community

1

answered Apr 05 '13 at 07:04

Cristian Porta

1,012
1
7
21

score 0 · Accepted Answer · answered Dec 04 '12 at 19:04

0

Used mysqlslap to run a number of different test cases.

answered Dec 04 '12 at 19:04

xylar

195
1
3
8

MySQL Benchmark on FreeBSD and Ubuntu

2 Answers2