· 8 years ago · Jan 04, 2018, 08:02 PM
1CREATE TABLE IF NOT EXISTS details (
2 id int(11) NOT NULL,
3 date date NOT NULL,
4 time int(2) NOT NULL,
5 minutes_online decimal(5,0) NOT NULL,
6 minutes_playing decimal(5,0) NOT NULL,
7 minutes_chatting decimal(5,0) NOT NULL,
8 minutes_away decimal(5,0) NOT NULL
9 PRIMARY KEY (id,date,time)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
11
12mysql> SELECT * FROM details WHERE id = 3014595;
13
14mysql> EXPLAIN SELECT * FROM details WHERE id = 3014595;
15+----+-------------+-----------+------+---------------+---------+---------+-------+------+-------+
16| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
17+----+-------------+-----------+------+---------------+---------+---------+-------+------+-------+
18| 1 | SIMPLE | details | ref | PRIMARY | PRIMARY | 4 | const | 1482 | |
19+----+-------------+-----------+------+---------------+---------+---------+-------+------+-------+
20
21mysql> SHOW PROFILE FOR QUERY 1;
22+--------------------------------+----------+
23| Status | Duration |
24+--------------------------------+----------+
25| starting | 0.000024 |
26| checking query cache for query | 0.000078 |
27| checking permissions | 0.000014 |
28| Opening tables | 0.000126 |
29| System lock | 0.000011 |
30| Table lock | 0.000030 |
31| init | 0.000027 |
32| optimizing | 0.000117 |
33| statistics | 0.040077 |
34| preparing | 0.000029 |
35| executing | 0.000006 |
36| Sending data | 7.536960 |
37| end | 0.000013 |
38| query end | 0.000004 |
39| freeing items | 0.000037 |
40| storing result in query cache | 0.000006 |
41| logging slow query | 0.000003 |
42| cleaning up | 0.000006 |
43+--------------------------------+----------+
44
45Alter table tablename engine = 'INNODB'