2

I'm investigating some performance issue and I need a tool that can mock the same I/O behavior that a typical RDBMS is usually creating. I don't want to install a full blown RDBMS and mess around with configuration just in order to test this issue.

Is there any tool designaed for this specific need ?

3
  • you can use oracle orion, but i think you need a database installed
    – c4f4t0r
    Dec 23, 2013 at 19:14
  • 1
    Completely irrelevant to your question, sqlio for Windows does this. The Answer below handles Linux nicely.
    – Chris S
    Dec 24, 2013 at 14:38
  • Can't see how this question is seeking product,service or material recoomendation. It's seeking for a method to simulate a situation.
    – ApriOri
    Dec 31, 2013 at 12:05

2 Answers 2

2

Assuming you know your database block size, number of threads, and percentage of read vs write, iozone can be used to craft IO workloads which might mimic production.

Filebench ships with a large number of "personalities" which can mimic an application workload, including a database application, and even has its own markup language to enable you to write your own workload personality.

0

There's also the blktrace (btrecord) approach on Linux. You can capture real I/O activity and replay (btreplay) onto the same device or different device. The fio tool also supports this.

Not the answer you're looking for? Browse other questions tagged .