Performance comparison experiment of MySQL on different operating platforms

Source: Internet
Author: User
Tags comparison insert connect mysql time limit
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.