search

koct9i / ioping

simple disk I/0 latency measuring tool
GNU General Public License v3.0
947 stars 76 forks source link

Added basic SQLite support for statistics output. #45

Open vhasi opened 4 years ago

vhasi commented 4 years ago

While working for a client with a flaky storage system we needed to store ioping statistics in a database for easy graph generation, so I added some basic SQLite3 support. My mileage with C is limited so it's not pretty, but it worked well enough for us.

koct9i commented 4 years ago

That's neat but very ad hoc solution.

For plotting graph in offline present raw or json formats are just fine. Also it's easy to turn them into SQL or something by couple lines of awk or jq.

For online monitoring it's better to stream numbers via network right away. But industry is very fragmented in this part. I don't see any really common format and protocol.

vhasi commented 4 years ago

It's definitely ad hoc since it's simply meant to solve a specific issue for us, but I wanted to send it back upstream in case anyone else could have a use for it, or at least be inspired by it to make something more useful.

The patched-in SQLite support was the easiest solution I could come up with that fit our specific situation, and after verifying that it actually did solve our problem I wanted to share it since you have been kind enough to share the original tool.

There's no hard feelings on my end if you have no use for it.