Log for 電訊台

curl -s "http://pgl.yoyo.org/adservers/serverlist.php?hostformat=nohtml&showintro=0&mimetype=plaintext" \
| sed 's;^\(.*\)$;address=/\1/0.0.0.0;' >> $FILE

address=/2mdn.net/0.0.0.0
address=/360yield.com/0.0.0.0
address=/adgrx.com/0.0.0.0
address=/adnxs.com/0.0.0.0
address=/ads.yahoo.com/0.0.0.0
address=/adsrvr.com/0.0.0.0
address=/adsymptotic.com/0.0.0.0
address=/advertising.com/0.0.0.0
address=/adzerk.net/0.0.0.0
address=/afy11.com/0.0.0.0
address=/amazon-adsystem.com/0.0.0.0
address=/analytics.twitter.com/0.0.0.0
address=/atdmt.com/0.0.0.0
address=/bkrtx.com/0.0.0.0
address=/bluekai.com/0.0.0.0
address=/casalemedia.com/0.0.0.0
address=/chango.com/0.0.0.0
address=/chartbeat.com/0.0.0.0
address=/chartbeat.net/0.0.0.0
address=/connexity.net/0.0.0.0
address=/criteo.com/0.0.0.0
address=/crm4d.com/0.0.0.0
address=/datvantage.com/0.0.0.0
address=/doubleclick.net/0.0.0.0
address=/doubleverify.com/0.0.0.0
address=/easydmp.net/0.0.0.0
address=/eqads.com/0.0.0.0
address=/eyereturn.com/0.0.0.0
address=/google-analytics.com/0.0.0.0
address=/googleadservices.com/0.0.0.0
address=/googlesyndication.com/0.0.0.0
address=/googletagmanager.com/0.0.0.0
address=/googletagservices.com/0.0.0.0
address=/hs-analytics/0.0.0.0
address=/imrworldwide.com/0.0.0.0
address=/indexww.com/0.0.0.0
address=/inspectlet.com/0.0.0.0
address=/kinja-static.com/0.0.0.0
address=/krxd.com/0.0.0.0
address=/krxd.net/0.0.0.0
address=/kxcdn.com/0.0.0.0
address=/liverail.com/0.0.0.0
address=/lkqd.com/0.0.0.0
address=/marketo.com/0.0.0.0
address=/mathtag.com/0.0.0.0
address=/mktoresp.com/0.0.0.0
address=/mythings.com/0.0.0.0
address=/openx.net/0.0.0.0
address=/optimizely.com/0.0.0.0
address=/outbrain.com/0.0.0.0
address=/parsely.com/0.0.0.0
address=/perfectmarket.com/0.0.0.0
address=/pubmatic.com/0.0.0.0
address=/quantserve.com/0.0.0.0
address=/rfihub.com/0.0.0.0
address=/scorecardresearch.com/0.0.0.0
address=/sharethis.com/0.0.0.0
address=/simplereach.com/0.0.0.0
address=/simpli.fi/0.0.0.0
address=/sitescout.com/0.0.0.0
address=/skimresources.com/0.0.0.0
address=/smartadserver.com/0.0.0.0
address=/solution.weborama.fr/0.0.0.0
address=/sumome.com/0.0.0.0
address=/taboola.com/0.0.0.0
address=/turn.com/0.0.0.0

drop table if exists value;
create table value (
  id int primary key auto_increment,
  val int not null,
  index (val)
);

-- insert 10,192,056 rows 
-- no index (42sec)
-- with index (53sec)
insert into value(val) values (1),(2),(3),(4),(5),(6),(7);
insert into value(val) select (2*b.val + a.val) mod 3 as val from value as a, value b;
insert into value(val) select (2*b.val + a.val) mod 3 as val from value as a, value b;
insert into value(val) select (2*b.val + a.val) mod 3 as val from value as a, value b;

-- first time slow, second time faster
select count(1) from value;
select count(1) from value;

-- first time slow, second time faster
select val, count(1) from value group by val;
select val, count(1) from value group by val;

-- slow after insertion or deletion
insert into value(val) values (-1);
select count(1) from value;
delete from value where valu = -1;
select count(1) from value;

-- or first time after update 1 row
update value set val = (val+1) mod 3 where id = 100;
select val, count(1) from value group by val;
select count(1) from value;