Looks like about 250 servers "missed" the leap second. This query counts how many servers had an offset 100ms around "one second off". It was basically none yesterday, and 253 in the first hour after the leap.
mysql> select date(ts),hour(ts),count(distinct(server_id)) from log_scores where offset > 0.9 and offset < 1.1 and ts > '2012-06-30' and monitor_id is null group by 1,2; +------------+----------+----------------------------+ | date(ts) | hour(ts) | count(distinct(server_id)) | +------------+----------+----------------------------+ | 2012-06-30 | 5 | 1 | | 2012-06-30 | 9 | 2 | | 2012-06-30 | 10 | 2 | | 2012-06-30 | 12 | 1 | | 2012-06-30 | 17 | 1 | | 2012-06-30 | 18 | 1 | | 2012-06-30 | 20 | 1 | | 2012-06-30 | 23 | 1 | | 2012-07-01 | 0 | 253 | +------------+----------+----------------------------+ 9 rows in set (29.26 sec) I'll look again in a few hours to see how it looks. Ask -- http://www.ntppool.org/ | http://askask.com/ _______________________________________________ pool mailing list [email protected] http://lists.ntp.org/listinfo/pool
