Re: [GENERAL] Getting time-dependent load statistics

2009-02-26 Thread Ashish Karalkar
Torsten Bronger wrote: Hallöchen! Yesterday I ported a web app to PG. Every 10 minutes, a cron job scanned the log files of MySQL and generated a plot showing the queries/sec for the last 24h. (Admittedly queries/sec is not the holy grail of DB statistics.) But I still like to have something

Re: [GENERAL] Getting time-dependent load statistics

2009-02-26 Thread Torsten Bronger
Hallöchen! Torsten Bronger writes: > Yesterday I ported a web app to PG. Every 10 minutes, a cron job > scanned the log files of MySQL and generated a plot showing the > queries/sec for the last 24h. (Admittedly queries/sec is not the > holy grail of DB statistics.) > > But I still like to have

Re: [GENERAL] Getting time-dependent load statistics

2009-02-26 Thread Ben Chobot
On Fri, 20 Feb 2009, Torsten Bronger wrote: Hallöchen! Yesterday I ported a web app to PG. Every 10 minutes, a cron job scanned the log files of MySQL and generated a plot showing the queries/sec for the last 24h. (Admittedly queries/sec is not the holy grail of DB statistics.) But I still l

[GENERAL] Getting time-dependent load statistics

2009-02-26 Thread Torsten Bronger
Hallöchen! Yesterday I ported a web app to PG. Every 10 minutes, a cron job scanned the log files of MySQL and generated a plot showing the queries/sec for the last 24h. (Admittedly queries/sec is not the holy grail of DB statistics.) But I still like to have something like this. At the moment

Re: [GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Torsten Bronger
Hallöchen! Torsten Bronger writes: > [...] Currently, I experiment with > > SELECT tup_returned + tup_fetched + tup_inserted + tup_updated + > tup_deleted FROM pg_stat_database WHERE datname='chantal'; Stangely, the statistics coming out of it are extremely high. I just dumped my database with

Re: [GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Torsten Bronger
Hallöchen! Joshua D. Drake writes: > On Fri, 2009-02-20 at 17:11 +0100, Torsten Bronger wrote: > >> Yesterday I ported a web app to PG. Every 10 minutes, a cron job >> scanned the log files of MySQL and generated a plot showing the >> queries/sec for the last 24h. (Admittedly queries/sec is not

Re: [GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Scott Marlowe
On Fri, Feb 20, 2009 at 9:11 AM, Torsten Bronger wrote: > Hallöchen! > > Yesterday I ported a web app to PG. Every 10 minutes, a cron job > scanned the log files of MySQL and generated a plot showing the > queries/sec for the last 24h. (Admittedly queries/sec is not the > holy grail of DB statis

Re: [GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Joshua D. Drake
On Fri, 2009-02-20 at 17:11 +0100, Torsten Bronger wrote: > Hallöchen! > > Yesterday I ported a web app to PG. Every 10 minutes, a cron job > scanned the log files of MySQL and generated a plot showing the > queries/sec for the last 24h. (Admittedly queries/sec is not the > holy grail of DB stat

Re: [GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Bill Moran
In response to Torsten Bronger : > Hallöchen! > > Yesterday I ported a web app to PG. Every 10 minutes, a cron job > scanned the log files of MySQL and generated a plot showing the > queries/sec for the last 24h. (Admittedly queries/sec is not the > holy grail of DB statistics.) > > But I stil

[GENERAL] Getting time-dependent load statistics

2009-02-20 Thread Torsten Bronger
Hallöchen! Yesterday I ported a web app to PG. Every 10 minutes, a cron job scanned the log files of MySQL and generated a plot showing the queries/sec for the last 24h. (Admittedly queries/sec is not the holy grail of DB statistics.) But I still like to have something like this. At the moment