Count of server measurements (about 2.2 per server per hour) and servers that were accurate within ~80ms, except one second ahead of the monitoring server.
Basically it was none until midnight (most hours on the day before are missing) and then 158; going down to 13 now. Two of the RedHat's which are stratum 1 using a CDMA device IIRC. - ask mysql> select date(ts) as day, hour(ts) as hour, count(*) as tests, count(distinct server_id) as servers from log_scores where ts > '2008-12-31' and offset > 0.92 and offset < 1.08 group by date(ts),hour(ts); +------------+------+-------+---------+ | day | hour | tests | servers | +------------+------+-------+---------+ | 2008-12-31 | 6 | 1 | 1 | | 2008-12-31 | 7 | 1 | 1 | | 2008-12-31 | 14 | 1 | 1 | | 2008-12-31 | 15 | 2 | 1 | | 2008-12-31 | 16 | 4 | 2 | | 2008-12-31 | 17 | 2 | 1 | | 2008-12-31 | 18 | 2 | 1 | | 2008-12-31 | 19 | 3 | 1 | | 2008-12-31 | 20 | 1 | 1 | | 2009-01-01 | 0 | 238 | 158 | | 2009-01-01 | 1 | 93 | 53 | | 2009-01-01 | 2 | 69 | 41 | | 2009-01-01 | 3 | 44 | 23 | | 2009-01-01 | 4 | 43 | 20 | | 2009-01-01 | 5 | 41 | 22 | | 2009-01-01 | 6 | 46 | 21 | | 2009-01-01 | 7 | 44 | 21 | | 2009-01-01 | 8 | 43 | 20 | | 2009-01-01 | 9 | 40 | 20 | | 2009-01-01 | 10 | 35 | 18 | | 2009-01-01 | 11 | 32 | 16 | | 2009-01-01 | 12 | 34 | 15 | | 2009-01-01 | 13 | 32 | 14 | | 2009-01-01 | 14 | 28 | 13 | | 2009-01-01 | 15 | 27 | 13 | +------------+------+-------+---------+ 25 rows in set (0.73 sec) -- http://develooper.com/ - http://askask.com/ _______________________________________________ timekeepers mailing list [email protected] https://fortytwo.ch/mailman/cgi-bin/listinfo/timekeepers
