Each line looks like:

Time: 1253902509 Interval: 10 R: 59 dR: 59 W: 17 dW: 17 dR/dW: 3.47 R/W: 3.47

Fields

• Time The timestamp, expressed as a UNIX epoch, of the sample.

• Interval The number of seconds between the previous sample and the current sample.

• R The total number of database reads.

• dR The delta of reads between the previous sample and the current sample.

• W The total number of database writes.

• dW The delta of writes between the previous sample and the current sample.

• dR/dW The ratio of reads to writes, calculated using the current deltas

• R/W The ratio of reads to writes, calculated using the totals

Notes

All fields are TAB separated. The deltas can be disregarded in the first line of output since there are no previous counters to compare to. Two SQL statements count as both read and write statements: INSERT ... SELECT; and REPLACE ... SELECT; so are, thus, counted twice.