Shulou(Shulou.com)05/31 Report--

This article will explain in detail what is the difference between mysql on different platforms. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

This file contains the results of different benchmarks.

The number in () after the test result indicates the number of SQL commands executed in the precise test. A test can have many different parameters, and only a rough look is given here. Please check the source code for more information.

Note that test results using different-- cmp options cannot be compared. The-- cmp option is set according to the worst limit for all servers in the test.

The number marked'+'is estimated based on the results of the previous run, because the execution of the query exceeds the given time limit. This estimate will not be very different from the expected real result.

Marked'?' The number is a bad result. It can only be used to explain how long it took the server to produce this bad result:)

I hope this will give you some idea of how each database works.

I hope you like it. Luuk & Monty (1997)

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 350 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 350 MHz, 256m memory, key_buffer=16M"

6 mysql-SunOS_5.5.1_sun4u MySQL 3.22.19

UltraSPARC, 2 CPU 200 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 400 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

The results of each test (the first column is in seconds, followed by multiples 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

Result of each operation:

Alter_table_add (992) 453 0.99 2.56 2.59 6.74 1.71 6.77 1.38

Alter_table_drop 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 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 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 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.19 1.93 + 8.481.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 3 0.67 3.67 4.33 2.33 2.67 11.67 1.00

Update_key 3 1.33 0.33 0.67 0.33 0.33 1.00 0.67

Update_key_big 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 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

This is the end of this article on "what are the differences between mysql on different platforms". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.