I'm really impressed by the performance monitoring features FathomDB offers, especially the ability to sort the most processor and disk intensive queries over the last couple minutes/hours.
I've done a little bit of googling and there seem to be a couple of open source MySQL performance monitoring tools that offer the same kind of features (Nagios, Cacti), but this is something I have very little experience in. Any DBAs care to comment on how they monitor their DBs?
I've done a little bit of googling and there seem to be a couple of open source MySQL performance monitoring tools that offer the same kind of features (Nagios, Cacti), but this is something I have very little experience in. Any DBAs care to comment on how they monitor their DBs?