kVRN3S2b

1SET PROFILING=1;
2
3
4CREATE TABLE IF NOT EXISTS `bench_data` 
5(
6  `id`         bigint(20) NOT NULL      AUTO_INCREMENT PRIMARY KEY,
7  `datetime`   timestamp  NULL          DEFAULT CURRENT_TIMESTAMP,
8  `channel`    int(11)                  DEFAULT NULL,
9  `value`      float                    DEFAULT NULL
10
11);
12
13INSERT INTO `bench_data` (`datetime`,`value`,`channel`) VALUES (
14      FROM_UNIXTIME(UNIX_TIMESTAMP('2014-01-01 01:00:00')+FLOOR(RAND()*31536000)),
15      ROUND(RAND()*100,2),
16      1
17    );
18INSERT INTO `bench_data` (`datetime`,`value`,`channel`) VALUES (
19      FROM_UNIXTIME(UNIX_TIMESTAMP('2014-01-01 01:00:00')+FLOOR(RAND()*31536000)),
20      ROUND(RAND()*100,2),
21      1
22    );
23	INSERT INTO `bench_data` (`datetime`,`value`,`channel`) VALUES (
24      FROM_UNIXTIME(UNIX_TIMESTAMP('2014-01-01 01:00:00')+FLOOR(RAND()*31536000)),
25      ROUND(RAND()*100,2),
26      1
27    );
28select * from `bench_data` ORDER BY `value`;
29
30
31
32-- SHOW PROFILES ALL;
33SHOW PROFILE ALL;
34
35DROP TABLE IF EXISTS `bench_data`;
36SET PROFILING=0;