For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...
On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...