对2013年200天的数据分析:
去数据平稳的六月份的20-25号数据分析:可以看到数据成周期变化,
mysql提取数据保存:
select
lac,cellci,servicename,sum(spd_avg_bytes),s_year,s_month,s_day
from
lv_ipsession_all
where
s_year = 2013 and s_month=6 and s_day between 20 and 25 andservicename='QQ' group by
lac,s_day
order by
lac, s_day
into outfile '/tmp/QQlac20130620_25.csv'character set utf8 fields terminated by ',' lines terminated by '\n';