Summer is over... our server is getting bogged down yet
again....
so, trying to see what's happening,
I plotted the number of previews per 5 minutes.
http://aycu17.webshots.com/image/24296/20019693
91083126765_rs.jpg
I'd be curious what kind of numbers other people have.
As of 15:00 our highest number of publishes per 5 minutes
was 106, though it varies throughout the day.
Details
I'm not sure if any changes were made to the job table
in 1.10, but this is what I used for 1.8:
-- note: +2 is for +0200 timezone, change as necessary
bricolage=# o prev-5mins.txt
bricolage=# select extract(year from comp_time) as
year,extract(month from
comp_time) as month,extract(day from comp_time) as
day,extract(hour from comp_time)+2
as hour,5*round(extract(minute from comp_time)/5) as
minute,count(*) from job where
name like 'Preview %' group by year,month,day,hour,minute
order by
year,month,day,hour,minute;
bricolage=# o
# this changes sql output to something for gnuplot
$ perl -ne
' a=/^s*(d)D+(d{1,2})D+(d{1,2})D+(d{1,2})D+
(d{1,2})D+(d+)/;
printf("%4d-%02d-%02d-%02d-%02d %dn",a) if
a;'
prev-5mins.txt > prev-5mins.dat
# this is a gnuplot script
$ cat prev.gp
set title 'Previews per 5 mins'
set xlabel 'Time'
set ylabel 'Previews'
set xdata time
set timefmt '%Y-%m-%d-%H-%M'
set xrange ['2007-08-16-08-00':'2007-08-16-15-00']
set format x '%H:%M'
set tics out
set nolabel
set noarrow
plot 'prev-5mins.dat' using 1:2 axes x1y1 title '' with
lines
# command in gnuplot
gnuplot> load 'prev.gp'
Then I took a screenshot, since I don't like gnuplot's image
outputs.
|
