Hello,

I'm trying to improve a setup w firebirdsql 2.1 / windows by adding some monitoring.
Ideally, I want to use cacti (cacti.net) to graph any numbers like mysql/postgresql [1] but it doesn't seem there is any existing stuff [2].

After looking on the net, I got a few interesting references
* README.monitoring_tables.txt (from package)
* http://blog.upscene.com/thomas/search.php?q=monitoring

From that, using monitoring tables, I have selected the following sql requests as interesting
SQL> SELECT MON$DATABASE_NAME, MON$OLDEST_TRANSACTION, MON$OLDEST_ACTIVE, MON$OLDEST_SNAPSHOT, MON$NEXT_TRANSACTION, MON$SHUTDOWN_MODE, MON$BACKUP_STATE FROM MON$DATABASE WHERE MON$DATABASE_NAME = '/opt/tmp/firebirdsql/employee.fdb';
=> for DB performance
SQL> SELECT MON$STAT_ID, MON$STAT_GROUP, MON$PAGE_READS, MON$PAGE_WRITES, MON$PAGE_FETCHES, MON$PAGE_MARKS FROM MON$IO_STATS;
=> for I/O performance
SQL> SELECT MON$STAT_ID, MON$STAT_GROUP, MON$RECORD_INSERTS, MON$RECORD_UPDATES, MON$RECORD_DELETES, MON$RECORD_BACKOUTS, MON$RECORD_PURGES, MON$RECORD_EXPUNGES FROM MON$RECORD_STATS;
=> SQL operations stats (backouts are rollbacks ?)
SQL> SELECT MON$USER, MON$REMOTE_ADDRESS, MON$REMOTE_PID, MON$TIMESTAMP FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID <> CURRENT_CONNECTION;
=> users connected

2 questions
* other interesting requests ? to prevent or diagnose quickly problems ?
* I'm not sure to understand stat_id/stat_group. is it better to keep separated each one or aggregate all of them in one (graph) ?

Thanks for any input.
Cheers,

Julien

[1] http://forums.cacti.net/viewtopic.php?f=12&t=23300&hilit=monitor+postgresql
[2] just found a nagios check script:
http://exchange.nagios.org/directory/Plugins/Databases/check_firebird-2Epl/details