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 ?

ApriOri
  • 325
  • 1
  • 10
  • you can use oracle orion, but i think you need a database installed – c4f4t0r Dec 23 '13 at 19:14
  • 1
    Completely irrelevant to your question, `sqlio` for Windows does this. The Answer below handles Linux nicely. – Chris S Dec 24 '13 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 '13 at 12:05

2 Answers2

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.

suprjami
  • 3,536
  • 21
  • 29
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.

ewwhite
  • 197,159
  • 92
  • 443
  • 809