| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Environment | |||||||||||||||||||
2 | 1 Proc | 3.01Ghz | ||||||||||||||||||
3 | 512 memory(recommended by VMWare) | |||||||||||||||||||
4 | ||||||||||||||||||||
5 | ||||||||||||||||||||
6 | ||||||||||||||||||||
7 | ||||||||||||||||||||
8 | ||||||||||||||||||||
9 | Query outcome | 10000000 | 10000000 | 8999 | 8999 | 116 | 116 | 2001040 | 2001040 | Empty set | 2001040 | 4236377 | 4236377 | 1499356 | 2997648 | 1000007 | 1000007 | |||
10 | MySQL Community Server | Average insert of 10 000 | Delete of 10 000 000 | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | |
11 | 5.1 | 0.22 | 165.72 | 18.83 | 18.47 | 0.38 | 0.01 | 20.45 | 18.5 | 28.45 | 18.53 | 20.27 | 18.53 | 37.84 | 19.73 | 30.83 | 35.55 | 24.03 | 23.45 | |
12 | 5.6-dev | 0.16 | 187.66 | 19.56 | 18.47 | 0.11 | 0 | 20.53 | 19.28 | 32.36 | 19.75 | 20.77 | 19.7 | 40.94 | 21.05 | 30.23 | 38.8 | 25.09 | 21.67 | |
13 | 5.2 | 0.19 | 221.5 | 21.58 | 21.33 | 0.16 | 0.02 | 25.78 | 22.09 | 43.03 | 23.48 | 31.19 | 33.25 | 50.5 | 22.55 | 34.19 | 42.84 | 27.77 | 23.3 | |
14 | ||||||||||||||||||||
15 | Q1 | select count(*) from test.testtable; | ||||||||||||||||||
16 | Q2 | select count(*) from testtable; | ||||||||||||||||||
17 | Q3 | SELECT * FROM testtable tst WHERE tst.id>1000 AND tst.id<10000; | ||||||||||||||||||
18 | Q4 | SELECT COUNT(*) FROM testtable tst WHERE tst.id>1000 AND tst.id<10000; | ||||||||||||||||||
19 | Q5 | SELECT * FROM testtable tst WHERE tst.testInt between 10000 AND 100000 ; | ||||||||||||||||||
20 | Q6 | SELECT COUNT(*) FROM testtable tst WHERE tst.testInt between 10000 AND 100000 ; | ||||||||||||||||||
21 | Q7 | SELECT * FROM testtable tst WHERE tst.testDouble between 0.1 AND 0.5 ; | ||||||||||||||||||
22 | Q8 | SELECT COUNT(*) FROM testtable tst WHERE tst.testDouble between 0.1 AND 0.5 ; | ||||||||||||||||||
23 | Q9 | SELECT * FROM testtable tst WHERE tst.testDouble <= 0.1 AND tst.testDouble > 0.5 ; | ||||||||||||||||||
24 | Q10 | SELECT COUNT(*) FROM testtable tst WHERE tst.testDouble >= 0.1 AND tst.testDouble < 0.5 ; | ||||||||||||||||||
25 | Q11 | SELECT * FROM testtable tst WHERE tst.testDate > '2005/08/04 07:00'; | ||||||||||||||||||
26 | Q12 | SELECT COUNT(*) FROM testtable tst WHERE tst.testDate > '2005/08/04 07:00'; | ||||||||||||||||||
27 | Q13 | SELECT * FROM testtable tst WHERE tst.testVarchar LIKE '%AAAAAA'; | ||||||||||||||||||
28 | Q14 | SELECT * FROM testtable tst WHERE tst.testVarchar LIKE '%AAAAAA' OR tst.testVarchar LIKE 'BBBBBB%'; | ||||||||||||||||||
29 | Q15 | SELECT * FROM testtable tst WHERE tst.testInt between 10000 AND 100000 AND tst.testDouble between 0.1 AND 0.5 AND tst.testDate > '2005/08/04 07:00' OR tst.id> 9000000 | ||||||||||||||||||
30 | Q16 | SELECT COUNT(*) FROM testtable tst WHERE tst.testInt between 10000 AND 100000 AND tst.testDouble between 0.1 AND 0.5 AND tst.testDate > '2005/08/04 07:00' OR tst.id> 9000000 | ||||||||||||||||||
31 | ||||||||||||||||||||
32 | Measurements in seconds. |