Database / BetterDB Interview questions
What is the difference between MONITOR captures and slowlog analytics?
A MONITOR capture session is something you deliberately start and stop: it records real, live traffic on demand, with live tail, filtering, replay, export to JSON or CSV, and cross-referencing against connection history. It's a targeted, full-detail recorder for the window you choose to run it.
Slowlog and COMMANDLOG analytics work the opposite way: they're always-on, continuously persisting whatever the server itself already flags as slow (or, for COMMANDLOG, unusually large), so you can query that history across any time range without having had to be watching live.
The trade-off is scope versus continuity: MONITOR gives you everything, but only for as long as you're capturing; slowlog/COMMANDLOG analytics run forever in the background, but only ever see the narrower subset the server itself decided was worth logging.
More Related questions...