Performance comparison experiment of MySQL on different operating platforms

mysql| performance This file contains the results of different benchmark tests.

The number in the after test result () represents the number of SQL commands executed in the exact test. A test can have a lot of different parameters, and here's just a rough look. Please check the source for more information.

Note that test results with different--cmp options cannot be compared. The--CMP option is set based on the worst restrictions for all servers in the test.

The number labeled ' + ' is estimated based on the last run result, because the execution of the query statement exceeds the given time limit. This estimate and the expected real results will not be far apart.

Marked out '? ' The number is a bad result. It can only be used to describe the time that the server took to produce this bad result:

Hopefully this will give you some understanding of how each database works ....

The first column is counted in seconds. The other columns are related to the first column. 1.00 means the same. A larger number indicates a slower speed.

This is the test result of the comparison of MySQL on different platforms. The test environment is:
1 mysql-linux_2.2.1_i686 MySQL 3.22.18
Pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16m
2 mysql_fast-linux_2.2.1_i686 MySQL 3.22.18--fast
Pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16m
3 Mysql-win98 MySQL 3.22.19a
"Amd-k6 MHz, 256M memory, key_buffer=16m"
4 mysql_odbc-win98 MySQL 3.22.19a--odbc
5 mysql-nt_4.0 MySQL 3.22.18 gamma
"Amd-k6 MHz, 256M memory, key_buffer=16m"
6 mysql-sunos_5.5.1_sun4u MySQL 3.22.19
UltraSPARC, 2 CPU MHz, 1G mem, key_buffer=8m
7 mysql-sunos_5.6_sun4m MySQL 3.22.6 Alpha
Sparc sun4m, 196M memory
8 mysql-sunos_5.7_sun4u MySQL 3.22.18
Ultrasparc-ii 2/cpu MHz, 2G mem, key_buffer=16m

Operation 1
MySQL 2
Mysql_fast 3
MySQL 4
MYSQL_ODBC 5
MySQL 6
MySQL 7
MySQL 8
Mysql

Results of each test (the first column is in seconds, followed by a multiple of the first column):
ATIS 66 0.95 3.67 4.47 2.33 3.14 15.00 1.58
Alter-table 812 0.99 2.66 2.69 7.08 1.64 3.90 1.31
Big-tables 49 1.00 4.55 5.08 3.67 2.65 12.24 1.53
Connect 151 0.99 3.69 10.78 3.13 2.13 8.86 1.05
Create 9 1.33 15.11 16.22 8.78 8.33 61.44 25.67
Insert 1558 0.93 +3.18 +3.91 5.92 2.33 +15.81 2.23
Select +1164 +0.98 +2.60 +2.78 +1.77 +2.69 +13.26 +1.56
Wisconsin 20 0.50 4.40 6.75 2.70 2.95 12.05 1.65

Results for each operation:
Alter_table_add (992) 453 0.99 2.56 2.59 6.74 1.71 6.77 1.38
Alter_table_drop (496) 343 1.01 2.79 2.81 7.50 1.56 1.22
Connect (10000) 31 1.00 2.55 10.87 2.61 2.55 8.77 0.97
Connect+select (10000) 35 0.97 3.06 14.60 2.77 2.49 9.09 1.09
COUNT (100) 62 0.98 1.45 1.50 1.58 2.11 7.92 1.06
Count_on_key (50100) +719 +0.97 +2.89 +3.03 +1.71 +3.06 +15.66 +1.79
Create+drop (1000) 1 1.00 25.00 27.00 17.00 22.00 154.00 69.00
Create_index (8) 9 0.67 2.44 2.44 6.67 1.22 5.33 1.00
Create_key+drop (1000) 3 1.00 9.00 10.00 8.33 6.67 53.67 22.33
Create_table (1031) 4 1.50 12.25 13.00 7.00 5.50 39.50 13.75
Delete_big (15) 156 0.15 1.33 1.36 7.88 2.10 47.74 1.79
Delete_key (500) 26 1.15 0.04 0.08 0.04 0.04 0.12 0.04
Drop_index (8) 6 1.17 3.67 3.67 10.00 2.00 8.00 1.33
Drop_table (1028) 1 1.00 7.00 9.00 2.00 10.00 80.00 41.00
Insert (350768) 147 0.31 5.07 8.16 3.64 2.96 10.78 1.95
Insert_duplicates (300000) 26 0.88 5.77 10.77 3.27 2.27 9.15 1.38
Insert_key (100000) 156 0.82 3.12 4.15 25.71 2.77 25.67 9.20
Insert_many_fields (2000) 13 1.08 2.54 2.85 4.15 3.08 12.23 1.38
Min_max (60) 38 1.00 1.29 1.34 1.34 2.26 9.55 1.13
Min_max_on_key (73000) 198 0.95 2.34 2.57 1.96 2.08 +10.33 1.25
Multiple_value_inser (100000) 9 1.00 6.44 4.44 2.67 2.67 10.44 1.56
Order_by (10) 72 1.11 5.39 6.82 2.83 2.99 +18.00 1.49
Order_by_key (10) 47 1.26 5.83 7.87 3.23 2.91 +17.17 1.77
Select (20000) 7 1.14 7.86 11.71 3.57 2.57 11.57 2.29
Select_big (10080) 91 1.11 5.18 6.54 3.55 1.96 12.63 1.32
SELECT_DISTINCT (800) 17 0.94 2.94 3.41 1.82 3.12 14.59 1.59
Select_group (3811) 105 0.97 2.45 2.57 1.63 2.89 12.70 1.37
Select_join (200) 26 1.08 4.50 5.46 2.35 3.46 18.19 1.69
Select_key (200000) 212 0.97 +3.99 +4.31 2.48 2.21 +9.26 1.24
Select_key_prefix (200000) 243 0.97 +3.52 +3.82 2.19 1.93 +8.48 1.16
Select_many_fields (2000) 35 1.00 5.37 6.00 3.40 2.54 12.54 1.60
Select_range (25420) 331 1.01 1.92 2.12 1.71 2.17 +8.88 1.14
Select_range_prefix (25010) 37 1.00 2.84 3.11 1.92 2.35 9.35 1.30
Select_simple (20000) 36 1.00 3.39 13.22 2.75 2.58 9.14 1.11
Select_simple_join (500) 3 0.67 3.67 4.33 2.33 2.67 11.67 1.00
Update_key (500) 3 1.33 0.33 0.67 0.33 0.33 1.00 0.67
Update_key_big (501) 37 1.08 1.51 1.59 1.19 2.22 10.27 1.46
Update_of_key (256) 79 2.59 1.37 1.39 16.62 1.89 12.35 2.43
Wisc_benchmark (114) 7 0.86 3.14 4.14 2.14 2.29 13.00 1.43
Total +3824 +0.96 +2.98 +3.65 +4.70 +2.33 +12.28 +1.82