Box Anemometer

Query 17375832608889571510

First Seen: 2012-04-10 14:29:14
Last Seen: 2012-04-10 14:29:14
Fingerprint
create table `global_query_review_history` ( `hostname_max` varchar(?) not ?, `db_max` varchar(?) default ?, `checksum` bigint(?) unsigned not ?, `sample` text not ?, `ts_min` datetime not ? default ?, `ts_max` datetime not ? default ?, `ts_cnt` float default ?, `query_time_sum` float default ?, `query_time_min` float default ?, `query_time_max` float default ?, `query_time_pct_?` float default ?, `query_time_stddev` float default ?, `query_time_median` float default ?, `lock_time_sum` float default ?, `lock_time_min` float default ?, `lock_time_max` float default ?, `lock_time_pct_?` float default ?, `lock_time_stddev` float default ?, `lock_time_median` float default ?, `rows_sent_sum` float default ?, `rows_sent_min` float default ?, `rows_sent_max` float default ?, `rows_sent_pct_?` float default ?, `rows_sent_stddev` float default ?, `rows_sent_median` float default ?, `rows_examined_sum` float default ?, `rows_examined_min` float default ?, `rows_examined_max` float default ?, `rows_examined_pct_?` float default ?, `rows_examined_stddev` float default ?, `rows_examined_median` float default ?, `rows_affected_sum` float default ?, `rows_affected_min` float default ?, `rows_affected_max` float default ?, `rows_affected_pct_?` float default ?, `rows_affected_stddev` float default ?, `rows_affected_median` float default ?, `rows_read_sum` float default ?, `rows_read_min` float default ?, `rows_read_max` float default ?, `rows_read_pct_?` float default ?, `rows_read_stddev` float default ?, `rows_read_median` float default ?, `merge_passes_sum` float default ?, `merge_passes_min` float default ?, `merge_passes_max` float default ?, `merge_passes_pct_?` float default ?, `merge_passes_stddev` float default ?, `merge_passes_median` float default ?, `innodb_io_r_ops_min` float default ?, `innodb_io_r_ops_max` float default ?, `innodb_io_r_ops_pct_?` float default ?, `innodb_io_r_bytes_pct_?` float default ?, `innodb_io_r_bytes_stddev` float default ?, `innodb_io_r_bytes_median` float default ?, `innodb_io_r_wait_min` float default ?, `innodb_io_r_wait_max` float default ?, `innodb_io_r_wait_pct_?` float default ?, `innodb_io_r_ops_stddev` float default ?, `innodb_io_r_ops_median` float default ?, `innodb_io_r_bytes_min` float default ?, `innodb_io_r_bytes_max` float default ?, `innodb_io_r_wait_stddev` float default ?, `innodb_io_r_wait_median` float default ?, `innodb_rec_lock_wait_min` float default ?, `innodb_rec_lock_wait_max` float default ?, `innodb_rec_lock_wait_pct_?` float default ?, `innodb_rec_lock_wait_stddev` float default ?, `innodb_rec_lock_wait_median` float default ?, `innodb_queue_wait_min` float default ?, `innodb_queue_wait_max` float default ?, `innodb_queue_wait_pct_?` float default ?, `innodb_queue_wait_stddev` float default ?, `innodb_queue_wait_median` float default ?, `innodb_pages_distinct_min` float default ?, `innodb_pages_distinct_max` float default ?, `innodb_pages_distinct_pct_?` float default ?, `innodb_pages_distinct_stddev` float default ?, `innodb_pages_distinct_median` float default ?, `qc_hit_cnt` float default ?, `qc_hit_sum` float default ?, `full_scan_cnt` float default ?, `full_scan_sum` float default ?, `full_join_cnt` float default ?, `full_join_sum` float default ?, `tmp_table_cnt` float default ?, `tmp_table_sum` float default ?, `disk_tmp_table_cnt` float default ?, `disk_tmp_table_sum` float default ?, `filesort_cnt` float default ?, `filesort_sum` float default ?, `disk_filesort_cnt` float default ?, `disk_filesort_sum` float default ?, unique key `hostname_max` (`hostname_max`,`checksum`,`ts_min`,`ts_max`), key `ts_min` (`ts_min`), key `checksum` (`checksum`) ) engine=innodb default charset=utf?
Last Sample on host mysql.geoffreyanderson.net at 2012-04-10 14:29:14
More Samples 
CREATE TABLE `global_query_review_history` (
  `hostname_max` varchar(64) NOT NULL,
  `db_max` varchar(64) DEFAULT NULL,
  `checksum` bigint(20) unsigned NOT NULL,
  `sample` text NOT NULL,
  `ts_min` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ts_max` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ts_cnt` float DEFAULT NULL,
  `Query_time_sum` float DEFAULT NULL,
  `Query_time_min` float DEFAULT NULL,
  `Query_time_max` float DEFAULT NULL,
  `Query_time_pct_95` float DEFAULT NULL,
  `Query_time_stddev` float DEFAULT NULL,
  `Query_time_median` float DEFAULT NULL,
  `Lock_time_sum` float DEFAULT NULL,
  `Lock_time_min` float DEFAULT NULL,
  `Lock_time_max` float DEFAULT NULL,
  `Lock_time_pct_95` float DEFAULT NULL,
  `Lock_time_stddev` float DEFAULT NULL,
  `Lock_time_median` float DEFAULT NULL,
  `Rows_sent_sum` float DEFAULT NULL,
  `Rows_sent_min` float DEFAULT NULL,
  `Rows_sent_max` float DEFAULT NULL,
  `Rows_sent_pct_95` float DEFAULT NULL,
  `Rows_sent_stddev` float DEFAULT NULL,
  `Rows_sent_median` float DEFAULT NULL,
  `Rows_examined_sum` float DEFAULT NULL,
  `Rows_examined_min` float DEFAULT NULL,
  `Rows_examined_max` float DEFAULT NULL,
  `Rows_examined_pct_95` float DEFAULT NULL,
  `Rows_examined_stddev` float DEFAULT NULL,
  `Rows_examined_median` float DEFAULT NULL,
  `Rows_affected_sum` float DEFAULT NULL,
  `Rows_affected_min` float DEFAULT NULL,
  `Rows_affected_max` float DEFAULT NULL,
  `Rows_affected_pct_95` float DEFAULT NULL,
  `Rows_affected_stddev` float DEFAULT NULL,
  `Rows_affected_median` float DEFAULT NULL,
  `Rows_read_sum` float DEFAULT NULL,
  `Rows_read_min` float DEFAULT NULL,
  `Rows_read_max` float DEFAULT NULL,
  `Rows_read_pct_95` float DEFAULT NULL,
  `Rows_read_stddev` float DEFAULT NULL,
  `Rows_read_median` float DEFAULT NULL,
  `Merge_passes_sum` float DEFAULT NULL,
  `Merge_passes_min` float DEFAULT NULL,
  `Merge_passes_max` float DEFAULT NULL,
  `Merge_passes_pct_95` float DEFAULT NULL,
  `Merge_passes_stddev` float DEFAULT NULL,
  `Merge_passes_median` float DEFAULT NULL,
  `InnoDB_IO_r_ops_min` float DEFAULT NULL,
  `InnoDB_IO_r_ops_max` float DEFAULT NULL,
  `InnoDB_IO_r_ops_pct_95` float DEFAULT NULL,
  `InnoDB_IO_r_bytes_pct_95` float DEFAULT NULL,
  `InnoDB_IO_r_bytes_stddev` float DEFAULT NULL,
  `InnoDB_IO_r_bytes_median` float DEFAULT NULL,
  `InnoDB_IO_r_wait_min` float DEFAULT NULL,
  `InnoDB_IO_r_wait_max` float DEFAULT NULL,
  `InnoDB_IO_r_wait_pct_95` float DEFAULT NULL,
  `InnoDB_IO_r_ops_stddev` float DEFAULT NULL,
  `InnoDB_IO_r_ops_median` float DEFAULT NULL,
  `InnoDB_IO_r_bytes_min` float DEFAULT NULL,
  `InnoDB_IO_r_bytes_max` float DEFAULT NULL,
  `InnoDB_IO_r_wait_stddev` float DEFAULT NULL,
  `InnoDB_IO_r_wait_median` float DEFAULT NULL,
  `InnoDB_rec_lock_wait_min` float DEFAULT NULL,
  `InnoDB_rec_lock_wait_max` float DEFAULT NULL,
  `InnoDB_rec_lock_wait_pct_95` float DEFAULT NULL,
  `InnoDB_rec_lock_wait_stddev` float DEFAULT NULL,
  `InnoDB_rec_lock_wait_median` float DEFAULT NULL,
  `InnoDB_queue_wait_min` float DEFAULT NULL,
  `InnoDB_queue_wait_max` float DEFAULT NULL,
  `InnoDB_queue_wait_pct_95` float DEFAULT NULL,
  `InnoDB_queue_wait_stddev` float DEFAULT NULL,
  `InnoDB_queue_wait_median` float DEFAULT NULL,
  `InnoDB_pages_distinct_min` float DEFAULT NULL,
  `InnoDB_pages_distinct_max` float DEFAULT NULL,
  `InnoDB_pages_distinct_pct_95` float DEFAULT NULL,
  `InnoDB_pages_distinct_stddev` float DEFAULT NULL,
  `InnoDB_pages_distinct_median` float DEFAULT NULL,
  `QC_Hit_cnt` float DEFAULT NULL,
  `QC_Hit_sum` float DEFAULT NULL,
  `Full_scan_cnt` float DEFAULT NULL,
  `Full_scan_sum` float DEFAULT NULL,
  `Full_join_cnt` float DEFAULT NULL,
  `Full_join_sum` float DEFAULT NULL,
  `Tmp_table_cnt` float DEFAULT NULL,
  `Tmp_table_sum` float DEFAULT NULL,
  `Disk_tmp_table_cnt` float DEFAULT NULL,
  `Disk_tmp_table_sum` float DEFAULT NULL,
  `Filesort_cnt` float DEFAULT NULL,
  `Filesort_sum` float DEFAULT NULL,
  `Disk_filesort_cnt` float DEFAULT NULL,
  `Disk_filesort_sum` float DEFAULT NULL,
  UNIQUE KEY `hostname_max` (`hostname_max`,`checksum`,`ts_min`,`ts_max`),
  KEY `ts_min` (`ts_min`),
  KEY `checksum` (`checksum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
comments
Status:

Reviewed By:

90 Day History

Show Raw SQL Permalink 
SELECT DATE(ts_min) AS `date`,
  ROUND(SUM(Rows_examined_sum)/SUM(rows_sent_sum),2) AS `index_ratio`,
  SUM(Query_time_sum) / SUM(ts_cnt) AS `query_time_avg`,
  ROUND(SUM(Rows_sent_sum)/SUM(ts_cnt),0) AS `rows_sent_avg`,
  SUM(ts_cnt) AS `ts_cnt`,
  SUM(Query_time_sum) AS `Query_time_sum`,
  SUM(Lock_time_sum) AS `Lock_time_sum`,
  SUM(Rows_sent_sum) AS `Rows_sent_sum`,
  SUM(Rows_examined_sum) AS `Rows_examined_sum`,
  SUM(Tmp_table_sum) AS `Tmp_table_sum`,
  SUM(Filesort_sum) AS `Filesort_sum`,
  SUM(Full_scan_sum) AS `Full_scan_sum`
 FROM `global_query_review` AS `fact` 
 JOIN `global_query_review_history` AS `dimension` USING (`checksum`) 
 WHERE checksum = "17375832608889571510"
  AND dimension.ts_min >= "2026-02-23 17:40:23"
  AND dimension.ts_min <= "2026-05-24 17:40:23"
 GROUP BY date 
 ORDER BY date DESC 
 LIMIT 90
date index_ratio query_time_avg rows_sent_avg ts_cnt Query_time_sum Lock_time_sum Rows_sent_sum Rows_examined_sum Tmp_table_sum Filesort_sum Full_scan_sum