Improve report query time about anemometer

[gtowey]

Note that this will require instructions on how to upgrade for existing users, because it requires a change in table schema, and a change in arguments to pt-query-digest. Roughly those steps are:

1. change pt-query-digest --filter argument

pt-query-digest  \
--filter=' $event->{Bytes} = length($event->{arg}) and $event->{hostname}="app-db2003.sv2.box.net:3306" and $event->{Ts_date}=parse_timestamp(substr($event->{ts},0,6)." 00:00:00") and $event->{Ts_hour}=parse_timestamp(substr($event->{ts},0,9).":00:00") and $event->{Ts_minute}=parse_timestamp(substr($event->{ts},0,12).":00")'

1. change schema

ALTER TABLE global_query_review_history 
 ADD ts_date_min date, add ts_date_max date, 
 ADD ts_hour_min datetime,
 ADD ts_hour_max datetime,
 ADD ts_minute_min datetime,
 ADD ts_minute_max datetime,
 DROP key checksum,
 ADD key `history` (checksum, ts_date_min),
 ADD key `graph_query` (checksum,ts_minute_min),
 ADD key (ts_minute_min);

1. backfill data

UPDATE global_query_review_history_index SET
 ts_date_min=DATE(ts_min), ts_date_max=DATE(ts_max), 
 ts_hour_min=FROM_UNIXTIME(TRUNCATE(UNIX_TIMESTAMP(ts_min)/3600,0)*3600),
 ts_hour_max = FROM_UNIXTIME( TRUNCATE(UNIX_TIMESTAMP(ts_max) / 3600,0)*3600),
 ts_minute_min=FROM_UNIXTIME( TRUNCATE(UNIX_TIMESTAMP(ts_min) / 60,0)*60),
 ts_minute_max=FROM_UNIXTIME( TRUNCATE(UNIX_TIMESTAMP(ts_max) /60,0)*60);

[ankitthakwani]

The bacfill data UPDATE SQL refers to table global_query_review_history_index, but only 2 tables exist in the DB

global_query_review
global_query_review_history

Please let me know if I am interpreting something incorrectly.