Box Anemometer: Slow Query Log

Last Sample on host mysql.geoffreyanderson.net at 2012-04-10 16:10:27

More Samples

SELECT * FROM Country where LocalName LIKE CONCAT('n','%')

Explain Plan

+----+-------------+---------+------------+------+---------------+-----+---------+-----+------+----------+-------------+
| id | select_type | table   | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra       |
+----+-------------+---------+------------+------+---------------+-----+---------+-----+------+----------+-------------+
| 1  | SIMPLE      | Country |            | ALL  |               |     |         |     | 239  | 11.11    | Using where |
+----+-------------+---------+------------+------+---------------+-----+---------+-----+------+----------+-------------+

Visual Explain Plan

Filter with WHERE
+- Table scan
   rows           239
   +- Table
      table          Country

Create Table Statements

CREATE TABLE `Country` (
  `Code` char(3) NOT NULL DEFAULT '',
  `Name` char(52) NOT NULL DEFAULT '',
  `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL DEFAULT 'Asia',
  `Region` char(26) NOT NULL DEFAULT '',
  `SurfaceArea` float(10,2) NOT NULL DEFAULT '0.00',
  `IndepYear` smallint DEFAULT NULL,
  `Population` int NOT NULL DEFAULT '0',
  `LifeExpectancy` float(3,1) DEFAULT NULL,
  `GNP` float(10,2) DEFAULT NULL,
  `GNPOld` float(10,2) DEFAULT NULL,
  `LocalName` char(45) NOT NULL DEFAULT '',
  `GovernmentForm` char(45) NOT NULL DEFAULT '',
  `HeadOfState` char(60) DEFAULT NULL,
  `Capital` int DEFAULT NULL,
  `Code2` char(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Table Status

                Name : Country
              Engine : InnoDB
             Version : 10
          Row_format : Dynamic
                Rows : 239
      Avg_row_length : 411
         Data_length : 98304
     Max_data_length : 0
        Index_length : 0
           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 :

Reviewed by Geoff on 2014-05-03 13:52:30 with status good

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 = "2362606619255509183"
  AND dimension.ts_min >= "2026-02-23 17:37:09"
  AND dimension.ts_min <= "2026-05-24 17:37:09"
 GROUP BY date 
 ORDER BY date DESC 
 LIMIT 90

Query 2362606619255509183

90 Day History