Box Anemometer

Query 14954866110874212198

First Seen: 2012-04-10 14:33:38
Last Seen: 2012-04-10 14:34:32
Fingerprint
insert into `countrylanguage` values(?+)
Last Sample on host mysql.geoffreyanderson.net at 2012-04-10 14:34:32
More Samples 
INSERT INTO `CountryLanguage` VALUES ('EST','Estonian','T',65.3)
Create Table Statements 
CREATE TABLE `CountryLanguage` (
  `CountryCode` char(3) NOT NULL DEFAULT '',
  `Language` char(30) NOT NULL DEFAULT '',
  `IsOfficial` enum('T','F') NOT NULL DEFAULT 'F',
  `Percentage` float(4,1) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`CountryCode`,`Language`),
  KEY `CountryCode` (`CountryCode`),
  CONSTRAINT `countryLanguage_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `Country` (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Table Status 
                Name : CountryLanguage
              Engine : InnoDB
             Version : 10
          Row_format : Dynamic
                Rows : 984
      Avg_row_length : 99
         Data_length : 98304
     Max_data_length : 0
        Index_length : 65536
           Data_free : 0
      Auto_increment : 
         Create_time : 2025-01-14 23:51:58
         Update_time : 
          Check_time : 
           Collation : latin1_swedish_ci
            Checksum : 
      Create_options : 
             Comment :
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 = "14954866110874212198"
  AND dimension.ts_min >= "2026-02-23 17:37:34"
  AND dimension.ts_min <= "2026-05-24 17:37:34"
 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